Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1330
  • Last Modified:

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
0
ditkis
Asked:
ditkis
  • 2
1 Solution
 
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
 
todd_farmerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now