MySQL Forums
Forum List  »  General

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

Written By
To many sleeping connections
February 09, 2012 07:01AM
February 11, 2012 12:24AM
February 24, 2012 04:51AM
February 25, 2012 05:38AM
February 27, 2012 07:05PM
February 28, 2012 01:16AM
March 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.