Hi, please read the link I posted. You need to call SET audit_Log_flush=1 as part of your log rotate script, to reopen the log file after rotation. Flush logs doesn’t apply to the audit log. See also How to rotate audit log manually with audit_log plugin in Percona MySQL 8.0.20?
1 Like