MySQL Process Time

[RYan Klockner]

Roughly every 5-10 days my server gets bogged down and has to be rebooted. Upon investigation, it seems that the mysql process time slowly increases until the website becomes unusable.

I SSH into the server and issues "top" command:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
15503 mysql 15 0 156m 48m 5084 S 0.6 4.8 511:47.99 mysqld

The column of note is the "TIME+" column. After reboot, that becomes 0:13.95, and works its way up from there.

It would seem to me that the mysql process is what is slowing the server down. The problem is that I don't know what to do about it.

My thoughts are that maybe there is a loop in my code that could be causing this, but when I type "SHOW PROCESSLIST" into MySQL command line, it doesn't show anything out of the ordinary.

I do have a cron job that runs every five minutes that sends out alerts to users of the software, but I have checked this code numerous times.

Any help would be appreciated. Thanks!