How to Manually Rotate the MySQL Enterprise Audit Log

To rotate the MySQL Enterprise Audit Log

1. Rename the existing audit log, for example:

$ mv audit.log audit.log.bak

2. Flush the log using the audit_log_flush variable:

SET GLOBAL audit_log_flush = 1;

Note: Flushing the audit log using audit_log_flush is only supported when audit_log_rotate_on_size = 0.

audit_log_rotate_on_size is dynamic. You can temporarily set it to 0 for manually rotating purpose.