This is caused by a connection that's still held open by a client, or (more commonly) by a connection that wasn't closed gracefully by the client. One of the oddities of TCP is that one end of the connection won't "know" that the other end has dropped the connection until it tries to write something to the connection. Since MySQL doesn't write except in reply to a query, it's sitting there with one end of a dead connection patiently waiting for a new query to arrive.
james montebello On Tue, 15 Jan 2002, Greer, Darren (MED) wrote: > Hello again all. Thanks for the help on the query time issue, I have > begun a transition. > > I have another question. I have some queries which are apparently going > into a "Sleep" mode in my database. Can anyone point me in the right > direction on this for more information? > > Thanks, > > Darren > > +----+-----------------+------------+--------+---------+-------+-------+ > ------------------+ > | Id | User | Host | db | Command | Time | State | Info | > +----+-----------------+------------+--------+---------+-------+-------+ > ------------------+ > | 15 | web | localhost | mailer | Sleep | 47743 | NULL | NULL | > | 20 | adssurvey | 66.6.196.2 | mailer | Sleep | 370 | NULL | NULL | > | 22 | root | localhost | mailer | Query | 0 | NULL | show processlist | > +----+-----------------+------------+--------+---------+-------+-------+ > ------------------+ > 3 rows in set (0.00 sec) > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
