I'm using php with mysql. I am connecting through putty and I run the command for processlist. Lately I am seeing many threads with the command "sleep" in them. My site and the database are running smoothly, but I am seeing up to 200-300 threads like this with the command "sleep". Can anyone tell me what may be causing this and how do I resolve it? Or is it normal to see this when your site grows to a certain size?
mysql> show processlist;
+---------+-----------+----------------------+------ -+---------+-------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+---------+-----------+----------------------+-----------+---------+-------+-------+------------------+
| 2134180 | something | host_something:36170 | something | Sleep | 0 | | NULL |
| 2134189 | something | host_something:36180 | something | Sleep | 1 | | NULL |
| 2134194 | something | host_something:36185 | something | Sleep | 10 | | NULL |
| 2134199 | something | host_something:36190 | something | Sleep | 1 | | NULL |
| 2134214 | something | host_something:36206 | something | Sleep | 4 | | NULL |
| 2134222 | something | host_something:36214 | something | Sleep | 1 | | NULL |
| 2134225 | something | host_something:36217 | something | Sleep | 1 | | NULL |
+---------+----- --+----------------------+------ -+----- ---+-------+-------+------------------+
156 rows in set (0.00 sec)
