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 ?
The first thing I would check is the maximum allowed MySQL connections:
Try increasing this and see if it fixes the problem.
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:
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 184, you would think with that many drupal would be ok. A CMS should not be so resource intensive IMHO.
Drupal is a registered trademark of Dries Buytaert.