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:

[FWC]

Originally posted by Viruseater
here's the results of the query.

Page generated in 1,017,549,010.701014 seconds (100.00% PHP - 0.00% MySQL) with 21 queries.

You hacked the wrong file. You will get that result if you modify admin/global.php instead of the global.php in the forums root. I know, I found out the hard way.

[Viruseater]

That sounds like exactly what I likely did.

Doesn't make sense to me that there'd be duplicate file names like that, but I'm no coder, so I'll keep my mouth shut prior to making a fool of myself.

I found another error, so I wiped the entire board, and am setting it up again, so I'll hack the right file now

thanks for the replies!

[TECK]

Viruseater, check your code. you get those values only because vB is looking for [high]$pagestarttime[/high] and it can't find it.
if you check all the steps carefully, you will see your mistake.

regards,
nakkid.

[Jawelin]

Originally posted by nakkid
strange indeed. so you get those values only with the microtime from php.net? as a .php file? or part of vBulletin?

Nakkid, yes, I used VBulletin files, double checked your v1.7 hack
statements against my modified files. Last, as said, I put the
getmicrotime() function in admin/functions.php exactly
as it's described on www.php.net

This is exactly what I did: I used two files index.php, called
index224_plain.php and index224_hackd.php and uploaded to
forum home dir, respectively the original 2.2.4 version and the
hacked one.

Both with some mods:

PHP Code:

// just after
require('./global.php');
// put
$custompagebeginmicrotime = (float)getmicrotime();


// Then, in 4-5 different points of the two files (same points), i put these two rows:
$bulkloadmicrotime = number_format(getmicrotime()-$custompagebeginmicrotime,7);
echo "<font size=1 face='arial'>Bulk load microtime [qrs=$query_count] (xxxx breakpoint identification) = <b>$bulkloadmicrotime</b></font><br>"; 


Besides, in global.php with an

PHP Code:

echo "<h1>Pagestarttime Global reset</h1>" 


just after the $pagestarttime=microtime() at the beginning
of the page, I ensured that script is called only ONCE by index.php...

Note: last two days, for some unexplained reason, my server
disabled GZip and any other encoding ... I hope it's a short time event...

PLAIN index.php
---------------
Bulk load microtime [qrs=6] (start time)                                        = 0.0000969
Bulk load microtime [qrs=13] (after processing main SELECT group)               = 0.0069339
Bulk load microtime [qrs=19] (after processing most SELECTs and some templates) = 0.0228729
Bulk load microtime [qrs=19] (before processing main template)                  = 0.0863299
{ getmicrostats }=  Page (81.17% PHP + 18.83% MySQL) with 19 queries generated in 0.1926436
Bulk load microtime [qrs=20] (after processing all templates)                   = 0.7915579


HACKED index.php
----------------
Bulk load microtime [qrs=6]  (start time)                                       = 0.0000930
Bulk load microtime [qrs=26] (after processing main SELECT group)               = 0.5236299
Bulk load microtime [qrs=33] (after processing most SELECTs and some templates) = 0.5396340
Bulk load microtime [qrs=38] (before processing main template)                  = 0.6587319
{ getmicrostats }=  Page (20.74% PHP + 79.26% MySQL) with 38 queries generated in 0.7506131
Bulk load microtime [qrs=39] (after processing all templates)                   = 2.1796360

As you can see, the results pointed out most of the page time is
taken by the forumhome template processing. Much more than all
the SELECTs (38 with hacks, 19 with the plain version). And the
{ getmicrostats } is evalued BEFORE the
template is loaded and processed. Infact that value is almost
similar to mine as computed immediately before the eval
("forumhome template").

Of course, the doubled number of queries in the hacked version
reversed also the percentage ratio of php vs. sql ...

Interesting, isn't it ?

Hope I was able to explain myself
:stupid:

Thanks.

[TECK]

i dont know what to say Jawelin. anyone else have the same problem? so far everyone is really happy with 1.7...

[Viruseater]

Got it worked out Nakkid, thanks.

I've got 1.6 running on the current board, which I just put into production. www.clanservers.net/forum and I'll do the upgrade next.

Like the hack, and it's got some great debug features.

great job

[Jawelin]

Originally posted by nakkid
i dont know what to say Jawelin. anyone else have the same problem? so far everyone is really happy with 1.7...

Absolutely NO PROBLEM, Nakkid.
I went deeper only to investigate better why times reported are so different each other.
As said before, version 1.7 is absolutely stable and works perfectly... Never had negative (or > 100) values any more...
Even, I verified global.php is called only once.

The strange even is the greatest processing time is taken by the 'eval ... forumhome template', not by my 38 queries on the homepage.... :nervous: :nervous:

Thanks again for support.
I exposed my search results only to have some number to talk about.
Bye

[TECK]

Originally posted by Jawelin
As said before, version 1.7 is absolutely stable and works perfectly... Never had negative (or > 100) values any more...
Even, I verified global.php is called only once.

ok.. just wanted to make sure i understood you corectly.

[dyt4]

just another little question about time I obtain always page generated in between 0.5 and 1.5 seconds . But I look at my watch it's often 10 or 20 seconds with my ISDN connection and 2 seconds with my DSL connection at work ???

[TECK]

do you have v1.7 installed?
on my localhost (no internet connection) i got up to 2.600000seconds to load a page, depending what i was doing.
look here at vB.org:
[high]Page generated in 5.97940302 seconds (74.72% PHP - 25.28% MySQL) with 38 queries.[/high]

[Jawelin]

I definetively don't think the connection speed could affect any way the page generation time on the server side (i.e. php + sql time ARE server times)....

I'm talking about different measurements of the same server-side time in different page 'breakpoints'... let's say.

[TECK]

actually it depends a little in your pc performance. if you have a slow pc, the time it takes to load the page will reflect it.
i did a test, on several pc's, at work... to load vB.org. i got different values (huge ones) on winXP, win2k and win98 (P4, P2 and AMD). here there are the results:
win98(AMD) - 4.00 seconds
win2k(P2) - 2.00 seconds
winXP(P4) - 0.80 seconds

internet connection: T1 (all cases)

[Admin]

Actually nakkid it has nothing to do with that. From the second the server gets a request for the PHP page the parser is doing all the work, not your computer.

[TECK]

this is wierd. i wonder why i got those stats. all pc's were connected to the same network.

thanks for the explanation firefly.

[Legacy]

Page generated in 1,018,162,977.218 seconds(100.00% PHP - 0.00% MySQL) with 28 queries.
PHP version 4.1.2 (Debug mode) with GZIP library compression enabled (level 2). [details]

MySQL always comes up 0.00%...anyone know why??