Solved

Why do processes sleep when doing show processlist

Posted on 2006-07-11
2
1,294 Views
Last Modified: 2009-09-04
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
Comment
Question by:ditkis
  • 2
2 Comments
 
LVL 30

Expert Comment

by:todd_farmer
ID: 17086360
#

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
 
LVL 30

Accepted Solution

by:
todd_farmer earned 250 total points
ID: 17086367
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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now