SHOW STATUS LIKE 'audit_log%'; -- e.g., audit_log_current_size, audit_log_buffer_size, audit_log_lost_events (critical):
: Use ASYNCHRONOUS + separate fast disk (SSD) for audit log file. 9. Log Rotation & Management Manual rotation (closes current, reopens): percona audit plugin
status: 1 = failure. "rule": "class": "table_access", "table": "payments", "command": ["DROP", "TRUNCATE", "DELETE", "UPDATE"], "log": true SHOW STATUS LIKE 'audit_log%'; -- e
"class": "table_access", "command": ["DROP", "ALTER", "TRUNCATE"], "log": true SHOW STATUS LIKE 'audit_log%'
SET GLOBAL audit_log_rotate = ON; :
(if using syslog or custom paths):