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.

[Nj?rd Eriksson]

Originally Posted by TECK

Please check the way you mod the files, make sure you use a good php/text editor, for example TextPad.

I'm glad this tip was useful for you.

Regards,
Floren.

TECK, there is a problem with your hack if one uses it with the German language system offered by vBulletin (works fine with default US English, of course):

Warning: Division by zero in /var/www/html/forum/includes/functions.php on line 1839

Warning: Division by zero in /var/www/html/forum/includes/functions.php on line 1840

This seems to happen, whenever a page is generated in less than 1 second.

These are the lines 1839 and 1840 in functions.php

PHP Code:

    $msphp = vb_number_format(((($totaltime - $querytime) / $totaltime) * 100), 2) . '% PHP';
$mssql = vb_number_format((($querytime / $totaltime) * 100), 2) . '% MySQL'; 


Results for pages generated in less than 1 second:

Page generated in 0,36060596 seconds (0,00% PHP - 0,00% MySQL) with 11 queries

The php warning doesn't appear if a page is generated in more than one second but the results still are inaccurate:

Page generated in 6,94200397 seconds (-10,53% PHP - 110,53% MySQL) with 11 queries

I assume this could be caused by the fact that German uses "," where English uses a "." and vice versa. Do you have a fix for this, please? One that works regardless if one selects English or German as language, preferrably?

[PitchouneN64ngc]

For the division by zero, see the link about that in the first post

[Intex]

Installed and works fine with 3.0.1. Good job Tech .

[high]* Intex clicks INSTALL[/high]

[WEForums]

Nice. I had Erwin's installed thinking he was referring to your vB2 release (which I also had installed), but then I found this post. Might be a good idea to have it linked (in your first post) to this hack as this is a bit better.

Oh, I do have a question, though. I understand the caching part but I am a little confused about a little problem I am having. What if I add the template name to the cached list but it's still showing up as uncached? What could be the issue there?

Just so you know, the template is actually a hack template, so that's probably it. I'm just wanting confirmation. (It's Gary's "Who has been online today" hack. (separate page than the index, though))

[Onkel_Tom]

Originally Posted by WEForums

Nice. I had Erwin's installed thinking he was referring to your vB2 release (which I also had installed), but then I found this post. Might be a good idea to have it linked (in your first post) to this hack as this is a bit better.

Oh, I do have a question, though. I understand the caching part but I am a little confused about a little problem I am having. What if I add the template name to the cached list but it's still showing up as uncached? What could be the issue there?

Just so you know, the template is actually a hack template, so that's probably it. I'm just wanting confirmation. (It's Gary's "Who has been online today" hack. (separate page than the index, though))

same for me
First installed Erwin's version and then installed TECK's much better version !
I've also the problem of the uncached "forumhome_todayloggedinuser" Template from Gary's Who was online today Hack.

[Kohhal]

Great hack, had it on vB2, much easier install on vB3 though

Below are some stats from my site from the last few minutes using vBindex3 - guess it's time to cut some of the info pulled to the front portal page to cut down on that SQL load!

Page generated in 0.35776806 seconds (55.02% PHP - 44.98% MySQL) with 11 queries
Page generated in 0.62210989 seconds (47.07% PHP - 52.93% MySQL) with 11 queries
Page generated in 0.20080590 seconds (74.33% PHP - 25.67% MySQL) with 11 queries
Page generated in 0.30024004 seconds (84.11% PHP - 15.89% MySQL) with 11 queries
Page generated in 2.15881801 seconds (25.50% PHP - 74.50% MySQL) with 11 queries

[neocorteqz]

Originally Posted by TheMasterG

Great hack, had it on vB2, much easier install on vB3 though

Below are some stats from my site from the last few minutes using vBindex3 - guess it's time to cut some of the info pulled to the front portal page to cut down on that SQL load!

Page generated in 0.35776806 seconds (55.02% PHP - 44.98% MySQL) with 11 queries
Page generated in 0.62210989 seconds (47.07% PHP - 52.93% MySQL) with 11 queries
Page generated in 0.20080590 seconds (74.33% PHP - 25.67% MySQL) with 11 queries
Page generated in 0.30024004 seconds (84.11% PHP - 15.89% MySQL) with 11 queries
Page generated in 2.15881801 seconds (25.50% PHP - 74.50% MySQL) with 11 queries

I had the same problem. But it's fine within the forums its self. so i don't think it should really matter, unless you have tons hitting up your portal page at one time.

[The Realist]

I have the following problem:

Page generated in 75498605 seconds (10000% PHP - 0% MySQL) with 12 queries

Any help or ideas why?

[neocorteqz]

Originally Posted by The Realist

I have the following problem:

Page generated in 75498605 seconds (10000% PHP - 0% MySQL) with 12 queries

Any help or ideas why?

Try rehacking the files. start clean.

[The Realist]

Checked code and all is 100%.

Anyone?