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.

[TECK]

I was not clear, sorry... for portals like vbIndex, vbAdvanced, etc. only.
The forums are always ok...

Guys, let me know if you have any portal software installed that give you those weird results. Thanks.

[BarBeQue]

Don't like portals much, i want to see the forums right away.
Which is why i installed the sidebar hack, so it shows a nice left sidebar with some links, rss feeds and arcade news (and a poll as soon as i find out how to add one there) and all my forums to the right next of it.

Mysql % never goes above 15%, most of the time it's like 11-12 %.

Page generated in 0.43167710 seconds (94.18% PHP - 5.82% MySQL) with 10 queries
DEBUG Mode OFF | GZIP ON (level 1) | Server load AVG 0.83 : 1.16 : 1.42

[Reeve of shinra]

Originally Posted by sabret00the

PHP Code:

    $ms .= '        <td class="tcat"' . iif($vboptions['allowchangestyles'], ' colspan="2"') . '><div class="smallfont">'; 


still getting an error on that line

I am recieving the same error. I am running vbIndex dunno if thats an issue here or not.

Parse error: parse error in /home/nytalk/domains/nytalk.net/public_html/board/includes/functions.php on line 1941

Fatal error: Call to undefined function: exec_nocache_headers() in /home/nytalk/domains/nytalk.net/public_html/board/admincp/global.php on line 37

[TECK]

Reeve, the code posted above simply adds a colspan, if you have enabled the style dropdown.
The code was tested in a unhacked board. Please try it in a unmodified board and you will see there are no problems.
If vbIndex creates any problems, I would recommend you to contact the hack author for a workaround.

In the same time, I recommend to all portal users to ask the authors how to reduce the usage of MySQL database.
I saw people using VBportals (like vbIndex, vbAdvanced, etc) who stress to server up to 90% usage... [high]Is really intense.[/high] A normal MySQL usage should be around 10-15%.

Is all in how you write the code, IMO... and you can have the same results... it doesn't have to be intense for the server.
Take a look at those results and let me know what you think.

Regards,
Floren.

[Natch]

Ive just started to get a problem with this showing 100.00% PHP - 0.00% MySQL ..., but with x queries ... anyone seen this problem before ?

EDIT:// Apologies - my bad - I had forgotten to re-edit db_mysql.php after the 3.0.1 upgrade ...

[Boofo]

Originally Posted by Natch

Ive just started to get a problem with this showing 100.00% PHP - 0.00% MySQL ..., but with x queries ... anyone seen this problem before ?

EDIT:// Apologies - my bad - I had forgotten to re-edit db_mysql.php after the 3.0.1 upgrade ...

My goodness.

Where you been, my friend?

[Natch]

I know I know

[high]* Natch eats some more humble pie for breakfast
[/high]

Been busy busy d00d .... trying to survive while not making money is not the easiest thing

[Pseudomizer]

Hello,

after reading the first page and the description i am a little bit concerned. When a guest visits my VBindex portal page i have stats like: 30,23% PHP - 69,77% MySQL.

When i log in as the admin i got stats like 25,72% PHP - 74,28% MySQL.

So i have 2 questions:

1. Any experiences with vbindex portal so far why the MySQL stats are so high ? I know that this should not be placed in this thread but i would like to know if someone has got the same experience with this portal ?

2. which is clearly related to this hack: Why do my stats increase when i log in as admin ? The number of queries stay the same with 16 queries as before.

My loading time for the portal is always 0.7 seconds which i would say is fine.

Any help would be appreciated.

Cheers,

[TECK]

Hi Pseudomizer,
From my experience with this type of portals, I could explain why the MySQL is high.
Normally, the MySQL % is a lot higher then the vBulletin pages because the intense table scans.

VB is very intelligent in this area, it avoids to do full table scans and also it uses a very judicious system cache. All this results in a very low database usage and, indirectly a very low server usage.

Let me be more explicit.
For every option you enable in those portals, you perform extra queries, for each member that access instantly the page. The more members view in the same time the front page, the higher is the stress on the server.
So, if I enter your portal site, in an instance, the software will perform several queries that scan FULLY the hole tables in your database.

A good rule to keep in mind for coders is this: ALWAYS avoid full table scans, is the worst thing in the world.
If you have a very small forum with 200-300 posts, that will not really count, since your database is very small, but what do you do with huge forums who have 1 million posts?
Let's take as example "the x latest threads". The query will perform a full scan from ALL forums and ALL threads. I'm sure you understand why the MySQL % will raise to the sky... for an instance the server will be suffocated with the flood of information it has to compile, in order to display the results, and that?s only for ONE person... imagine what will happen when 500 users will visit in the same time your front page.
What vBulletin does is this: it puts a time/date limit, limits the search for 30 threads and also it separates it only for one forum, not all. So instead of scanning the hole forum/thread tables, it selects a very small portion of it.
The result is obvious, a very small server usage...

I hope that help you understand better the % usage.

Regards,
Floren.

PS. When I have time, I will release my portal version that have a very low MySQL usage.
I posted a screenshot, few posts above, so people can see that is possible to have good MySQL results.

[Pseudomizer]

Hi Teck,

if you should go for your own portal please add me to your list. I would be more then happy to help if you need any help. Meanwhile i will try to limit the SQL queries on my current board.

Thanks for your detailed explanation. If i am successfull i will post my results for crosschecking.

Cheers,