__link__ - Percona Audit Plugin

SELECT VARIABLE_VALUE FROM performance_schema.global_status WHERE VARIABLE_NAME = 'audit_log_lost_events'; If > 0, increase audit_log_buffer_size (default 1MB → set to 4–8MB).

Apply filter:

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

SET GLOBAL audit_log_logging_events = 'connect,query,table_access'; : SELECT VARIABLE_VALUE FROM performance_schema

"class": "connection", "event": "connect", "status": 1, "log": true , : "class": "connection"

[mysqld] audit_log_rotate_on_size = 104857600 audit_log_rotations = 9 Old files: audit.log.1 , audit.log.2 , ...

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