vBMicrostats

Finally, the vBMicroStats product for vBulletin 3.5.4 is here.
The previous versions of my mod were very solicited by vBulletin administrators...
I hope you will enjoy this new version as much you did the other ones.

Looking for VB 3.6.x version? It is here.

This mod with 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:
? Server memory usage per page (in Kb)
? DEBUG mode status
? Browser GZIP library compression status
? Server average loads
? Uncached templates (useful to troubleshoot the code)

The code modifications listed below were tested into a clean installed vBulletin board. They work 100%.
If you encounter any problems, feel free to post your questions here.

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

I tried to use the plugin system as much as I could, in order to avoid any unnecessary code modifications.
In order to set the right query execution time, you will need to perform 2 small code changes to each of the following files:
? class_core.php (folder /includes)
? init.php (folder /includes)

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-plugin_vbmicrostats.xml file.

Once the product installed, don't forget to enable it.
Go to your vBulletin Options, click on BB MicroStats setting group and set all your options.

[kellyandmike]

I installed it and here is what it says at the bottom of the page for two different page loads...

Page generated in 1.477 seconds (23.55% PHP - 76.45% MySQL) with 9 queries

Page generated in 2.044 seconds (-3.44% PHP - 103.44% MySQL) with 11 queries

Page generated in 4.277 seconds (-19.53% PHP - 119.53% MySQL) with 12 queries

What do these numbers mean?

[Boofo]

Originally Posted by kellyandmike

I installed it and here is what it says at the bottom of the page for two different page loads...

Page generated in 1.477 seconds (23.55% PHP - 76.45% MySQL) with 9 queries

Page generated in 2.044 seconds (-3.44% PHP - 103.44% MySQL) with 11 queries

Page generated in 4.277 seconds (-19.53% PHP - 119.53% MySQL) with 12 queries

What do these numbers mean?

Follow the instructions in this post. That fixed this problem for me, so far.

https://vborg.vbsupport.ru/showpost....&postcount=123

[kellyandmike]

Wow, Just did it and that helped the speed of the page loads immediately!

[kellyandmike]

I think I spoke too fast. It was really fast at first and now it's slow again. This just stinks! Any other suggestions?

[kissythecutie]

sorry iam a newbie but what is the reak benefit of this hack

[TECK]

Originally Posted by kellyandmike

I think I spoke too fast. It was really fast at first and now it's slow again.

This mod does not modify the time it takes to load a page. It reads it only.

[phkk]

Originally Posted by TECK

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.

how can we fix it?

I have bad piece of code

Page generated in 2.74304891 seconds (62.81% PHP - 37.19% MySQL) with 22 queries

:down: :down: :down: :down: :down:

[TECK]

Originally Posted by Boofo

Follow the instructions in this post. That fixed this problem for me, so far.

https://vborg.vbsupport.ru/showpost....&postcount=123

It looks like the wierd times are comming from future. Scott and Freddie are looking into this problem...
It might be related to the time it takes to count the connection execution, that's the reason I asked you to disable it for now.

I'm waiting on Scott to give more feedback on vBulletin's behaviour.
http://www.vbulletin.com/forum/bugs3...iew&bugid=2481

[Boofo]

Originally Posted by TECK

It looks like the wierd times are comming from future. Scott and Freddie are looking into this problem...
It might be related to the time it takes to count the connection execution, that's the reason I asked you to disable it for now.

I'm waiting on Scott to give more feedback on vBulletin's behaviour.
http://www.vbulletin.com/forum/bugs3...iew&bugid=2481

Well, it seems to be working right for now with that disabled.

[CP,]

Hi its ive installed it without any errors or anything but for me nothing is showing, ive enabled it also