plugin-load = audit_log.so
audit-log = FORCE_PLUS_PERMANENT
audit_log_policy = ALL
audit_log_format = OLD
audit_log_rotate_on_size = 1M
audit_log_rotations = 31
audit_log_file = /var/lib/mysql/mysql_audit/audit.log
Is there any way to compress the audit logs.
I don’t see any variable to control the compression of Audit logs in the Percona server yet.
At this point, I think your 31 files of 1M would be just 31M, so I suggest managing it using the internal audit plugin without compression.
However, if you need compression, you can use other log rotation tools to manage the logs, like logrotate etc.