vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Too many connections (https://vborg.vbsupport.ru/showthread.php?t=276301)

pitzerwm 01-11-2012 05:37 AM

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

This is the message:

Quote:

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 01-11-2012 11:57 AM

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 01-11-2012 11:58 AM

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

Disasterpiece 01-11-2012 12:16 PM

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 01-11-2012 05:19 PM

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

Max: I have an ongoing dialog with the host.

Quote:

-- 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 01-11-2012 05:55 PM

Quote:

Originally Posted by pitzerwm (Post 2286611)
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 01-11-2012 06:05 PM

kh99: I checked that and it is at 0

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

Quote:

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

Quote:

Use mysql_connect() instead of mysql_pconnect() unless you have a good reason to do so.
where would I change this?

pitzerwm 01-12-2012 06:13 PM

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 01-12-2012 06:32 PM

Quote:

Originally Posted by pitzerwm (Post 2287004)
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 01-12-2012 06:45 PM

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


All times are GMT. The time now is 09:32 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01056 seconds
  • Memory Usage 1,746KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete