Re: To many connections problem with LAMP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 4 Sep 2003, Balaji H. Kasal wrote:

> > 
> > 	It is usually better not to use persistenc connections.
> > 	So drop the pmysql_connect or if you really need to use
> > 	them set set max connections higher for mysql.
> 
>    Which problem it has? 

	On a really busy site persistent connections will just
	pile up and in the end the sql server will reach its
	max connections limit. Unless you will do many connects
	per page you will virtually gain almost nothing by
	using persistent connections.

	If you absolutely need to use persistent connections 
	you can stop max connections filling up by dropping
	MaxRequestsPerChild from httpd.conf to something 
	like 150 or lower. This way unnesseccary connections
	get killed when the Apache child dies.

-- 
Mika Tuupola                      http://www.appelsiini.net/~tuupola/

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux