vb.org Archive - Is my server load too high?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Community Lounge (https://vborg.vbsupport.ru/forumdisplay.php?f=13)

- - Is my server load too high? (https://vborg.vbsupport.ru/showthread.php?t=64750)

EvilLS1

05-05-2004 12:48 AM

Is my server load too high?

1 Attachment(s)

:speechless: :eek: :D

Zachery

05-05-2004 12:49 AM

Quote:

Originally Posted by EvilLS1

:speechless: :eek: :D

Just a tad ^^

Brad	05-05-2004 01:11 AM

Ouch

Tony G

05-05-2004 05:46 AM

O_O

All I can say.. :p

Boofo

05-05-2004 07:33 AM

Not at all. Looks just about right for your site. I've seen it. I know. ;)

Maybe if you change it from MPH, it might help. Your site isn't that fast anyway. ;)

joeychgo

05-05-2004 02:00 PM

Ive seen this referred on occasion. What are queries, what do they do, and how do I find out how many I have.

EvilLS1

05-05-2004 10:04 PM

Quote:

Originally Posted by joeychgo

Ive seen this referred on occasion. What are queries, what do they do, and how do I find out how many I have.

Queries are calls to the database for information. Check out TECH or Erwin's microstats hack for an easy way to see your # of queries per page.

Xenon

05-06-2004 12:07 PM

hmm, i think it should be over 500, so nope, its a good value :p

joeychgo

05-07-2004 09:52 AM

ok on my VBadv page mine says:

Page generated in 0.23882 seconds with 19 queries (2 queries for uncached templates) [Server Loads: 0.82 0.92 : 1.23]

and on my forum home I get:

Page generated in 0.27978 seconds with 15 queries (2 queries for uncached templates) [Server Loads: 2.87 1.33 : 1.36]

Is this good or bad??? If bad - how do I fix it??

EvilLS1

05-07-2004 04:44 PM

Thats not too bad, but you have a couple of unnecessary queries due to uncached templates. What hacks or addons have you done that effect vbAdvanced Homepage and your forum's index.php?

joeychgo

05-07-2004 09:24 PM

I have these hacks
Ad Columns

Who was online today

Arrange Sub-Forums in columns

Dynamic Announcements

Those are the ones that affect my forum home:
(Page generated in 0.15843 seconds with 15 queries (2 queries for uncached templates) [Server Loads: 0.55 0.94 : 1.10])

On my VBA page I have

Weather Block

Dynamic Announcements

Page generated in 0.18439 seconds with 19 queries (2 queries for uncached templates) [Server Loads: 0.93 0.96 : 1.09]

My vb garage has Ad Columns
Page generated in 0.11596 seconds with 36 queries (3 queries for uncached templates) [Server Loads: 1.04 1.10 : 1.12]

My Timeslips page has Ad Columns
Page generated in 0.08468 seconds with 10 queries (2 queries for uncached templates) [Server Loads: 1.09 1.10 : 1.12]

My Links and Files database has Ad Columns
Page generated in 0.19688 seconds with 14 queries (2 queries for uncached templates) [Server Loads: 0.90 1.07 : 1.11]

Thats all of it

EvilLS1

05-07-2004 10:23 PM

I see a couple in the vbgarage hack.

In vbgarage.php find:

Code:

        'vbgarage_popup',

        'vbgarage_viewgarage'

Replace it with:

Code:

        'vbgarage_popup',

        'vbgarage_commentbits',

        'vbgarage_latestbits',

        'vbgarage_viewgarage'

Looks like Ad Columns is shown on most of your other pages so its probably causing the others.

In global.php find:

Code:

        // misc useful

        'spacer_open',

Replace it with:

Code:

        // misc useful

        'spacer_open',

        'adcolumn_left',

        'adcolumn_right',

See if that takes care of the uncached templates.

joeychgo

05-07-2004 11:09 PM

VBA

Before Changes: Page generated in 0.26726 seconds with 19 queries (2 queries for uncached templates) [Server Loads: 0.44 0.84 : 1.09]

After Changes: Page generated in 0.27118 seconds with 17 queries [Server Loads: 0.76 0.90 : 1.08]

Forum Home

Before Changes: Page generated in 0.27529 seconds with 15 queries (2 queries for uncached templates) [Server Loads: 1.52 1.06 : 1.15]

After changes: Page generated in 0.16029 seconds with 13 queries [Server Loads: 0.69 0.91 : 1.09]

VbGarage

Before changes: Page generated in 0.15391 seconds with 34 queries (1 queries for uncached templates) [Server Loads: 1.43 1.03 : 1.10]

After Changes: Page generated in 0.11484 seconds with 33 queries [Server Loads: 0.83 0.94 : 1.06]

Yes, it took care of the uncashed templates, thanks --- my queries still look high to me??? How do I fix that?

EvilLS1

05-07-2004 11:32 PM

Your vbGarage page has alot of queries. The others are fine. Have you added anything to the vbgarage hack? I have it installed on my test forum and for me it shows less than 12 queries.

joeychgo

05-08-2004 12:43 AM

Nope - the VbGarage is self contained - only has the adcolumns hack.......

Could it be something about how many garages I have stored there? My timeslips (which also only has the adcolumns hack) has 8 queries --- my vbgarage has 33 with 25 garages per page -- 25+8=33

its probably not that simple -- but its a thought?

EvilLS1

05-08-2004 12:59 AM

Your Timeslip Database page has no effect on the # of queries in your vbgarage. Its a separate script. Maybe the vbgarage adds a query per every user shown on the main list. I haven't really looked at it yet.

joeychgo

05-08-2004 01:08 AM

thats kind of what I was thinking, cause the timeslip and vb garage have the same hacks so I was comparing one to the other -- and the numbers add up........

lifesourcerec

05-09-2004 10:02 AM

that fixed my uncached probably also but server load a little high:

Page generated in 0.36117 seconds with 14 queries [Server Loads: 6.76 5.54 : 5.80]

And this is with only me on it. Server name hasn't switched over yet.

All times are GMT. The time now is 10:21 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02572 seconds Memory Usage 1,753KB 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 (4)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (18)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
Messages: