Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-28-2006, 12:03 AM
HostileAdam HostileAdam is offline
 
Join Date: Jul 2005
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default vBulletin using alot of sql usage??

Well my forum all a sudden got really slow, and i contacted my host and they said my site is using alot of sql usage which is causing it to load really slow when you refresh and stuff,, how would i lower the sql usage?
Reply With Quote
  #2  
Old 06-28-2006, 12:22 AM
akanevsky akanevsky is offline
 
Join Date: Apr 2005
Posts: 3,972
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would suggest you change your host because vBulletin's sql is optimized to the max...
Reply With Quote
  #3  
Old 06-28-2006, 12:27 AM
Guest210212002
Guest
 
Posts: n/a
Default

Go here:

http://www.vbulletin.com/forum/forumdisplay.php?f=14

Read the sticky, and let them have a pass at your server settings. There's a good chance you aren't configured for optimal performance.
Reply With Quote
  #4  
Old 06-28-2006, 12:29 AM
Reeve of shinra's Avatar
Reeve of shinra Reeve of shinra is offline
 
Join Date: Oct 2001
Location: NYC
Posts: 1,896
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Are you running any hacks/mods?
How many users are online at any given time?
How large is your database?
Reply With Quote
  #5  
Old 06-28-2006, 01:03 AM
HostileAdam HostileAdam is offline
 
Join Date: Jul 2005
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My SQL is like 60-90 MB, 6900+ members, usually 100 + online, 60+ users 40+ guests but the weird thing is it was normal just last night then all sudden i came on and it was REALLY slow. my sql usage is red and not green. last hack i installed was the warning system but i disabled it.
Reply With Quote
  #6  
Old 06-28-2006, 01:06 AM
Guest210212002
Guest
 
Posts: n/a
Default

Link to your site?
Reply With Quote
  #7  
Old 06-28-2006, 01:09 AM
HostileAdam HostileAdam is offline
 
Join Date: Jul 2005
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well now we are switching servers saturday to a even bigger one so he said it should solve the issue, if it dont then ill reply back with what he says.

could it be the 400 games we added?
Reply With Quote
  #8  
Old 06-28-2006, 03:31 AM
Guest210212002
Guest
 
Posts: n/a
Default

Not really, unless you constantly have 400 people in the arcade.

Again, link your site if you expect actual help here, because honestly we can probably help you, but playing the guessing game as to what it might be isn't really something we should be doing.
Reply With Quote
  #9  
Old 06-30-2006, 05:57 AM
El_Muerte's Avatar
El_Muerte El_Muerte is offline
 
Join Date: Nov 2001
Posts: 237
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

last time I experienced something like that was because the disk where the SQL data was stored was at the end of it's life.
Reply With Quote
  #10  
Old 06-30-2006, 05:09 PM
HostileAdam HostileAdam is offline
 
Join Date: Jul 2005
Posts: 62
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Its fixed now, my host rebooted the server and it fixed the issue
Reply With Quote
Reply


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 01:08 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.15498 seconds
  • Memory Usage 2,231KB
  • 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
  • (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
  • (7)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