vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)
-   -   Server load 996.05?!?! (https://vborg.vbsupport.ru/showthread.php?t=145353)

4x4 Mecca 04-20-2007 03:35 PM
Server load 996.05?!?!
 
1 Attachment(s)
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]
:eek:

Edit, see 2 posts below

nexialys 04-20-2007 03:39 PM
64 queries... what script do you drive over vBulletin ?!... did you try deactivating the plugins ?!

4x4 Mecca 04-20-2007 03:46 PM
1 Attachment(s)
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.

clarkstoncracke 04-20-2007 04:55 PM
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.

4x4 Mecca 04-20-2007 05:23 PM
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?

Reven 04-20-2007 06:05 PM
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.

Ntfu2 04-20-2007 08:21 PM
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 :owell:

4x4 Mecca 04-21-2007 02:20 AM
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)

Lynne 04-21-2007 03:10 AM
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! :D

4x4 Mecca 04-21-2007 03:33 AM
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.

Brandon Sheley 04-21-2007 05:24 AM
Quote:
Originally Posted by 4x4 Mecca (Post 1232422)
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.
is your server load better now ?

cyberphr 04-21-2007 09:31 AM
You're probably being DDoS'd, or something similar. Are you on a shared server?

Incidentally, missing some vBulletin copyright there? :O

UltimateOreo! 04-21-2007 04:47 PM
Yeah, its probably not your board, just the server. That seems WAY too high.

Code Monkey 04-21-2007 05:25 PM
Quote:
Originally Posted by cyberphr (Post 1232513)
You're probably being DDoS'd, or something similar. Are you on a shared server?

Incidentally, missing some vBulletin copyright there? :O
That's not going to increase the queries per page now is it? :rolleyes:

And they may very well have a branding free version.

Quote:
Originally Posted by 4x4 Mecca (Post 1232422)
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.
Remove it then. You should post a warning in the mod thread as well.

Reven 04-21-2007 05:58 PM
Quote:
Originally Posted by 4x4 Mecca (Post 1232399)
Wow, thanks, i found out what it is..
Those were all red?

4x4 Mecca 04-23-2007 05:46 PM
My loads are awesome now. Thanks to some searching on this site about debug mode and tracking down the queries.

Page generated in 0.78488 seconds with 16 queries [Server Loads: 1.14 1.45 : 1.44]

By the way, if I have uncached templates, how do I cache them?

clarkstoncracke 04-24-2007 12:46 AM
Quote:
Originally Posted by 4x4 Mecca (Post 1234165)

By the way, if I have uncached templates, how do I cache them?
Use a template cacher

TheWhite 07-20-2007 03:44 AM
Quote:
Originally Posted by Reven (Post 1232127)
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.
How do you turn on debug mode?

EnIgMa1234 07-20-2007 10:37 AM
You can edit your config.php or search for a mod on here. Its called debug mode

Delphiprogrammi 07-20-2007 02:10 PM
Quote:
Originally Posted by TheWhite (Post 1296242)
How do you turn on debug mode?
PHP Code:
$config['Misc']['debug'] = true; 
add that in /includes/config.php

DO NOT ENABLE DEBUG MODE ON A PUBLIC BOARD ....

Kirk Y 07-21-2007 02:37 AM
Quote:
Originally Posted by 4x4 Mecca (Post 1234165)
By the way, if I have uncached templates, how do I cache them?
Create a new plugin at hook location "cache_templates" with the following contents:
Code:
$globaltemplates = array_merge($globaltemplates, array('template1','template2'));
Of course replace the template1 and template2 with the templates you'd like to cache.


All times are GMT. The time now is 03:28 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01075 seconds
  • Memory Usage 1,764KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)bbcode_php_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (21)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete