Go Back   vb.org Archive > Community Discussions > Forum and Server Management
  #1  
Old 10-09-2008, 05:26 PM
pr0k pr0k is offline
 
Join Date: May 2008
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Any way to throttle vbulletin back from max_connections?

I run a tiny board, maybe 10-15 users at a time, peak. I keep hitting the host-set 150 max_connections limit. I don't think I should be hitting it, but I don't know what's causing it. Whenever I run SHOW PROCESSES all I see is the board itself.

Is it possible to somehow throttle vbulletin back so it doesn't hit that limit until I can get moved to a new host?

Thanks!
Reply With Quote
  #2  
Old 10-09-2008, 07:16 PM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you shouldn't be hitting 150 max connections with 10-15 users online. Do you have persitant DB connections disabled in config.php and how many guests are viewing the frums at the same time.
Reply With Quote
  #3  
Old 10-10-2008, 08:04 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Could this be caused by SE spiders?
Reply With Quote
  #4  
Old 10-10-2008, 12:40 PM
pr0k pr0k is offline
 
Join Date: May 2008
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Persistent connections are disabled (I think that is the default.)

I only see 3-4 guests at a time, including spiders.
Reply With Quote
  #5  
Old 10-10-2008, 03:19 PM
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Location: Indianapolis
Posts: 2,451
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

What about modifications installed, do you have a lot?

Even then with lets say a generous 30 people online at any one time, your connections should be 30 and thats only if all 30 refreshed the page at the same time.

There has to be something else causing the load, are you using the same database username/password for other MySQL driven applications or is vBulletin the only thing you are running on your hosting account.
Reply With Quote
  #6  
Old 10-10-2008, 04:02 PM
pr0k pr0k is offline
 
Join Date: May 2008
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Vbulletin is the only thing using that database. My backup script is run manually.

Plugins/products:

Title Version Description Controls

Display Unread Posts and Reputation Comments
3.7.006

Display the number of posts you have marked as unread and the number of new (unread) reputation comments.

Member Profile Reputation Display
3.7.002
Display a members reputation comments in their profile.

Members who are using Flashchat
3.7.002

Display members who are currently chatting in Flashchat.

passiveVid
1.1.2
Automaticlly turns video links like youtube, myspace videos, google vidoes into the video players.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:14 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.10641 seconds
  • Memory Usage 2,198KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete