vb.org Archive
Page 3 of 24 12 3 4513 Last »
Show 40 post(s) from this thread on one page

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)

dyt4 03-10-2002 04:45 PM
same thing for me as you can see here :

for gzip : http://dyt4concept.com/temp/gzip.php here gzip is enabled and here : http://forum.dyt4concept.com/ gzip is disabled ???? It's the same server...

freakyshiat 03-10-2002 05:29 PM
Quote:
Originally posted by dyt4
same thing for me as you can see here :

for gzip : http://dyt4concept.com/temp/gzip.php here gzip is enabled and here : http://forum.dyt4concept.com/ gzip is disabled ???? It's the same server...
yes your forum is gzipped ; I installed this hack too and it says gzip is disabled on my site when I know it's enabled.

go here to test see if gzip is enabled for your site:
http://leknor.com/code/gziped.php

dyt4 03-10-2002 07:32 PM
thx the results :

http://forum.dyt4concept.com is gziped.

and

http://dyt4concept.com is gziped.

I really don't understand, maybe a bug in the hack ? I don't know

Please help

thx

lowlight 03-10-2002 08:17 PM
Quote:
Originally posted by nakkid
use the $gziptext variable. i just released ver 1.2
it's self explanatory.
Not exactly self explanitory for people who don't know anything about code, but I figured it out :)

Now I have an issue... It tells me that GZIP is disabled, however using this test it seems to be enabled...

Odd

lowlight 03-10-2002 08:32 PM
Also, it tells me that debug is on.... Should this be on? How do I turn it off?

Jawelin 03-10-2002 08:52 PM
:( 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

TECK 03-10-2002 09:19 PM
did you modified properly db_mysql.php? the PHP percent is pulled from there.

TECK 03-10-2002 09:21 PM
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.

TECK 03-10-2002 09:22 PM
Quote:
Originally posted by lowlight
Also, it tells me that debug is on.... Should this be on? How do I turn it off?
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.

dyt4 03-10-2002 09:27 PM
Quote:
GZIP library compression will be enabled only in pages where GZIP is in use
GZIP is in use on my forum but it's always marked disabled ?

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:
Query: SELECT 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=-1 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

TECK 03-10-2002 11:14 PM
george, here it is:

Code:
1. Page generated in 0.7345470 seconds (96.28% PHP - 3.72% MySQL) with 15 queries.
2. Page generated in 0.8443970 seconds (96.82% PHP - 3.18% MySQL) with 15 queries.
3. Page generated in 0.6960710 seconds (71.68% PHP - 28.32% MySQL) with 15 queries.
4. Page generated in 0.9797110 seconds (66.31% PHP - 33.69% MySQL) with 15 queries.
5. Page generated in 0.6964480 seconds (96.46% PHP - 3.54% MySQL) with 15 queries.
i just refreshed 5 times and posted the results.

about your time:
Code:
Time before: 0.012995958328247
Time after:  0.027544975280762
this is extremly small, so that means you do not call it before and after the headers. that explains the negative values in PHP and MySQL.

FWC 03-11-2002 03:28 AM
Quote:
Originally posted by nakkid
[high]IF YOU DOWNLOADED A PREVIOUS VERSION,
MAKE SURE YOU CLEAR YOUR TEMP FILES, CACHE AND HISTORY,
BEFORE YOU REDOWNLOAD THE UPDATED FILE![/high]
I noticed that, when you download again an attachment, it will store it as the old install. The easiest way to see if you have the right version, is to look at the top of the file, it will say there Version 1.4.
Why don't you just change the name of the file with each upgrade? It would be easier for everybody. :classic:

TECK 03-11-2002 03:56 AM
i tried. it will do the same, if i delete the attachment and upload a new one called vbmicrostats2.txt, if i click on the download link, it will save it as vbmicrostats.txt to my pc.. wierd huh? and btw, this was the solution firefly gave me. ;)

regards,
nakkid.

FWC 03-11-2002 04:17 AM
Quote:
Originally posted by nakkid
i tried. it will do the same, if i delete the attachment and upload a new one called vbmicrostats2.txt, if i click on the download link, it will save it as vbmicrostats.txt to my pc.. wierd huh? and btw, this was the solution firefly gave me. ;)

regards,
nakkid.
Bummer. :ponder:

dyt4 03-11-2002 05:29 AM
works great thanks again ;)

