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
|