I got a problem with MySQL running for a couple of days. After a while the CPU usage gets higher and higher. If I stop MySQl and restart it is back to normal for a while. Any Ideas how to avoid this?
Im no whizz at this but you could try making a .bat file (if running windows like me) and get it to run every 24 hours to close mysql and start it again.
I do the same with my webserver to rotate the logs once a week.