Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199903

Re: [PHP3] mysql: too many connections From: Chad Cunningham (ccunning <email protected>)
Date: 03/31/99

Why not just bump up the max persistant connections? I don't think going from 100
to 144 is going to hurt performance much.

Jeremiah Bellomy wrote:

> 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> 

--
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>