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:

[Jawelin]

Originally posted by nakkid
hmm.. did you tried the simple plain microtime? instead of exploding it like at php.net?

No... See Post #174 above...

I put that getmicrotime() function in functions.php and used it both times, for start and stop time.
Even used strange var names to be sure they weren't messing anything.
And got a final global difference of about 4-6 seconds... The same page, at the end, I see the {gms} var about 0.56xxxxx seconds.

That's very strange...


Thanks

[TECK]

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

[Viruseater]

I read this thread. Well I skipped through it, looking for an error like I'm getting. Didn't see one so I'm posting about it.

I've installed this hack on my webserver. it's pulling some strange information.

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.

Don't think I need to define much, pretty self explanitory.

I'm converting a few UBB's over to vBulletin since I just bought it. (bring 5 UBB's down, and combining them into one VB.

I've hacked the crud out of the UBB's but most of what I want in the boards are already here in VB.

I'm sure it's a newbie thing. Just don't know where to go. I've completed the import of my threads and users, but just cannot figure this out, and want to resolve it before i go to production. You can see the test bed here:

www.clanservers.net/forumtest

If this has already been addressed, I apologize, and if someone could link me to where it's resolved I'd be very greatful.

V

[Viruseater]

and before anyone says how ugly the individual categories are inside, heehe I know, but I don't care about looks on this board, just functionality. So I'll correct the themes when I get everything working.

[TECK]

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

you forgot to edit properly your global.php
check the file.

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