Mysql connection error

[Anon]

Hi,
when i try to connect to the database, it gives the error 'Warning: MySQL Connection Failed: Too many connections in
could not connect'.
I have closed the database connections at the end of the page wherever i have opened the connection.

any solutions?...

Thanks in advance....

ab

[[deleted]]

Increase the max number of connections that your database server can handle.

[sarah]

How many times do you open a database connection? You should only have to open a connection once, run all of your scripts, and close it.

Are you connecting to the database in include files?

[lawnmowerman]

Also, if you're using mysql_pconnect(), each web server child process will leave a connection open to the MySQL server until that child dies.

Try using mysql_connect() instead.

-Rich

[[deleted]]

That only helps for low-traffic sites.
Using/not using pconnect doesn't increase or decrease the max number of connections used, it just uses the same number of connections for a longer period of time, thus you are more likely to notice that you are running low on connections.

[lawnmowerman]

This is correct. This will not fix your issue on a high traffic site.

If Apache has, say, a maximum of 50 children and MySQL permits, say, a maximu of 25 connections, then only 1/2 of the children will be able to have a connection to the database.

On a low traffic site, though, as soon as the connection is closed, another Apache child process can make a connection, making it much more likely that a connection will be successful. I've had quite a lot of luck using this method on low to medium traffic sites.

On a high traffic site, it is likely that most of the Apache child processes will be attempting to connect or are already connected at any given time. This is when you should definitely increase the max connections for MySQL.

-Rich