: Operates asynchronously by default to minimize impact on database performance. Installation & Basic Setup
SET GLOBAL audit_log_policy = 'ALL';
-- Configure (dynamic) SET GLOBAL audit_log_format = 'NEW'; SET GLOBAL audit_log_file = '/var/log/mysql/audit.log'; SET GLOBAL audit_log_rotate_on_size = 104857600; SET GLOBAL audit_log_rotations = 9; SET GLOBAL audit_log_strategy = 'ASYNCHRONOUS'; SET GLOBAL audit_log_policy = 'ALL'; percona audit plugin
:
(enable in logs):
SHOW VARIABLES LIKE 'audit_log%';
: Logs connections, disconnections, and queries (including INSERT , UPDATE , DELETE ). : Operates asynchronously by default to minimize impact
By default, the plugin starts logging immediately. However, you usually need to fine-tune what gets logged to avoid performance hits or massive log files.
: Operates asynchronously by default to minimize impact on database performance. Installation & Basic Setup
SET GLOBAL audit_log_policy = 'ALL';
-- Configure (dynamic) SET GLOBAL audit_log_format = 'NEW'; SET GLOBAL audit_log_file = '/var/log/mysql/audit.log'; SET GLOBAL audit_log_rotate_on_size = 104857600; SET GLOBAL audit_log_rotations = 9; SET GLOBAL audit_log_strategy = 'ASYNCHRONOUS'; SET GLOBAL audit_log_policy = 'ALL';
:
(enable in logs):
SHOW VARIABLES LIKE 'audit_log%';
: Logs connections, disconnections, and queries (including INSERT , UPDATE , DELETE ).
By default, the plugin starts logging immediately. However, you usually need to fine-tune what gets logged to avoid performance hits or massive log files.