Why do processes sleep when doing show processlist

Hello,

When querying "SHOW PROCESSLIST" we always have some processes sleeping for 400-600 seconds. What can possible couse that? We are using MySQL 4.1 mixed MyISAM and InnoDB environment.

Thanks
ditkisAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
todd_farmerConnect With a Mentor Commented:
Basically, you have a client connection that has been opened and not yet closed, but has not submitted a query or statement in the past 400-600 seconds.
0
 
todd_farmerCommented:
#

Sleeping

The thread is waiting for the client to send a new statement to it.

From http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html
0
All Courses

From novice to tech pro — start learning today.