vb.org Archive - View Single Post - About 100 DB error messages-too many connections?

MickDoneDee · #5 04-16-2009, 05:08 AM

Quote:

Originally Posted by snakes1100

It means your host has set a limit as to how many times your db user can connect to your db, talk to your host about raising the limit of connections for that user.

If you are on a shared plan like I am and your site is crawled by many bots at the same time this error will be flagged. Since my ISP had already raised the connection limit for my site I had to block the Yahoo! Slurp Spider because there would be as many as 200 visiting my site at the same time. I asked Yahoo to limit the number of crawlers to my site. When they ignored my request I blocked the crawler using .htaccess.

I put this code at the bottom of the .htaccess file:

Code:

 # Deny access to Yahoo! Slurp spider
 RewriteCond %{HTTP_USER_AGENT} Slurp
 RewriteRule .* - [F,L]

Now, I get about 2 Yahoo! Slurp Spiders a day instead of hundreds. I've never received a 'max_user_connections' error since.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01296 seconds Memory Usage 1,764KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code (1)bbcode_quote (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: