MySQL Forums :: General :: To many sleeping connections
To many sleeping connections
Posted by: David Thome ()
Date: February 09, 2012 07:01AM
The MySQL Workbench shows a lot of connections listed as sleep. From what I understand our software creates a new connection each time it queries MySQL and after it is done with the query a short time later the connection goes to sleep. Consequently we have a lot of connections that are shown as sleep. From what I have learned setting up MySQL in interactive mode will allow connections to be reused. Is this correct and should we be using this mode or what else can we do to cut down on all those sleep connections? We are using the MYSQL ODBC driver for connections and for 5.1.019 I do see an option for Interactive client.
|To many sleeping connections||David Thome||02/09/2012 07:01AM|
|Re: To many sleeping connections||Rick James||02/11/2012 12:24AM|
|data insert||chaitali chattopadhyay||02/24/2012 04:51AM|
|Re: data insert||Rick James||02/25/2012 05:38AM|
|Re: data insert||santino6250 santino||02/27/2012 07:05PM|
|Re: data insert||santino6250 santino||02/28/2012 01:16AM|
|Re: data insert||Rick James||03/10/2012 04:35PM|
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.