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.

[meissenation]

I've got MicroStats enabled but it just doesn't show up for me. Any ideas?

[TheMilkCarton]

Try editing the footer template?? There shouldn't be any other reason it doesn't show up.

[stwilson]

Love the mod! I have a question. My stats are consistently showing:

Page generated in X.X seconds (2.24% PHP - 97.76% MySQL) with X queries

My configuration is one where I have the web server (dedicated) and a separate MySQL server (shared). With most of my page loads coming in at just above 5 seconds and hovering around 98% MySQL...is it safe for me to assume I need to get on a faster MySQL server to balance this out some or am I reading the stats wrong? Thatnk you for your hard work.

[TECK]

I would get another server, then do a balanced load proxy on them.
Personally, I would buy the servers and look near my house for a colocation center. You will save a ton of money every month.
How big is your site?

[stwilson]

My site is about 12K+ members, with concurrent users hovering about 50-75 at any given time and daily uniques at about 1,200.

[curriertech]

Originally Posted by TECK

Yes, it can. Look into the XML file at the bottom, where you have the template listed.
Edit it the way you like it.
Then, uninstall the current hack and reinstall it again, using your new XML file with applied modifications.

Awesome, thanks!

[TECK]

Originally Posted by stwilson

My site is about 12K+ members, with concurrent users hovering about 50-75 at any given time and daily uniques at about 1,200.

Use your dedicated server for both web and mysql server.

[fn9mm]

Originally Posted by TECK

Check your code edits.

got it,
all the changes i made to class_core.php and init.php file were somehow undone,
don't get it how or why, i implemented all the required changes a week ago,
thx anyway
great mod !!

[TECK]

Good job.
As I said before, the hack is very safe for vBulletin. If you do something bad, it will not break your site.
The worst it will happen is not to show the right info.

[Xplorer4x4]

TECK, I found a slight conflict with another mod. I am using the "Show Users using Style in Style Chooser" which I believe was developed by Kirby/Andreas along with this hack, and noticed the following:

If I install Microstats over the other hack, the other hack fails to function. I have to install Andreas' hack over this one.

I was wondering if it would be possible for you to develope something similar in to this hack since this is a stats hack and all.