Percona Audit Log Plugin ((link)) May 2026

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 . percona audit log plugin

-- Enable plugin INSTALL PLUGIN audit_log SONAME 'audit_log.so'; -- Configure SET GLOBAL audit_log_format = 'NEW'; SET GLOBAL audit_log_strategy = 'ASYNCHRONOUS'; SET GLOBAL audit_log_rotate_on_size = 52428800; -- 50 MB Check errors: SHOW VARIABLES LIKE 'audit_log%'; SHOW ERRORS;

-- Verify SHOW VARIABLES LIKE 'audit_log%'; Check errors: SHOW VARIABLES LIKE 'audit_log%'

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: