Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.0 > vBulletin 3.0 Full Releases

Reply
 
Thread Tools
VB3 MicroStats Details »»
VB3 MicroStats
Version: 1.00, by TECK TECK is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Version: 3.0.0 Rating:
Released: 03-04-2004 Last Update: Never Installs: 157
 
No support by the author.

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.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #122  
Old 04-12-2004, 01:23 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by neocorteqz
Page generated in 3.35731196 seconds (9.05% PHP - 90.95% MySQL) with 17 queries
It's totally extreme, I can't believe it that the code generate this kind of stress on the server.
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.

I would like to know if other coders who use those portals have the same results... could be a server issue also??? Thanks guys for sharing.
Quote:
Originally Posted by Christine
Teck -- So you know, the blue highlighting isn't working in Opera 7.23. It is fine in IE 6 and FireFox 0.8.
Thanks for the info Christine, I will make sure it's linked to the first post.
Quote:
Originally Posted by djohn
Thank you very much TECK, that did help a great deal. You were, I do have 3 categories and 9 forums with 2 sub-forums
Glad that helped you... my little VB speech.

Guys, if you have any questions, feel free to ask them.

Just as an off-topic subject, I just got off the hospital, after a very bad infection that knocked me off the real world for almost a week... my sinuses started to be really inflamated then my lungs got filled with infection, follwed by the ears... it was really bad...
But, with a lot of care from my wife and mom, I was able to get back today on my feet and walk outside of the house a little...
Glad to see you all ok, here, in our little family, and share this with you.
Reply With Quote
  #123  
Old 04-12-2004, 01:29 AM
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Location: Des Moines, IA (USA)
Posts: 15,776
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TECK
Just as an off-topic subject, I just got off the hospital, after a very bad infection that knocked me off the real world for almost a week... my sinuses started to be really inflamated then my lungs got filled with infection, follwed by the ears... it was really bad...
But, with a lot of care from my wife and mom, I was able to get back today on my feet and walk outside of the house a little...
Glad to see you all ok, here, in our little family, and share this with you.
I think it's in the rules somewhere where you're allowed to go off-topic in you're own thread, Floren.

Sorry to hear about you being down. I hope you're feeling better, my friend. We need you aorund here so take care of yourself and get healthy. Boofo's orders.
Reply With Quote
  #124  
Old 04-12-2004, 01:29 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
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
What is the error? Thanks for posting.
Quote:
Originally Posted by Boofo
I think it's in the rules somewhere where you're allowed to go off-topic in you're own thread, Floren.

Sorry to hear about you being down. I hope you're feeling better, my friend. We need you aorund here so take care of yourself and get healthy. Boofo's orders.
Thanks for the info and... the kind words, Bob. Cheers.
Reply With Quote
  #125  
Old 04-12-2004, 02:18 AM
Christine's Avatar
Christine Christine is offline
 
Join Date: Oct 2001
Location: PA
Posts: 472
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TECK
What is the error? Thanks for posting.

Thanks for the info and... the kind words, Bob. Cheers.
Sorry to hear that Floren. Feel better soon!!
Reply With Quote
  #126  
Old 04-12-2004, 06:02 AM
ChuanSE's Avatar
ChuanSE ChuanSE is offline
 
Join Date: Feb 2003
Posts: 311
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TECK
Chuan, what portal you use?
Is extremly intense on the table scans... Holly molly...


The number of queries is ok, but the code is not very strong, IMO.
Compare it yourself with any forums page. As soon as you go over 20% MySQL, you got to ask yourself what bad code you added there to perform table scans that generate those results...

Oops, i missed this post hehehe, same reason btw.
I was knocked out for a week by the same kind of infection

But hey, all beter now

I'm using vBadvanced Teck.

Page generated in 1.03972507 seconds (31.84% PHP - 68.16% MySQL) with 19 queries
NO Uncached Templates | DEBUG Mode OFF | GZIP ON (level 2) | 0.22 : 0.90 : 0.62

OMG indeed, how can this happen? allthough the page is generated in 1 sec :|

Anything I can do 'bout this?
Reply With Quote
  #127  
Old 04-12-2004, 06:04 AM
ChuanSE's Avatar
ChuanSE ChuanSE is offline
 
Join Date: Feb 2003
Posts: 311
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

btw, i attached the php file...
Reply With Quote
  #128  
Old 04-12-2004, 01:28 PM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ChuanSE
Oops, i missed this post hehehe, same reason btw.
I was knocked out for a week by the same kind of infection

But hey, all beter now

I'm using vBadvanced Teck.

Page generated in 1.03972507 seconds (31.84% PHP - 68.16% MySQL) with 19 queries
NO Uncached Templates | DEBUG Mode OFF | GZIP ON (level 2) | 0.22 : 0.90 : 0.62

OMG indeed, how can this happen? allthough the page is generated in 1 sec :|

Anything I can do 'bout this?
Same here my friend, I was dead sick also for a week...

About your problem, I guess is all in how you write the code. Take a look at my portal, how the results are for MySQL:
https://vborg.vbsupport.ru/attachmen...chmentid=18003

The MySQL usage is around 10% as it should be normally (not to mention that the page is generated only in 0.2 seconds), the server likes it.
Reply With Quote
  #129  
Old 04-13-2004, 03:27 AM
neocorteqz's Avatar
neocorteqz neocorteqz is offline
 
Join Date: May 2002
Location: Barefoot Bay Fl
Posts: 473
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TECK
It's totally extreme, I can't believe it that the code generate this kind of stress on the server.
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.

I would like to know if other coders who use those portals have the same results... could be a server issue also??? Thanks guys for sharing.

<snip>

Just as an off-topic subject, I just got off the hospital, after a very bad infection that knocked me off the real world for almost a week... my sinuses started to be really inflamated then my lungs got filled with infection, follwed by the ears... it was really bad...
But, with a lot of care from my wife and mom, I was able to get back today on my feet and walk outside of the house a little...
Glad to see you all ok, here, in our little family, and share this with you.

Maybe it's a server issue, but without knowing any other results from other users who have installed vBindex. I couldn't tell you one way or another.

here's what it reads right now.

Page generated in 1.65803409 seconds (31.48% PHP - 68.52% MySQL) with 17 queries

and here's what it reads with just the newsbit and welcome Panel options enabled.

Page generated in 1.21568489 seconds (16.95% PHP - 83.05% MySQL) with 9 queries

and it's pulling Topics from two forums, with a limit of 5 Total threads listed.

I really don't know. I suppose i will ask in his thread. and I will ask my host about any tweaks to MySQL.

edit: good to see your well again. Or at least hoping you are.
Reply With Quote
  #130  
Old 04-13-2004, 11:03 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would like to know also if other users experience those type of percentages (for portals like vbIndex, vbAdvanced, etc. only).
Guys, let us know please.
Reply With Quote
  #131  
Old 04-13-2004, 11:14 AM
PitchouneN64ngc's Avatar
PitchouneN64ngc PitchouneN64ngc is offline
Senior Member
 
Join Date: Aug 2002
Location: France
Posts: 515
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by TECK
I would like to know also if other users experience those type of percentages.
Guys, let us know please.
I can't say for my forum actually but into my forum test, I have:

Quote:
Page generated in 0.29032302 seconds (83,48% PHP - 16,52% MySQL) with 8 queries
So, no problem for me
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:10 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04760 seconds
  • Memory Usage 2,329KB
  • Queries Executed 25 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_php
  • (12)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete