Server load 996.05?!?!

[4x4 Mecca]

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

Edit, see 2 posts below

[nexialys]

64 queries... what script do you drive over vBulletin ?!... did you try deactivating the plugins ?!

[4x4 Mecca]

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]

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]

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]

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]

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]

Wow, thanks, i found out what it is..

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]

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]

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]

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]

You're probably being DDoS'd, or something similar. Are you on a shared server?

Incidentally, missing some vBulletin copyright there? :O

[UltimateOreo!]

Yeah, its probably not your board, just the server. That seems WAY too high.

[Code Monkey]

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.

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]

Wow, thanks, i found out what it is..
Those were all red?

[4x4 Mecca]

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]

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

Use a template cacher

[TheWhite]

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]

You can edit your config.php or search for a mod on here. Its called debug mode

[Delphiprogrammi]

How do you turn on debug mode?


$config['Misc']['debug'] = true;


add that in /includes/config.php

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

[Kirk Y]

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:
$globaltemplates = array_merge($globaltemplates, array('template1','template2'));Of course replace the template1 and template2 with the templates you'd like to cache.