View Single Post
  #1 (permalink)  
Old 02-04-2007, 23:01
ebotunes ebotunes is offline
Junior Member
 
Join Date: Feb 2007
Posts: 5
Default Mysql processes sleeping/locked

i have had problems with my MySQL Server service stopping 'randomly'. The support staff said that it was running out of connections. I am recently upgraded to PHP 5/MySQL 5. I have never had this problem before running the same code on PHP 4/MySQL 4

Looking at the 'Show MySQL Processes' section of WHM I see:

+-----+-------+-----------+---------------+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+-------+-----------+---------------+---------+-------+-------+------------------+
| 250 | simon | localhost | simon_ffl0607 | Sleep | 28616 | | |
| 252 | simon | localhost | simon_ffl0607 | Sleep | 28608 | | |
| 254 | simon | localhost | simon_ffl0607 | Sleep | 28635 | | |
| 257 | simon | localhost | simon_ffl0607 | Sleep | 5943 | | |
| 259 | simon | localhost | simon_ffl0607 | Sleep | 28633 | | |
| 261 | simon | localhost | simon_ffl0607 | Sleep | 28628 | | |
| 264 | simon | localhost | simon_ffl0607 | Sleep | 5919 | | |
| 432 | simon | localhost | simon_ffl0607 | Sleep | 5964 | | |
| 844 | root | localhost | | Query | 0 | | show processlist |
+-----+-------+-----------+---------------+---------+-------+-------+------------------+


How do I stop these processes, or more importantly find out how they are getting stuck in the first place?

Thanks!!
Iain
Reply With Quote