Percona: Audit Plugin

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

"rule": "user": "monitor_user", "log": false percona audit plugin

: Use ASYNCHRONOUS + separate fast disk (SSD) for audit log file. 9. Log Rotation & Management Manual rotation (closes current, reopens): /var/log/mysql/audit

SET GLOBAL audit_log_rotate = ON; :

[mysqld] audit_log_rotate_on_size = 104857600 audit_log_rotations = 9 Old files: audit.log.1 , audit.log.2 , ... " endscript "rule": "user": "monitor_user"