Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #1  
Old 03-14-2011, 02:09 PM
queengoc queengoc is offline
 
Join Date: Jun 2007
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Server limits

Ever since I've upgraded from 3.8 my server has been exceeding it's limits and the majority of the usage is from my forum. What can I do to lighten the load on my server?

I'm not a technical person at all. Our web server suggested talking to our web designers but they aren't familiar with vbulletin so I thought I would come here first. Any suggestions would be appreciated.

Thanks!
Reply With Quote
  #2  
Old 03-14-2011, 04:51 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Do you have modifications? Try disabling them and see if that makes a difference.
Reply With Quote
  #3  
Old 04-05-2011, 04:52 PM
queengoc queengoc is offline
 
Join Date: Jun 2007
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Lynne, according to my web host the majority of my usage is from the showthread.php. I guess that's normal but the difference between that script and the rest of my forum and website is astronomical. I have no idea where to look or what to do to try and fix the issue.

I disabled most of my mods but none of the ones I'm currently using search related. Here are the mods I currently have in use, I uninstalled everything else:

AddonChat 4.0.1
Disable Member Homepage URLs by BOP5 1.0
Forum Category Icons (Advanced) 1.2.4
Minimum number of posts to post links. 1
Move smilies below textarea 1.4
Separate Sticky and Normal Threads 1.1
SFS Integration 1.0.0
vBH - Add new tabs 1.2
VSa - Advanced Forum Statistics

Any ideas?
Reply With Quote
  #4  
Old 04-05-2011, 05:23 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Any sort of chat or stats mod is going to be server intensive if the users use them.
Reply With Quote
  #5  
Old 04-05-2011, 05:25 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Some of those mods he still has can add lots of extra queries, too. Especially the stats mods.
Reply With Quote
  #6  
Old 04-05-2011, 05:37 PM
queengoc queengoc is offline
 
Join Date: Jun 2007
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you, I will turn off the stats mod and see if that helps. Our chatroom isn't used too often so I'll keep that and see if turning off the stats helped.

Thanks again Lynne and Boofo!
Reply With Quote
  #7  
Old 04-05-2011, 06:56 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just remember to keep the queries down as much as possible, with very many members on at one time. If you have 100 users on at once, and 2 extra queries, that is 200 queries right there. They can add up in a heartbeat.
Reply With Quote
  #8  
Old 04-05-2011, 07:09 PM
queengoc queengoc is offline
 
Join Date: Jun 2007
Posts: 118
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Boofo, how do I keep the queries down? Sorry, I'm a learn as I go person.
Reply With Quote
  #9  
Old 04-05-2011, 07:12 PM
Staxed's Avatar
Staxed Staxed is offline
 
Join Date: Jun 2006
Location: Fayetteville, NC
Posts: 468
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by queengoc View Post
Boofo, how do I keep the queries down? Sorry, I'm a learn as I go person.
You aren't really going to be able to keep the queries down unless you are a coder yourself and can edit mods that use a lot of queries. With each mod you add they may/maynot add queries.
Reply With Quote
  #10  
Old 04-05-2011, 07:15 PM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by queengoc View Post
Boofo, how do I keep the queries down? Sorry, I'm a learn as I go person.
Install this mod and start keeping an eye on your queries.

https://vborg.vbsupport.ru/showthread.php?t=240905
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 07:53 PM.


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.06320 seconds
  • Memory Usage 2,240KB
  • Queries Executed 11 (?)
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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_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