How to delete old audit.log files automatically

[anandkumar kishanrao]

Hi,

I enabled server audit logs using audit_log plugin in mysql enterprise edition 8.x. My requirement is to delete automatically audit log files which are older than 30 days.
one way i could think of is write job that checks time stamp of audit log files and delete it if time stamp is older than 30days. and run this job on daily basis.
is there any other way to achieve it. if this is the only way than can you please help me on how to write job in mysql.


Regards,
Anand