By apersaud on

Our site is down due to a MySQL database connection error that says we have too many connections.

We've read the forums and we've tried a few possible unsuccessful suggestions, such as increasing the number of available connections,disabling persistent connections through our php.ini file, and drupal caching (which was on). Nothing is working.

Our environment specs are as follows:
Apache 2.x
MySQL 5.x
PHP 5.x
Drupal 5.1

Does anyone have any helpful information or a possible solution?

Thank You.

⋅ Categories: Drupal 5.x

Comments

VM’s picture

VM commented

Not that it is the cause of the problem but why still using Drupal 5.1 ? you are 4 security releases behind and leaving your site open to known security holes.

That aside, specific versioning information would be helpful. the .x doesn't tell anyone much with regards to helping research for you.
_____________________________________________________________________
My posts & comments are usually dripping with sarcasm.
If you ask nicely I'll give you a towel : )

apersaud’s picture

apersaud commented

Thank you everyone for your suggestions. We discovered that although we had increased the number of allowed mysql database connections, it was still being bottlenecked by the allowed server connections (which was only set at the default of 100!). So, once we also increased that number, everything was ok.

markus_petrux’s picture

markus_petrux commented

There's no recipe for performance problems. First thing is try to identify which is the reason(s) the number of MySQL connections reaches the limit. There might be a lot of causes. How many time a connections takes to finish? Slow queries? Using MyISAM or InnoDB? How about CPU usage, RAM, pagination?

Doubt is the beginning, not the end of wisdom.

nemrod’s picture

nemrod commented

mysql show the same message when the hd is full, but you need upgrade your drupal version

nadeemagaskar’s picture

nadeemagaskar commented

This is seems to be a bug.. there might be some connection problem with mysql and the way drupal handle it.One solution is too increase the connection from 100(default) to 250 in mysql or try this http://drupal.org/node/51263#comment-180220.

SocialNicheGuru’s picture

SocialNicheGuru commented

I am having a numfiles or othersockbuf is too high.

I am not sure what in my install is causing it.

C

http://SocialNicheGuru.com
Delivering inSITE(TM), we empower you to deliver the right product and the right message to the right NICHE at the right time across all product, marketing, and sales channels.

kilemol’s picture

kilemol commented

Drupal execute 1000+ queries for some pages. Count of it's You can decrease more than 10 times. Try to analyse why page is slow.
maybe it's useful: http://drupal.org/node/342020