Too many connections

[pitzerwm]

Well, CF did not fix the "too many connections" problem.

This is the message:

Database error in vBulletin :

mysql_connect(): Too many connections
/hsphere/local/home/xxxxxxxx/forum.autocareforum.com/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Wednesday, January 11th 2012 @ 01:18:37 AM
Error Date : Wednesday, January 11th 2012 @ 01:18:37 AM
Script : http://forum.autocareforum.com/forumdisplay.php?f=9
Referrer : http://forum.autocareforum.com/
IP Address : 70.27.47.178
Username :
Classname : vB_Database
MySQL Version :

Any other ideas, starts at 10:19 runs until 10:40 +/-

[Max Taxable]

Are you on a shared server? It could be someone else's website that's causing the problem. Have you contacted your host?

it is what the error message says: the database cannot accept more connections, all connection slots are in use otherwise. Several things to check:
-- is your own application OK? Does your application open persistent connections, which aren't closed? Use mysql_connect() instead of mysql_pconnect() unless you have a good reason to do so.
-- have you got more users then ever? I can't see stats when I go to your board. Are you being flooded with bots?
-- can you increase the max_connections system variable, or has it been increased up to its end already (its default value is 100)?
-- Have you looked in the manual for further details:
[dev.mysql.com...]

If it is your own server, then you can look into these things and try to fix and correct.
If you are on shared hosting, you need your host to fix this -- perhaps other shared hosting customers started to eat up more connections than they should ... (common hosting error: too many customers on one box ...) This can be the result of a DDoS attack either on you or a site that is sharing the hosting with you.

Cloud Flare can block the attacks if they are coming to you. First thing I would do (and did) is block China - this is where the Baidu bots come from, you don't need them indexing your site, and their behavior is quite aggressive. They show up with 100s of bots at a time and stay for hours. They totally ignore robots.txt. You can block others too, you should start watching the traffic in online.php for floods. Block bad actors.

Here's what your board looks like at Web Page Test:

http://www.webpagetest.org/result/120111_78_2TNP4/

[Boofo]

Are you with hostgator, by chance? They have the max connections set at 25. Most shared servers have low max connections, IIRC.

[Disasterpiece]

maybe you should think about a protection mechanism like cloudflare. Then you will have better options to block or analyse possible threats.

//e: nvm, didn't see the last pages...

[pitzerwm]

Boofo: No I am with IX, shared server, with 50 connections.

Max: I have an ongoing dialog with the host.

-- is your own application OK? Does your application open persistent connections, which aren't closed? Use mysql_connect() instead of mysql_pconnect() unless you have a good reason to do so.

Where would I change the above? My site is for the car wash industry, at this time a night, I don't have more than 10 people at any time.

I'm not smart enough to understand dev.mySQL. I am with IX, not my own server.

I blocked China, Russia, Ukraine with .htaccess.

It does make sense that since I'm on a shared server, that its someone else. I have nothing happening at anytime. This started a month or so ago.

Thanks again

[kh99]

Originally Posted by pitzerwm

Where would I change the above?

In the file includes/config.php, find $config['MasterServer']['usepconnect'] and make sure it's set to 0.

[pitzerwm]

kh99: I checked that and it is at 0

--------------- Added [DATE]1326350381[/DATE] at [TIME]1326350381[/TIME] ---------------

In the file includes/config.php, find $config['MasterServer']['usepconnect'] and make sure it's set to 0.

This is the way it is.

Use mysql_connect() instead of mysql_pconnect() unless you have a good reason to do so.

where would I change this?

[pitzerwm]

More info:

Looking at "Who is online". I see that some of the "guest" are "viewing archives" with the link.

This is the link on one of them: /archives/index.php/t-4390.html so I tried

http://forum.autocareforum.com/archi...hp/t-4390.html which goes to a place that I've never seen before.

Is there a way to block these? I would think that CF would do this automatically.

[Max Taxable]

Originally Posted by pitzerwm

More info:

Looking at "Who is online". I see that some of the "guest" are "viewing archives" with the link.

This is the link on one of them: /archives/index.php/t-4390.html so I tried

http://forum.autocareforum.com/archi...hp/t-4390.html which goes to a place that I've never seen before.

Is there a way to block these? I would think that CF would do this automatically.

The archive exists for search engine bots to use. It's always been there.

[pitzerwm]

Since I have tried to block all bots with robots.txt and obviously not working, is there another way to block this?