title: MySQL process running for long time, slowed server to crawl, how to debug
body: <p>A system I work on was down to an absolute crawl this morning.</p>
  
  <p>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.</p>
  
  <p>I restarted MySQL and everything sped right back up, running just like normal.</p>
  
  <p>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.</p>
  
  <p>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.</p>
  
  <p>Anyone have any tips how I might go about debugging this issue? This is on a GoDaddy VDS (CentOS) system.</p>