Re: Too Many Connections
| From: | CPT John W. Holmes | Date: | Fri, 18 Apr 2003 19:14:50 +0000 |
| Subject: | Re: Too Many Connections | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-144429@lists.php.net to get a copy of this message | ||
> I am getting a "Too Many Connections" error now with MySQL. I've done some
> searching here to find solutions, but, was wondering if anyone knew of any
> sites that have detailed info about how to resolve this problem in MySQL
and
> PHP. I'm not sure where to begin as far as optimizing my code to reduce
> database access. One thing I did do is I start using mysql_connect
(instead
> of pconnect) for some quick-and-dirty routines to reduce this problem.
While
> it has helped some, it hasn't made the problem go away.
Increase the number of connections. Default is 100. Maximum is dependant
upon your system. Use a my.cnf file to make the change. Read all about it on
the MySQL site, this isn't a PHP issue (other than wisely stopping the use
of pconnect()).
---John Holmes...