RE: [PHP] Too Many Connections
| From: | Don Read | Date: | Fri, 18 Apr 2003 18:02:22 +0000 |
| Subject: | RE: [PHP] Too Many Connections | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-144423@lists.php.net to get a copy of this message | ||
On 18-Apr-2003 Monty wrote:
> 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.
>
mysql> show variables like '%timeout';
mysql> show variables like 'max_conn%';
increase max_connections
decrease wait_timeout, interactive_timeout.
Regards,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.