Queries entering Sleep state.
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
Re: Queries entering Sleep state.
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
RE: Queries entering Sleep state.
If say, that client closes the connection at some point in the future...that will clean up then? Or has the connection been severed? -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 1:59 PM To: Greer, Darren (MED) Cc: '[EMAIL PROTECTED]' Subject: Re: Queries entering Sleep state. 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
RE: Queries entering Sleep state.
If the client closes the connection grace fully (using the MySQL handshaking to close the connection), then it will be cleaned up. If the client severed the connection w/o performing the close handshake (say, if it closed the socket, or simply exited, which also closes the socket), then it won't be cleaned up. If it can be determined these connections really aren't in use, they can be KILL'd at the server. james montebello On Tue, 15 Jan 2002, Greer, Darren (MED) wrote: If say, that client closes the connection at some point in the future...that will clean up then? Or has the connection been severed? -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 1:59 PM To: Greer, Darren (MED) Cc: '[EMAIL PROTECTED]' Subject: Re: Queries entering Sleep state. 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
Re: Queries entering Sleep state.
On Tue, Jan 15, 2002 at 02:59:05PM -0600, Greer, Darren (MED) wrote: If say, that client closes the connection at some point in the future...that will clean up then? Then the entry will vanish from the list. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 12 days, processed 301,555,611 queries (270/sec. avg) - 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
