Mysql processes sleeping/locked

[ebotunes]

i have had problems with my mysql 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

[hairyfreak]

If they are running out of connections, you may be running too many queries from the same page. Try finding the page(s) that cause the resulting errors, and check the queries inside. It may be that one has a simple typographical error and, as such, is causing a multitude of queries to be sent to the server, maxing out your connections to the database.

Alternatively, I believe that in the MySQL section or phpMyAdmin of cPanel (I'm afraid I can't be more specific as I haven't checked in a long time) you can disconnect users from the databases and close certain connections. The support staff may be able to offer more help here.