Jawelin 03-11-2002 08:25 AM
Quote:
Originally posted by nakkid
did you modified properly db_mysql.php? the PHP percent is pulled from there.
Yes. I did from the 1.1 ver and always checked wasn't changed in any new release of your hack.

P.S.: just a question about GZIP. My server supports it (as written in phpinfo and $HTTP_ACCEPT_ENCODING...), but in my VB options I disabled it to decrease server CPU load.

1) Do you think it should displayed 'enabled' or 'disabled' in your hack ? Standing on the bare code, I guess only the server var status is checked, not the vb one too...

2) Do you think I should enable it to increase performances ? How the cpu load should be acceptably higher ?

Thanks a lot.

Jawelin 03-11-2002 11:53 AM
Just as an addendum to point 1 just above, I used this small customization about gzip:
Code:
within: function dooutput($vartext,$sendheader=1) {

add

      $gzipoutput,$gziplevel
at the end of
      global .... row.

then add

      if ($gzipoutput and $gziplevel)
          $gziptext.=" and active (level $gziplevel)";
right after
      $gziptext="enabled";
:cross-eyed:

Btw, my questions above about negative value (as eva said, mostly on the main page somethimes...) and the cpu overloading with gzip, REMAIN .... :)
Thanks a lot
Bye

nuno 03-11-2002 05:05 PM
very nice hack nakkid
working gr8 :)
thx

TECK 03-11-2002 06:33 PM
Upgrade your vbMicroStats to Version 1.5:

forum/admin/functions.php
1. in [high]function dooutput()[/high], find the code:
PHP Code:
global $pagestarttime,$query_count,$showqueries,$querytime,$DB_site,$microstats,$HTTP_ACCEPT_ENCODING; 
replace it with:
PHP Code:
global $pagestarttime,$query_count,$showqueries,$querytime,$DB_site,$gzipoutput,$gziplevel,$microstats; 
2. find the code:
PHP Code:
  if (strpos(" ".$HTTP_ACCEPT_ENCODING,"gzip")) {
    $gziptext="enabled";
  } else {
    $gziptext="disabled";
  } 
replace it with:
PHP Code:
  if ($gzipoutput==1) {
    $gziptext="enabled (level $gziplevel)";
  } else {
    $gziptext="disabled";
  } 
[high]NOTE:[/high] The GZIP compression will show as enabled only if you enabled your board to use GZIP compression.
To do this, do yo your [high]VBulletin Options > HTTP Headers and output > GZIP Output[/high] and select Yes.
Otherwise, it will show as disabled.

okrogius 03-11-2002 10:35 PM
Quote:
Originally posted by nakkid
Upgrade your vbMicroStats to Version 1.5:

forum/admin/functions.php
1. in [high]function dooutput()[/high], find the code:
PHP Code:
global $pagestarttime,$query_count,$showqueries,$querytime,$DB_site,$microstats,$HTTP_ACCEPT_ENCODING; 
replace it with:
PHP Code:
global $pagestarttime,$query_count,$showqueries,$querytime,$DB_site,$gzipoutput,$gziplevel,$microstats; 
2. find the code:
PHP Code:
  if (strpos(" ".$HTTP_ACCEPT_ENCODING,"gzip")) {
    $gziptext="enabled";
  } else {
    $gziptext="disabled";
  } 
replace it with:
PHP Code:
  if ($gzipoutput==1) {
    $gziptext="enabled (level $gziplevel)";
  } else {
    $gziptext="disabled";
  } 
[high]NOTE:[/high] The GZIP compression will show as enabled only if you enabled your board to use GZIP compression.
To do this, do yo your [high]VBulletin Options > HTTP Headers and output > GZIP Output[/high] and select Yes.
Otherwise, it will show as disabled.
Is there a clean install txt directions file telling how to isntall 1.5? If you can email it to me that would be great. oleg@gaminguru.com

TECK 03-11-2002 10:39 PM
just download the [high]vbmicrostats.txt[/high] attachment. make sure you clear your history and cookies if you cannot download the latest version. i put it [high]FREAKY YELLOW[/high] what you have to do in order to get the latest file, so you cannot miss it. ;)

also, please do not quote full code, it make your post almost unreadable.

regards,
nakkid.

Jadelit 03-11-2002 11:51 PM
woot woot.. hehe

Page generated in 0.6007300 seconds (90.65% PHP - 9.35% MySQL) with 93 queries.
PHP version 4.1.2 (Debug mode) with GZIP library compression disabled.

