Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > General Hosting/Server Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Server load 996.05?!?! Details »»
Server load 996.05?!?!
Version: , by 4x4 Mecca 4x4 Mecca is offline
Developer Last Online: Jun 2013 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 04-20-2007 Last Update: Never Installs: 0
 
No support by the author.

I've been having trouble with the server I'm on lately, and today it peaked! Check out the attached image.
Quote:
Page generated in 5.42644 seconds with 64 queries [Server Loads: 81.18 107.66 : 84.98]


Edit, see 2 posts below

Download Now

File Type: (21.4 KB, 133 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 04-20-2007, 03:39 PM
nexialys
Guest
 
Posts: n/a
Default

64 queries... what script do you drive over vBulletin ?!... did you try deactivating the plugins ?!
Reply With Quote
  #3  
Old 04-20-2007, 03:46 PM
4x4 Mecca 4x4 Mecca is offline
 
Join Date: Feb 2007
Posts: 396
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

OK, it's gotten worse! lol, I had no idea numbers could do this.
I wanted to wait to deactivate until they put me on a faster server. They have varified major problems with my server, so I'd like to get a better idea of where my site speed is at then.
Attached Files
File Type: (21.4 KB, 124 views)
Reply With Quote
  #4  
Old 04-20-2007, 04:55 PM
clarkstoncracke clarkstoncracke is offline
 
Join Date: Feb 2007
Posts: 54
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

64 QUERIES?

holy cowzers.

I have over 20 plugins and hacks, and I have 12 per page.

You need to find out what the heck is going on there.

Is this on a shared server? If so, you better watch out, they may disable your account.
Reply With Quote
  #5  
Old 04-20-2007, 05:23 PM
4x4 Mecca 4x4 Mecca is offline
 
Join Date: Feb 2007
Posts: 396
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ok, if i view my plug ins, is each check box a query of some sort depending on which page i'm viewing on my site?
Reply With Quote
  #6  
Old 04-20-2007, 06:05 PM
Reven Reven is offline
 
Join Date: Aug 2005
Location: UK
Posts: 113
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No, each box is a bit of code which is executed at various strategic locations. These may or may not have queries. The only way to effectively reduce your query count is to disable mods, unless you know how to program PHP, in which case you could look into making these mods more efficient.

The best thing to do is to turn on debug mode with your forums closed then browse your various pages, looking for any red entries in the box at the bottom of the page (the one which appears when you turn on debug mode). These red entries are unnecessary queries, which can be fixed.
Reply With Quote
  #7  
Old 04-20-2007, 08:21 PM
Ntfu2 Ntfu2 is offline
 
Join Date: Feb 2006
Posts: 1,247
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If your on shared hosting there isn't much you can do other then try figuring out why you have so many queries.

Even having that many quereys your server load shouldn't hit that well:
Reply With Quote
  #8  
Old 04-21-2007, 02:20 AM
4x4 Mecca 4x4 Mecca is offline
 
Join Date: Feb 2007
Posts: 396
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Wow, thanks, i found out what it is..
Quote:
Template Usage
Display_Readers (1)
SHOWTHREAD (1)
arcade_award_bit (12)
bbcode_quote (1)
dfh_announcement (1)
editor_clientscript (1)
editor_jsoptions_font (1)
editor_jsoptions_size (1)
editor_smilie (20)
editor_smiliebox (1)
editor_smiliebox_row (2)
footer (1)
forumdisplay_loggedinuser (1)
forumjump (1)
forumrules (1)
gobutton (1)
header (1)
header_advertisement (1)
headinclude (1)
mysmilies_imagebit (70)
navbar (1)
navbar_link (5)
newpost_disablesmiliesoption (1)
option (189)
post_thanks_box (5)
post_thanks_button (5)
postbit_ip (5)
postbit_legacy (5)
postbit_onlinestatus (5)
postbit_reputation (17)
postbit_wrapper (5)
showthread_quickreply (1)
smilies_quickreply (1)
spacer_close (1)
spacer_open (1)
threadadmin_imod_menu_post (1)
welcome_headers (1)
Reply With Quote
  #9  
Old 04-21-2007, 03:10 AM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Here I freaked out when we accidentally installed the wrong version of eaccelerator and we got server loads of over 100. I'd have a full head of gray hair by the time it got up to 900!
Reply With Quote
  #10  
Old 04-21-2007, 03:33 AM
4x4 Mecca 4x4 Mecca is offline
 
Join Date: Feb 2007
Posts: 396
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I found out what was using 50 querys!!!!!!!!!! The mod "Self Censor Plus" version 1.0 which allows people to filter out their own swear words.
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 11:17 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.04655 seconds
  • Memory Usage 2,313KB
  • Queries Executed 24 (?)
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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (2)postbit_attachment
  • (9)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_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete