Board Optimization - vBMicroStats

This hack will add at the bottom of each vBulletin (powered) page, the statistics listed below.
Also, it will help you troubleshoot and optimize your vBulletin board by viewing or comparing PHP/MySQL options and other statistics that are normally hidden in your forum pages.

Regular Users:
? Load time of specified page in microseconds
? Number of queries executed
? PHP percent page usage
? MySQL percent page usage

Administrators Only:
? Active users browsing the forum (members and guests) new in 1.1.0
? Server memory usage per page (in Kb)
? Display DEBUG mode status
? Browser GZIP library compression status
? Server average loads
? Uncached templates (useful to troubleshoot the code)

The code modifications were tested into a clean installed vBulletin board. They work 100%.
The hack was tested in vBulletin 3.6.4 and 3.6.5.
If you want to test it into a lower version (3.6.x), let me know.
Also, if you encounter any problems, feel free to post your questions here.

Step by step install instructions are posted into readme.html file.
In order to perform an efficient modification of your files, I recommend you to use Komodo Edit or Textpad.
Both editors will allow you to complete all steps without any coding errors.

The code changes are very safe and designed not to interfere in any way with the vBulletin performance/functionality.
Make sure you modify, save and upload one file at the time to your server.
Then, simply run the product-vbmicrostats.xml file.

[high]The PLUGIN itself is DISABLED by default.[/high]
This was done in order to make sure you properly edit your code first and to avoid surprises.
You will need to enable it, once your code modifications are completed:
Plugins and Products > Manage Products > vB Microstats > Enable (dropdown)
Then, go to your vBulletin Options, click on BB MicroStats setting group and set all your options.

Upgrade to version 1.0.2.
Upgrade to version 1.0.3.
Upgrade to version 1.1.0.

Want to be a guinea pig and try this hack into a higher vBulletin version?
Post your results, so others can read your feedback.

[mark|3]

hi teck i did the instructions but i can seem to get it working

thanks

Originally Posted by TECK

Hi Mark,

Did you enabled the plugin? Please read the product instructions, listed above the screenshots.

[TECK]

There is something missing, very little.
Most likelly, the microstats are not enabled...
Check your code, then read carefully the product description listed above the screenshots.

[mark|3]

Thanks Teck.

I've yet to edit the html.

thanks

[nyunyu]

Teck,

I want to know. Are this normal?
Page generated in 0.18921304 seconds (63.00% PHP - 37.00% MySQL) with 22 queries

Sometimes I got a high percentage of both..how this affect the forum and the server?
Thanks.

[TECK]

Spikes are normal to display, only if the server is not tuned properly. That should be a warning for you, so you look at your logs for possible errors. Where do you run 22 queries, on the forumhome? There is definitely something bad installed. By default vBulletin uses 9 queries on the home page. Personally, I run the forum frontpage on 3 queries and I complain that is to high, I expect to lower it to 2 soon.

Edit: WOW you run 25 queries on forumhome:
http://www.animeheist.com/forum/
Page generated in 0.79363608 seconds (71.49% PHP - 28.51% MySQL) with 25 queries
The percentage looks great, 75% PHP and 25% MySQL is the right balance. However, you have to remove the armada of queries you currently perform on the forumhome, really important for your server performance.

[nyunyu]

So, what can you suggest for me to lessen the queries?
I would very much have any help.

[TECK]

Feel free to open a new thread in the general vb.org forum and you will get your answer in no time. In this way we avoid to hijack the discussion here. Many users are familiar with my mod and they will tell you straightaway where the extra queries are coming from. A hint: The stats them selfs generate a huge number of queries.

See you in General Forum.

[nyunyu]

Sorry for that.
I will open a thread regarding this.
Thank you.

useful mod btw,

[Captain Kirk76]

Is there any chance of this being updated to vB 3.7? I tried it on vB3.7 Beta 2 (now using Beta 5) it didn't display the MySql/PHP usage (it was stuck at 0%)

[TECK]

It should work, did you enabled the product?
I will check the code.
If it needs changes, I will release a new version once we reach RC1 or 2.