Scenario: Client gets a connection from MySQL. The client process is killed i.e. client does not close the connection to MySQL.
Observation: When I use "Show ProcessList" command to look at all the open connections, the connection with the client (terminated abnormally) doesn't show up in the list. Question: a. Will the connection held by an Abnormally Terminated Client automatically be closed by MySQL server??? b. If Yes is the answer to the previous question, how does MySQL detect this?? c. Is there a timeout associated with each client connection?? If so, how can I change this?? Thanks Jawahar