Too many connections

[mailtome]

Hi
I am getting the following error
PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections in /usr/share/pear/adodb/drivers/adodb-mysql.inc.php on line 340

Can anyone tell me the possible reasons for this

[stewartship]

whenever you connect to you database make sure at the end of the script / function / run you close the connection. I use OO connections always labelled $DB and then use $DB->close(); to get rid of the connection, it is most probable that you have not closed connections at some point and this has led to the problem.

Hope this helps

[mailtome]

I close the connections when ever I open them. But I think that should not matter because I am using mysql_connect. This is from PHP documentation
Using mysql_close() isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.

[stewartship]

true to say, but it is better to be safe!

the error message seems to be indicating that connections are not being closed..... sorry could not have been of more help

[MarkR]

You're really going to have to analyse the load on your web servers / database servers more. Log in to MySQL as root and use "show processlist" to see all the connections at any given time. Consider increasing the maximum, or reducing your usage of connections.

Try not to open more than one database connection in each PHP script. Don't use persistent connections unless you know that you can handle one connection per Apache thread per persistent connection.

You really need to analyse what's causing these connections to be made.

Remember that in principle each web server thread could use one connection at once for each one you open.

Mark