2025-03-15T10:23:45 UTC,app_user[app_user] @ localhost [],localhost,INSERT,INSERT INTO orders...,ecommerce,0 OLD (XML – deprecated but still works) <AUDIT_RECORD> <TIMESTAMP>2025-03-15T10:23:45 UTC</TIMESTAMP> <USER>app_user[app_user] @ localhost []</USER> <COMMAND>INSERT</COMMAND> <SQLTEXT>INSERT INTO orders...</SQLTEXT> </AUDIT_RECORD> Set format:
-- Verify SHOW VARIABLES LIKE 'audit_log%'; percona audit log plugin
[mysqld] plugin-load-add = audit_log.so audit_log = FORCE_PLUS_PERMANENT SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'audit%'; 3. Basic Configuration All audit log settings are dynamic (can be changed without restarting) using SET GLOBAL . app_user[app_user] @ localhost []
Check errors: