Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
By espirates on
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
The first thing I would check
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.
I'm having the same issue
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.
I think my max settings is
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.