CODEWITHSUNDEEP
mysqllinux
Pez
Pez

Reputation: 1299

MySQL process running for long time, slowed server to crawl, how to debug

A system I work on was down to an absolute crawl this morning.

I ran ps -eh to see if I could find anything, and there was a mysql process that had been running for over 46 minutes.

I restarted MySQL and everything sped right back up, running just like normal.

Now I'm keeping an eye on the open processes and I see that MySQL is once again creeping up in time...every time I refresh a few more seconds are added to it, eg an hour ago it said it had been running for 19 seconds, and every few minutes I refresh and there's another second...now it's up to about 50 seconds. It has been consistently a second or two higher every time I run ps -eh.

I ran mysql > SHOW PROCESSLIST and the only process that came up was the SHOW PROCESSLIST process...so I don't think there are any queries hanging, but tbh I don't know.

Anyone have any tips how I might go about debugging this issue? This is on a GoDaddy VDS (CentOS) system.

Upvotes: 1

Views: 2669

Answers (1)

Jay D.
Jay D.

Reputation: 672

You might want to look into the slow queries log to catch the query slowing down the box. http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

Upvotes: 1

Related Questions