I had enabled MySQL Query Log for checking which queries are getting executed from our application at certain time interval.
I wanted Logs to be refreshed for 3 days once, So I had enabled Expiry Log days as 3 days.
But when I saw the log file, the log was there from the date of enabled the Query Log which was more than a week.
Due to this the log file got increased to more than 2 GB file which was not able to get the information from it.
Is there any option to enable so that Query Log file will be refreshed/purged after some days.
I am using MySQL 5.0.24 server.