Percona Audit Plugin Here

The plugin is typically included but not activated:

SET GLOBAL audit_log_rotate = ON;

| Variable | Description | Typical Setting | |----------|-------------|----------------| | audit_log_format | OLD , NEW (JSON), CSV | NEW | | audit_log_file | Log file path | /var/log/mysql/audit.log | | audit_log_rotate_on_size | Auto-rotate when file exceeds bytes | 104857600 (100MB) | | audit_log_rotations | Number of rotated files to keep | 9 | | audit_log_strategy | ASYNCHRONOUS , PERFORMANCE , SEMISYNCHRONOUS | ASYNCHRONOUS | | audit_log_policy | ALL , LOGINS , QUERIES , NONE | ALL (then use filters) | | audit_log_filter | JSON filter rule (advanced) | See below | | audit_log_syslog_facility | Syslog facility if using syslog | LOG_LOCAL0 | percona audit plugin

"class": "table_access", "command": ["DROP", "ALTER", "TRUNCATE"], "log": true The plugin is typically included but not activated: