Re: MySQL Persistent connection is TOO persistent???

On Tue, 28 Aug 2001, Brian Grayless wrote: > Gotta problem.... > > For some reason, many of my persistent connections aren't terminating. I end > up with up to 30 connections to MySQL that aren't being used. My guess is > that the user connection is slow and the script never finishes running or > something. > > Is there a way to get all my connections to close, or is there a PHP script > that can close any unused connections??? Regarding persistent connections, this is how I believe it works: In apache httpd.conf you have: MinSpareServers 5 MaxSpareServers 10 The MaxSpareServers gives you the maximum of apache daemons running simultaneously. In php.ini, you have these statements: mysql.max_persistent = -1 -1 is default, change this to the number of maximum persistent connections per apache daemon. This will give you the following formula: total_persistent_connections = MaxSpareServers * mysql.max_persistent The MySQL-configuration my.cnf: set-variable = max_connections=255 set-variable = wait_timeout=3600 Make sure that total_persistent_connections is less than max_connections, to give you some overhad for non persistent connections and other mysql sessions. The wait_timeout variable is simply the maximum idle time for a connection to exist. Lower it if you have still have problems with the php persistent connections. This should really be in the FAQ. -- patrik wallstrom | f o o d f i g h t tel: +46-8-6188428 | s t o c k h o l m gsm: +46-709580442 | - - - - - - - - -