vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   vbMicroStats: page load time, queries, GZIP and PHP version (https://vborg.vbsupport.ru/showthread.php?t=35811)

eva2000 03-10-2002 09:38 PM

Quote:

Originally posted by Jawelin
:( Well. I used the replacement var - finally - but still have negative values:

0.24685 seconds (-98.10% PHP v4.1.2 - 198.10% MySQL) with 34 queries.

What could be the misconfiguration problems Nakkid referred to ?
Thanks

i get negative values when the time for the queries is lower than the average probably because i have php accelerator installed and some php sided queries are sped up by the accelerator ?

reloading the page goes back to normal

i.e.

forumhome page

Page generated in 0.0316610 seconds (-1,271.66% PHP - 1,371.66% MySQL) with 29 queries.

and

Page generated in 0.3843770 seconds (-12.94% PHP - 112.94% MySQL) with 29 queries.

and

Page generated in 0.2906680 seconds (-49.57% PHP - 149.57% MySQL) with 29 queries.

normally it's around

Page generated in 0.5901080 seconds (22.84% PHP - 77.16% MySQL) with 29 queries.

if i use index.php?explain=1

i get

Page generated in -0.361466 seconds with 29 queries,
spending 0.43714368343353 doing MySQL queries and -0.79860968343353 doing PHP things.

TECK 03-10-2002 10:13 PM

Quote:

Originally posted by dyt4
GZIP is in use on my forum but it's always marked disabled ?
look what it shows on your page. GZIP disabled. understand that this is the dooutput() function that it look in headers for the variables, not on the server.

TECK 03-10-2002 10:17 PM

Quote:

Originally posted by eva2000
i get negative values when the time for the queries is lower than the average probably because i have php accelerator installed and some php sided queries are sped up by the accelerator?
it might be the cause... i wonder if zend can play a role on this. but me and firefly have both zend enabled on server. we both tested the script. firefly went over and gave the ok in every little bit of code. he even bothered to see a dev and make sure is ok all. we both never got negative values.

i wish i could expplain why sometimes the time goes negative. firefly have 1.3 installed. and the PHP and MySQL % is generated in db_mysql.php

lowlight 03-10-2002 10:20 PM

Quote:

Originally posted by nakkid
GZIP library compression will be enabled only in pages where GZIP is in use. ;)
the hack is looking in the header, to see id GZIP os enabled, and dont forget that those stats are generated individually for each page.

Okay so how do we make it look in the proper place? GZIP should be in use on every PHP page, shouldn't it?

lowlight 03-10-2002 10:21 PM

Quote:

Originally posted by nakkid
DEBUG mode can be turned on or off by your host.

also in the install file, you have all the variables listed there.

regards,
nakkid.

I guess I worded my question wrong :)

I'd like to know if it SHOULD be turned off... If that would increase server performance... If so, I'll go do it right away :D

TECK 03-10-2002 10:25 PM

ok. let's try this piece of code:
PHP Code:

  if (strstr($HTTP_GET_VARS['HTTP_ACCEPT_ENCODING'], 'gzip')) {
    
$gziptext='enabled';
  } else {
    
$gziptext='disabled';
  } 

let me know if it still shows disabled.

TECK 03-10-2002 10:27 PM

DEBUG mode is selected as default by PHP 4.0.5 and higher.

TECK 03-10-2002 10:52 PM

george, this is what i get on your board:
[high]Page generated in 0.4542080 seconds (93.83% PHP - 6.17% MySQL) with 17 queries.[/high]

i reload it 10times and i never got a negative value.
i'm beginning to believe is the browser's fault.. and i'm not even neo.. hehe

eva2000 03-10-2002 11:07 PM

Quote:

Originally posted by nakkid
george, this is what i get on your board:
[high]Page generated in 0.4542080 seconds (93.83% PHP - 6.17% MySQL) with 17 queries.[/high]

i reload it 10times and i never got a negative value.
i'm beginning to believe is the browser's fault.. and i'm not even neo.. hehe

strange if i log out and do explain first time i got 0.11 for 17 queries but reloading i get 15 queries

Page generated in 0.092332 seconds with 15 queries,
spending 0.029972076416016 doing MySQL queries and 0.062359923583984 doing PHP things.

this is the query that got time reduced the most on subsequent reloads

PHP Code:

QuerySELECT template,title
                          FROM template
                          WHERE 
(title IN ('forumhome_birthdaybit','error_nopermission','forumhome_pmloggedin','forumhome_welcometext','forumhome_logoutcode','forumhome_newposts','forumhome_todayposts','forumhome_logincode','forumhome_loggedinuser','forumhome_loggedinusers','forumhome_lastpostby','forumhome_moderator','forumhome_forumbit_level1_nopost','forumhome_forumbit_level1_post','forumhome_forumbit_level2_nopost','forumhome_forumbit_level2_post','forumhome','forumhome_unregmessage','timezonelist','timezone_city','timezone_city_col','gobutton','timezone','username_loggedout','username_loggedin','phpinclude','headinclude','header','footer','forumjumpbit','forumjump','nav_linkoff','nav_linkon','navbar','nav_joiner','pagenav','pagenav_curpage','pagenav_firstlink','pagenav_lastlink','pagenav_nextlink','pagenav_pagelink','pagenav_prevlink')
                            AND (
templatesetid=-OR templatesetid='10'))
                          OR (
title 'maxloggedin')
                          OR (
title 'birthdays')
                          
ORDER BY templatesetid
Time before
0.012995958328247
Time after
:  0.027544975280762 


TECK 03-10-2002 11:08 PM

Upgrade to Version 1.4 (from 1.3)

in functions.php and function dooutput(), find:
PHP Code:

global $pagestarttime,$query_count,$showqueries,$querytime,$DB_site,$microstats

replace it with:
PHP Code:

global $pagestarttime,$query_count,$showqueries,$querytime,$DB_site,$microstats,$HTTP_ACCEPT_ENCODING

still in dooutput(), find:
PHP Code:

if (strstr($HTTP_SERVER_VARS["HTTP_ACCEPT_ENCODING"], "gzip")) { 

replace it with:
PHP Code:

if (strpos(" ".$HTTP_ACCEPT_ENCODING,"gzip")) { 

now it will look to see if the GZIP is enabled everywhere.. :D


All times are GMT. The time now is 04:56 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.01738 seconds
  • Memory Usage 1,767KB
  • 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
  • (6)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete