On Tue, Jan 15, 2002 at 01:11:34PM -0800, James Montebello wrote:
>
> If the client closes the connection grace fully (using the MySQL
> handshaking to close the connection), then it will be cleaned up.
Yep.
> If the client severed the connection w/o performing the close
> handshake (say, if it
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: (4
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
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&#
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 somet
