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:

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