Percona Audit Log Plugin [BEST]

-- Exclude 'test' and 'tmp' DB SET GLOBAL audit_log_exclude_databases = 'test,tmp';

| Strategy | Performance Impact | Guarantee | |----------|------------------|------------| | ASYNCHRONOUS | Very low | Best effort | | PERFORMANCE | Low | Might lose few records on crash | | SEMISYNCHRONOUS | Medium | Better durability | | SYNCHRONOUS | High (flushes on every query) | Every query logged | percona audit log plugin

All audit log settings are (can be changed without restarting) using SET GLOBAL . -- Exclude 'test' and 'tmp' DB SET GLOBAL

SET GLOBAL audit_log_enabled = ON;

The plugin is included with but is disabled by default. percona audit log plugin

– but be aware that sqltext may contain them if written in plain. Use parameterized queries.