Percona Audit Log Plugin May 2026

-- Filtering SET GLOBAL audit_log_include_accounts = 'app_user@%'; SET GLOBAL audit_log_include_commands = 'INSERT,UPDATE,DELETE'; SET GLOBAL audit_log_include_databases = 'prod'; SET GLOBAL audit_log_exclude_commands = '';

SET GLOBAL audit_log_exclude_accounts = 'root@localhost,admin@%'; | Problem | Likely cause | Solution | |---------|--------------|----------| | No logs written | Plugin not loaded | SHOW PLUGINS; – if missing, reinstall | | Log file huge | No filters applied | Set audit_log_exclude_commands = 'SHOW,SELECT' etc. | | Performance drop | SYNCHRONOUS strategy | Change to ASYNCHRONOUS | | Rotation not working | audit_log_rotate_on_size = 0 | Set positive value | | Missing JSON format | Using OLD format | Set audit_log_format = 'NEW' | percona audit log plugin

Check errors:

SHOW VARIABLES LIKE 'audit_log%'; SHOW ERRORS; Goal : Log all INSERT , UPDATE , DELETE from app_user on database prod , except on table temp_cache . SET GLOBAL audit_log_include_commands = 'INSERT