How can compress Percona MySQL8 audit logs

MySQL & MariaDB Percona Server for MySQL 8.0
1

Dear Team,

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.

Regards,

1 Like
2

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.

1 Like
3

Probably you can refer to below:

4

Thanks for updating this topic.
Probably when the question was asked the plugin was not released
Here is the note for audit log filter plugin