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:

[LangTuDaTinh]

trafix,, use the old version.(da one from page 1)..it's working.. i tried the new version....i doesn't work...

[neocorteqz]

Again, I'm using the original install of this hack with no problems, i had the same problem with it showing a 100% PHP.. I believe I was told to rehack db_mysql.php... or something like that.

[neocorteqz]

btw, is this good??

Page generated in 0.29245400 seconds (86.12% PHP - 13.88% MySQL) with 30 queries

thats using the updated version of MySQL(v4.0.12) and php(v4.3.1)

or are the queries still too high? and I'm starting to notice that in thread view there are no more than 30 queries tops...

[Oblivion Knight]

Today at 06:55 PM User_001 said this in Post #793
btw, is this good??

Page generated in 0.29245400 seconds (86.12% PHP - 13.88% MySQL) with 30 queries

thats using the updated version of MySQL(v4.0.12) and php(v4.3.1)

or are the queries still too high? and I'm starting to notice that in thread view there are no more than 30 queries tops...

Yes that's good
As long as you're below 40 queries on any page, then your database isn't under too much load.

86.12% PHP is also pretty damn good, mine's only about 64%..

[Alien]

Works great in my 2.3.0 I'm working on..

Excellent hack, thanks a bunch!

[ap0c]

installed on 2.30 and working fine, I guess. I don't like the amount of queries...76,lol

[Mr. X]

04-09-03 at 01:34 PM Mr. X said this in Post #783
Just wondering, and sorry if its been posted already, but can and how can I move the [Debug Mode OFF] [PHP v4xxx] [GZIP disabled] [Server Load: xxx? xxx: xxx] line so that it is after the Page Generated line? Im using the PHP based code, not the template to have it appear in my footer. It appears fine for users, but for admins we see the 2nd line, and for some reason its adding an ugly space to my footer. Is there anyway to just move that line up after the Page Generated line, so it'll be just one sentence?

nvm I got it..

[TECK]

Yesterday at 04:37 AM ap0c said this in Post #796
installed on 2.30 and working fine, I guess. I don't like the amount of queries...76,lol

76 queries??? This is huge, I hope you own the server because if it's a busy site, it will crash it.

[cinq]

Cool stuff , added this without a hitch , was just trying to find out the no. of queries mine was dishing out.

But need some explanation on this :

Page generated in 0.20807695 seconds (30.47% PHP - 69.53% MySQL) with 23 queries.
[Server Load: 0.62 » 0.66 : 0.74]

What does the 30.47% PHP - 69.53% MySQL mean ?
Is 23 queries alright ? Anyway to cut it down ?
And server load bit , what does it mean ?

Sorry if this is out of the topic but didnt know where else to ask.
Thanks

[Sanjiyan]

Using the 2.3.0 version, and installed on 2.3.0 fine, apart from I get this:

Page generated in 1,050,903,363.6694 seconds (100.00% PHP - 0.00% MySQL) with 24 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP enabled - level 2]

How do I change the Page generated in x.xxxxxxxx down to 1.234 seconds

And

It seems I have 100% PHP Load and 0% MySQL ??

Its running on a Windows XP Box atm.