: Use ASYNCHRONOUS + separate fast disk (SSD) for audit log file.
Logging everything ( ALL ) can kill performance on busy servers. Percona provides fine-grained filtering.
You can verify the installation by checking for "audit" in the information_schema.PLUGINS table. Audit plugin - Percona Server for MySQL 8.0 percona audit plugin
: Supports output in JSON , XML , or CSV formats.
"rule": "user": "monitor_user", "log": false : Use ASYNCHRONOUS + separate fast disk (SSD)
: Allows including or excluding specific users, commands, or databases from being logged.
If > 0, increase audit_log_buffer_size (default 1MB → set to 4–8MB). or CSV formats. "rule": "user": "monitor_user"
The most powerful feature is rule-based filtering. Set via audit_log_filter variable (dynamic).
Ignore commands that usually create noise (like PING or SLEEP).
Apply filter: