Percona Audit Log Plugin Jun 2026

When file reaches 100MB, it becomes audit.log.1 , then audit.log.2 , etc. Total 9 old files kept.

UNINSTALL PLUGIN audit_log;

– send logs to remote syslog or SIEM.

SET GLOBAL audit_log_enabled = ON;

SHOW STATUS LIKE 'Audit_log%';

Without filters, audit logs grow enormous. Use / audit_log_exclude_accounts and audit_log_include_commands / audit_log_exclude_commands . percona audit log plugin

[mysqld] audit_log_policy = ALL audit_log_format = JSON audit_log_file = /var/log/mysql/audit.json audit_log_rotate_on_size = 100M audit_log_rotations = 10 ``` Use code with caution. Strategic Logging Policies When file reaches 100MB, it becomes audit