<div>
#<br />
<br />
Sleeping<br />
<br />
The thread is waiting for the client to send a new statement to it.<br />
<br />
From <a href="http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html</a>
</div>


#

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 [http://dev.mysql.com/doc/refman/5.0/en/show-processlist.html]

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
When querying &quot;SHOW PROCESSLIST&quot; 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.<br />
<br />
Thanks
</div>
</div>


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

Why do processes sleep when doing show processlist

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.