I keep getting The mysql error was: Too many connections and it was suggested that maybe it's the site not closing connections. Any ideas ?

Comments

jim0203’s picture

The first thing I would check is the maximum allowed MySQL connections:

http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html

Try increasing this and see if it fixes the problem.

_vid’s picture

This just started happening for me too.
I have a Drupal 6.14 multi-site set up and I'm using multiple databases as well.
My max connections is currently 100.
The wait_timeout is set at the default 28800.

I just checked and I had 60 sleeping connections to my default database.

A lot of other users use this database as well so while we could increase the max connections to 151 (as recommended above) and decrease the wait_timeout. I think it would be a better idea to find out why so many connections are being left to sleep.

For the multiple database connections I use:
db_set_active('Check_Elig');
…some code
db_set_active(‘default');
So I was looking at db_set_active to see if it was creating duplicate connections. It doesn't look like it.

I wonder if it's related to the multi-site set up.

espirates’s picture

I think my max settings is 184, you would think with that many drupal would be ok. A CMS should not be so resource intensive IMHO.