VB3 MicroStats

You asked for... but it was available for VB2 only? There you go, you have it now.

Looking for 3.5.4 version? Get it here.

VERSION 1.2 RELEASED
Basically the only difference you will notice is a dropdown menu that will display the unchached templates.
In this way, you can add it to the cache and save one or more queries.

[high]THIS HACK WAS TESTED IN A DEFAULT, CODE UNMODIFIED BOARD.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
REGULAR USERS STATS
- load time of specified page in microseconds (with custom no. of digits to show)
- percentages of PHP/MySQL usage
- number of queries executed

ADMINISTRATOR STATS
- number/name of uncached templates (name highlighted in blue, for uncached template)
- vBulletin DEBUG mode status
- server GZIP library compression status
- average Server Loads

[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.[/high]

IMPORTANT
If you get results like:
Page generated in 3.35731196 seconds (9.05% PHP - [high]90.95%[/high] MySQL) with 17 queries
You probably use a bad piece of code, because vBulletin will never generate those extreme results.
Imagine this: the code uses only 10% the resources to read the actual PHP code and the rest of 90% is used only to scan the tables... WOW!
That means the code forces to read into the database for each user who visits the site at this percentage... if you have 1000 users viewing the page in the same time.. you can get a picture of it...
If you compare this with vBulletin, the software does the opposite, 90% PHP and 10% MySQL... the right way.

DIVISION BY ZERO ERROR? Read this.
INVALID STATS IF MYSQL COMPILED IN A NON-ENGLISH LANGUAGE? Read this.

NOTE: The blue highlighting is not working in Opera 7.23 version. (Thanks Christine)

Have fun.

[RaceJunkies]

Got it working now.... :devious:

[NxTek]

REGULAR USERS
- load time of specified page in microseconds
- number of queries executed
- PHP percent page usage
- MySQL percent page usage

How can I display MicroStats only to Administrators? Call me crazy but do you really think members in Registered Users really care about this?

[Pseudomizer]

Originally Posted by NxTek

How can I display MicroStats only to Administrators? Call me crazy but do you really think members in Registered Users really care about this?

In your template: if bbusergroupid = 6 bla bla before the {ms} entry and an endif after and all set all done.

Cheers,

[NxTek]

I'll give that a try. Thanks.

I'm using vB, vBadvanced, and a custom PHP/MySQL application within vBadvanced. Will MicroStats report ALL the stats?

[ManagerJosh]

Hey Teck:

Any ETA on the 3.5 Version ?

[csidlernet]

/me installed this hack in 0.1seconds

[NxTek]

Originally Posted by NxTek

I'll give that a try. Thanks.

I'm using vB, vBadvanced, and a custom PHP/MySQL application within vBadvanced. Will MicroStats report ALL the stats?

Anyone?

[Wrestling-Freek]

Awesome hack!!

Just what I've been looking for!

Thanks.

[bjs144]

Top mod.

Thanks alot

[Mikecp421]

I have been having a slowdown on my site all day. I installed this hack to get info on it and could someone tell me what this means.

Page generated in 28.27157903 seconds (0.86% PHP - 99.14% MySQL) with 12 queries

THat was the result of posting a message.

and this was the loading of my index

Page generated in 2.80730700 seconds (9.32% PHP - 90.68% MySQL) with 10 queries

although it was fast this time would those numbers point towards a potential bad code somewhere? I did some editing, thats why I ask, Thanks.