vbMicroStats: page load time, queries, GZIP and PHP version

[high]Looking for VB3 version? Is here.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
- load time of specified page in microseconds (with custom no. of digits to show)
- number of queries executed
- server GZIP library compression status
- vBulletin DEBUG mode
- PHP version
- PHP percent page usage
- MySQL percent page usage
- Server Load
[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.
The hack is template based so you can edit it the way you want in few seconds.[/high]
NOTE: From users experiences, this hack will work only with PHP 4.0.6 or higher. Let me know if it works with a lower PHP version.

THE FIX FOR VB2.3.0 IS HERE.

HACK UPDATES
Version 2.1
------------------------------------
Changes:
- added Server Load

NOTE: I spoked with Kevin 'tubedogg' from vBulletin Support team and he explained to me that not all the servers are configured to support the [high]@exec("uptime")[/high].
Contact your host for more details and ask them about this issue.
For a full explanation of your 3 server load values, read more here.

*If you want to have the stats viewable only by admins, read this post.

Version 2.0
------------------------------------
Changes:
- added vBulletin DEBUG Mode
- removed the Details link
- cleaned a little the code to match VB2.2.6
- better explanations into the install file.

Version 1.7
------------------------------------
[high]VB2.2.5:[/high]
Minor change in admin/db_mysql.php. Read more here on how to update your hack.
Minor change in forum/global.php. Read more here on how to update your hack.

Changes:
- corrected negative values on certain servers.

Version 1.6
------------------------------------
Changes:
- PHP version and GZIP library status viewable only to admin.
- added a link to Detailed Stats View (generated by vBulletin), for that specific page. Only admins can view that link.

To see how it looks a Detailed View, click here.

Version 1.5
------------------------------------
Added:
- GZIP library status is now related to your vBulletion options.
- GZIP library compression level.

Version 1.4
------------------------------------
Bugs corrected:
- GZIP library status not displayed properly on certain servers.

Version 1.3
------------------------------------
Bugs corrected:
- vbPortal display code in modules

The hack is template based now.
All you have to do is call it with the {getmicrostats} string, anywhere you want (for example in footer).
You also have the choice to install it as template based or coded directly into your functions.php file.

Version 1.2
------------------------------------
Added the PHP and MySQL page percentage.
(Addon by Chen 'FireFly' Avinadav)

Version 1.1
------------------------------------
vB.org decided to add this hack to their board.

Bugs corrected:
- incorrect time load
- incorrect query count

You like this hack? Please click on the [high]Install[/high] button.
To download the latest version of this hack, click below:

[eva2000]

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]

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]

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]

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]

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

[TECK]

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]

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

[TECK]

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]

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]

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..