Auto clean SLOW MYSQL QUERY LOGs

[ned-bs]

Hi there, My hosting company warned me that my slow log query table reached to 7GB. I deactivated it and clear the logs. But I suggest to have an option to auto clean some logs. Let's say keep last x days of log and delete older logs automatically.

[dhilditch]

Good idea.

@hmkayani:

Add option in Slow Query Log tab of Scalability Pro:

[x] Delete logs older than [y] days

x = checkbox y = numeric input

Then if x is set to true, enable a nightly cron and have that cron double check the [x] is checked and to delete log entries older than [y] days.

If [x] is set to false, delete the nightly cron. Still please check [x] value inside the cron - I like 'belt & braces' approach since there is so much variety of code in WordPress it's good practice to add doublechecks everywhere really.