MySQL Forums :: General :: To many sleeping connections

Advanced Search

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.

Options: ReplyQuote

Subject Written By Posted
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.