Percona Audit Plugin May 2026

"rule": "user": "monitor_user", "log": false

/var/log/mysql/audit.log daily rotate 30 compress delaycompress postrotate mysql -e "SET GLOBAL audit_log_rotate = ON;" endscript percona audit plugin

: Use ASYNCHRONOUS + separate fast disk (SSD) for audit log file. 9. Log Rotation & Management Manual rotation (closes current, reopens): "rule": "user": "monitor_user"

SET GLOBAL audit_log_filter = ' ... json ... '; "audit_record": "timestamp": "2025-02-18T10:23:45.123 UTC", "id": 202502, "class": "general", "event": "status", "connection_id": 54321, "user": "webapp@10.0.1.55", "host": "10.0.1.55", "database": "ecommerce", "command": "Query", "sqltext": "UPDATE orders SET status='shipped' WHERE order_id=12345", "status": 0, "rows_examined": 1, "rows_sent": 0 "audit_record": "timestamp": "2025-02-18T10:23:45.123 UTC"

(if using syslog or custom paths):