Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199903

[PHP3] mysql: too many connections From: Jeremiah Bellomy (jeremiah <email protected>)
Date: 03/31/99

Yesterday, I ran into the following errors:
MySQL: Link to server lost, unable to reconnect in db_mysql.inc on line 36
Too many connections in db_mysql.inc on line 36

Line 36 of db_mysql.inc:
$this->Link_ID=mysql_pconnect($this->Host, $this->User, $this->Password);

I think that I have discovered why I got this error, but I would like
feedback to verify that my thinking is correct.

The errors were the result of mysql hitting it's max_connections which was
set at 100. I have 3 unique host,user,password combinations possible which
means that each apache child will hold 3 persistent connections open. Upon
further investigation, I found that a coworker had set apache's
MaxSpareServers 48, so I had the potential to easily reach 144 persistent
mysql connections which was well over the max_connections setting. By
reducing the apache MaxSpareServers which will reduce the number of apache
children waiting for requests, will I reduce the chance of getting mysql
"too many connection" errors?

Now for a few questions, some a bit off topic for the list. On a Redhat 5.2
box, which I believe has a file descriptor limit of 256, how high can I set
mysql max_connections before running into resource limits? I currently have
about 60 virtual servers running on a single apache server pool. Ten of
these are NameBased on one IP. Occasionally these ten virtual servers hang
while leaving all others running as usual. Any ideas on the cause or how I
can track down the cause of this hang?

redhat 5.2 (Kernel 2.0.36 on an i686)
apache 1.3.6
php 3.0.7
mysql-3.22.20a (TCX binary)

Thanks for any help.
-Jeremiah Bellomy 

--
PHP 3 Mailing List   http://www.php.net/
To unsubscribe send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest list:  php3-digest-subscribe <email protected>
For help: php3-help <email protected>  Archive:  http://www.php.net/mailsearch.php3
List administrator:  zeev-list-admin <email protected>