Percona Audit Plugin File

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

"msg-type": "activity", "date": "2023-10-27T10:15:30.000Z", "thread-id": "25", "query-id": "100", "user": "admin", "ip": "192.168.1.50", "host": "app-server-01", "pid": "12345", "os_user": "app_user", "appname": "mysqld", "rows": "1", "cmd": "QUERY", "query": "SELECT * FROM users WHERE id = 1", "status": "0" percona audit plugin

If > 0, increase audit_log_buffer_size (default 1MB → set to 4–8MB). /var/log/mysql/audit

"class": "connection", "event": "connect", "status": 1, "log": true , " endscript "msg-type": "activity"