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 | - - - - - - - - -
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