TECK 03-12-2002 12:28 AM
Quote:
Originally posted by Jadelit
woot woot.. hehe
your forums look great. congrats. however, there is only one thing:
YOU REMOVED THE Jelsoft COPYRIGHT NOTICE.
please re-add it asap, as you infringe vBulletin's copyright and proper usage.

i forgot one detail (thanks Recon_Boy): 93 queries?
this is extremly high, you could crash your host's server if you have over 100 users simultaneously on your board.
check your code hacks. you have a bug there. vB.org who is loaded up to the sky with hacks, have 33 queries max.

regards,
nakkid.

Recon_Boy 03-12-2002 12:33 AM
Quote:
Originally posted by Jadelit
woot woot.. hehe

Page generated in 0.6007300 seconds (90.65% PHP - 9.35% MySQL) with 93 queries.
PHP version 4.1.2 (Debug mode) with GZIP library compression disabled.
93 queries is awful high...lol...

yeah, do what Nakkid says.

TECK 03-12-2002 06:50 AM
Well I realised that many of us don't want to let users see to many technical details. So in v1.6, the PHP version, Debug mode and GZIP compresion status will be visible only to admins.
A neat feature that i added was the Detailed View. Basically, it's a link that will output in details, what is happening on that page, related to PHP and MySQL. I will post a screenshoot below, so you can understand better.

1. forum/admin/functions.php
In [high]function dooutput()[/high], replace the previous edited code with:
PHP Code:
// ###################### Start dooutput #######################
function dooutput($vartext,$sendheader=1) {

  global $pagestarttime,$query_count,$showqueries,$querytime,$DB_site,$gzipoutput,$gziplevel,$bbuserinfo,$microstats;

  $pageendtime=microtime();

  $starttime=explode(" ",$pagestarttime);
  $endtime=explode(" ",$pageendtime);

  // time format (how many digits you want to show)
  $digits=7;

  $totaltime=$endtime[0]-$starttime[0];
  $trimmedtime=number_format($totaltime,$digits);
  $percentphp=number_format(((($totaltime-$querytime)/$totaltime)*100), 2)."% PHP";
  $percentsql=number_format((($querytime/$totaltime)*100), 2)."% MySQL";

  if ($bbuserinfo['usergroupid']==6) {
    if ($gzipoutput==1) {
      $gziptext="GZIP library compression enabled (level $gziplevel)";
    } else {
      $gziptext="GZIP library compression disabled";
    }
    $debugmode=(DEBUG)?" (Debug mode)":"";
    $versionphp=phpversion();
    $adminstats="PHP version $versionphp $debugmode with $gziptext. [<a href=\"$PHP_SELF?explain=1\" target=\"_blank\">details</a>]";
  } else {
    $adminstats="";
  }

  if ($showqueries) {
    $vartext .= "<!-- Page generated in $totaltime seconds with $query_count queries -->";
  } else {
    eval("\$microstats = \"".gettemplate('home_microstats')."\";");
  } 
2. home_microstats template
replace your vbMicroStats template contents with:
Code:
Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.<br>
$adminstats
if you used the $microstats variable, replace the old code with:
PHP Code:
$microstats = "Page generated in $trimmedtime seconds ($percentphp - $percentsql) with $query_count queries.<br>
               $adminstats"; 

TECK 03-12-2002 06:53 AM
vbMicroStats detailed view (generated by vBulletin):

Jadelit 03-12-2002 07:08 AM
Quote:
Originally posted by nakkid
your forums look great. congrats. however, there is only one thing:
YOU REMOVED THE Jelsoft COPYRIGHT NOTICE.
please re-add it asap, as you infringe vBulletin's copyright and proper usage.
Ok done.

TECK 03-12-2002 07:11 AM
thank you for being professional.
all the best with your work. you deserve it, you did an amasing job there.. ;)

Jadelit 03-12-2002 07:15 AM
thanks again =]

Jawelin 03-12-2002 09:17 AM
Quote:
Originally posted by nakkid
thank you for being professional.
Nakkid! Are you leaving or not !?!? :squareeyed:

Are the others so 'professional' ????
:cool:


All times are GMT. The time now is 02:40 AM.
Page 3 of 24 12 3 4513 Last »
Show 40 post(s) from this thread on one page

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.02461 seconds
  • Memory Usage 1,906KB
  • 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
  • (16)bbcode_php_printable
  • (18)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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