PDA

View Full Version : URGENT: Too many connections?

X-Fan
11-25-2002, 09:49 PM
G'day all,

I'm hoping someone can help me with this, as it's been a recurring problem recently that's been causing my site to become *very* unstable.

Basically, its this error:

Warning: Too many connections in /home/virtual/site1/fst/var/www/html/xfan/forums/admin/db_mysql.php on line 40

Warning: MySQL Connection Failed: Too many connections in /home/virtual/site1/fst/var/www/html/xfan/forums/admin/db_mysql.php on line 40

And I'm wondering what it is that causes that, and what measures can be taken to prevent it happening?

Thanks in advance!
X-Fan
11-25-2002, 09:51 PM
Just as an addendum, today I discovered a process that had been running for 55 minutes that was chewing up over 90% of my server's CPU! That's what was causing the "too many connections" error, but what process would chew up over 90% of the CPU state?!
Erwin
11-25-2002, 10:38 PM
Too many connections in /home/virtual/site1/fst/var/www/html/xfan/forums/admin/db_mysql.php on line 40


If you're on a shared server, try turning persistent connections to OFF in your admin/config.php

If it's a dedicated server, just increase your maximum db connections in php.ini to 100 or more.

Looks like your site is becoming busier. :)

As for the process, could be anything. Make sure you're not being hacked. Check your hacks - do you have anything that may form a query loop?
X-Fan
11-25-2002, 10:48 PM
Originally posted by Erwin
If you're on a shared server, try turning persistent connections to OFF in your admin/config.php

Already did that weeks ago.

Looks like your site is becoming busier. :)

Yeah, but it'll soon die off if I can't resolve the problem, because people are getting fed up with the site crashing all the time (as am I!).

As for the process, could be anything. Make sure you're not being hacked. Check your hacks - do you have anything that may form a query loop?

I wouldn't have a clue what to look for, Erwin. I've attached a list of the hacks that I've installed - could you take a look and see if anything stands out as a potential problem? I'm looking to upgrade to 2.2.9 this week, and would appreciate knowing if there are any hacks I shouldn't be using because they're too resource hungry!

Thanks mate,
Erwin
11-26-2002, 01:18 AM
!!! You have LOTS of hacks in that list!!! Some of them I am not familiar with. When I have time I will look at them. :) What server are you on? Shared or dedicated? If it's shared, it's time to go dedicated.
X-Fan
11-26-2002, 01:26 AM
Most of them are very small hacks which makes the list seem long :)

As for what server my site is on, it's a dedicated RackShack server.
Erwin
11-26-2002, 01:37 AM
Mmm... that's weird. I suggest you post in the "Server Config" forum in vB.com and ask eva2000 to optimize the server for you. :)
X-Fan
11-26-2002, 02:49 AM
Well on further investigation it looks like that the process problem I mentioned above is related to the httpdmon bug that affects ensim's WEBppliance.

http://forum.rackshack.net/showthread.php?s=&threadid=13753

I'll get the fix for that installed and see if that resolves it.