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.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
here was a recent stat, more like what I have been getting
Page generated in 24.62768698 seconds (1.19% PHP - 98.81% MySQL) with 14 queries
I just want to know if its my code or server, thanks!
That's really odd. I get these results on my cmps page with 33 queries.
Page generated in 0.23145199 seconds (90.92% PHP - 9.08% MySQL) with 33 queries
------------------------------------
So lets say I have two un-cached templates being detected. Which has just happened after installing a new "Who Was Online Today" module on my cmps page to link to the same mod on the forum so it's displayed on both pages.
What does this mean. Does this mean I now have a problem that needs fixing? Because the two un-cached templates both belong to this new module.
That's really odd. I get these results on my cmps page with 33 queries.
Page generated in 0.23145199 seconds (90.92% PHP - 9.08% MySQL) with 33 queries
------------------------------------
So lets say I have two un-cached templates being detected. Which has just happened after installing a new "Who Was Online Today" module on my cmps page to link to the same mod on the forum so it's displayed on both pages.
What does this mean. Does this mean I now have a problem that needs fixing? Because the two un-cached templates both belong to this new module.
I did this in a 3.0.8 board. Looked fine from administration point of view, but one of my users reported this just seconds after updating all the code:
Warning: main(./includes/db_mysql.php): failed to open stream: No such file or directory in /includes/init.php on line 485
Fatal error: main(): Failed opening required './includes/db_mysql.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/gunloads/public_html/castboolits/includes/init.php on line 485
I started a new forum. I will have a 3.5 version released soon.
I'm pretty sure it will not be a plugin version, due to the way the hack is made previously...
VB3 MicroStats Details »»
About Developer
Visit Web Site
No support by the author.
09-12-2005, 05:14 AM
. Are you going to release one for 3.5?
