The Arcive of Official vBulletin Modifications Site.

vbMicroStats: page load time, queries, GZIP and PHP version · **Released**: 03-06-2002

[high]Looking for VB3 version? Is here.[/high]

This hack will add at the bottom of each vBulletin(powered) page the following stats:
- load time of specified page in microseconds (with custom no. of digits to show)
- number of queries executed
- server GZIP library compression status
- vBulletin DEBUG mode
- PHP version
- PHP percent page usage
- MySQL percent page usage
- Server Load
[high]This is not only estethic, it will also help you troubleshoot any wierd queries that you have in your scripts.
The hack is template based so you can edit it the way you want in few seconds.[/high]
NOTE: From users experiences, this hack will work only with PHP 4.0.6 or higher. Let me know if it works with a lower PHP version.

THE FIX FOR VB2.3.0 IS HERE.

HACK UPDATES
Version 2.1
------------------------------------
Changes:
- added Server Load

NOTE: I spoked with Kevin 'tubedogg' from vBulletin Support team and he explained to me that not all the servers are configured to support the [high]@exec("uptime")[/high].
Contact your host for more details and ask them about this issue.
For a full explanation of your 3 server load values, read more here.

*If you want to have the stats viewable only by admins, read this post.

Version 2.0
------------------------------------
Changes:
- added vBulletin DEBUG Mode
- removed the Details link
- cleaned a little the code to match VB2.2.6
- better explanations into the install file.

Version 1.7
------------------------------------
[high]VB2.2.5:[/high]
Minor change in admin/db_mysql.php. Read more here on how to update your hack.
Minor change in forum/global.php. Read more here on how to update your hack.

Changes:
- corrected negative values on certain servers.

Version 1.6
------------------------------------
Changes:
- PHP version and GZIP library status viewable only to admin.
- added a link to Detailed Stats View (generated by vBulletin), for that specific page. Only admins can view that link.

To see how it looks a Detailed View, click here.

Version 1.5
------------------------------------
Added:
- GZIP library status is now related to your vBulletion options.
- GZIP library compression level.

Version 1.4
------------------------------------
Bugs corrected:
- GZIP library status not displayed properly on certain servers.

Version 1.3
------------------------------------
Bugs corrected:
- vbPortal display code in modules

The hack is template based now.
All you have to do is call it with the {getmicrostats} string, anywhere you want (for example in footer).
You also have the choice to install it as template based or coded directly into your functions.php file.

Version 1.2
------------------------------------
Added the PHP and MySQL page percentage.
(Addon by Chen 'FireFly' Avinadav)

Version 1.1
------------------------------------
vB.org decided to add this hack to their board.

Bugs corrected:
- incorrect time load
- incorrect query count

You like this hack? Please click on the [high]Install[/high] button.
To download the latest version of this hack, click below:

neocorteqz · #**802** 04-21-2003, 07:11 AM

Quote:

Today at 01:38 AM Sanjiyan said this in Post #800
Using the 2.3.0 version, and installed on 2.3.0 fine, apart from I get this:

Page generated in 1,050,903,363.6694 seconds (100.00% PHP - 0.00% MySQL) with 24 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP enabled - level 2]

How do I change the Page generated in x.xxxxxxxx down to 1.234 seconds

And

It seems I have 100% PHP Load and 0% MySQL ??

Its running on a Windows XP Box atm.

change this value

// time format (how many digits you want to show)
$digits=8;

to anything you want, it's located in admin/functions
about 8 lines from

// ###################### Start dooutput #######################

as for the 100% PHP, rehack db_mysql.php, i believe thats the file..

I also have noticed you have your gzip level at 2, i was lead to believe then anything over a 1, wouldn't be any better. and would create more load. anyone else know if this is true??
https://vborg.vbsupport.ru/showthrea...ression+levels

ap0c · #**803** 04-21-2003, 10:08 AM

Quote:

Yesterday at 10:49 PM TECK said this in Post #798
76 queries??? This is huge, I hope you own the server because if it's a busy site, it will crash it.

I had to do some work

, the 76 queries came from the portal home page. It's down to Page generated in 0.16658294 seconds (83.29% PHP - 16.71% MySQL) with 55 queries, 44 queries for normal members.

the forum home page itself is now at 25 queries which seems about as good as I can get it.

Sanjiyan · #**804** 04-21-2003, 03:03 PM

Quote:

Today at 08:11 AM User_001 said this in Post #801
change this value

// time format (how many digits you want to show)
$digits=8;

to anything you want, it's located in admin/functions
about 8 lines from

// ###################### Start dooutput #######################

as for the 100% PHP, rehack db_mysql.php, i believe thats the file..

I also have noticed you have your gzip level at 2, i was lead to believe then anything over a 1, wouldn't be any better. and would create more load. anyone else know if this is true??
https://vborg.vbsupport.ru/showthrea...ression+levels

I did this for the $digit:

PHP Code:


			
  // time format

  $digits=4;

  $totaltime = $endtime[0] - $starttime[0] + $endtime[1] - $starttime[1];

  $trimmedtime = number_format( $totaltime , $digits );

  $percentphp = number_format( ( ( ( $totaltime - $querytime ) / $totaltime ) * 100 ) , 2 ) . '% PHP';

  $percentsql = number_format( ( ( $querytime / $totaltime ) * 100 ) , 2 ) . '% MySQL';

And its still doing like 12 digitis long, and rehack the db_ file? I followed the install file right, I triple checked, after reading the thread, but its still doing it, I used the 2.3.0 verison of the hack, as I have a 2.3.0 board, or should I apply the older version?

neocorteqz · #**805** 04-21-2003, 04:42 PM

Quote:

Today at 11:03 AM Sanjiyan said this in Post #803
I did this for the $digit:

PHP Code:

// time format $digits=4; $totaltime = $endtime[0] - $starttime[0] + $endtime[1] - $starttime[1]; $trimmedtime = number_format( $totaltime , $digits ); $percentphp = number_format( ( ( ( $totaltime - $querytime ) / $totaltime ) * 100 ) , 2 ) . '% PHP'; $percentsql = number_format( ( ( $querytime / $totaltime ) * 100 ) , 2 ) . '% MySQL';

And its still doing like 12 digitis long, and rehack the db_ file? I followed the install file right, I triple checked, after reading the thread, but its still doing it, I used the 2.3.0 verison of the hack, as I have a 2.3.0 board, or should I apply the older version?

The original instructions Work Great for me. No problems

and

Page generated in 0.1956 seconds (76.11% PHP - 23.89% MySQL) with 30 queries.

don't know why your didn't work...

Sanjiyan · #**806** 04-21-2003, 05:35 PM

could it be that I am running it under Apache 2 and Windows XP Pro?

TECK · #**807** 04-22-2003, 06:59 PM

Quote:

Yesterday at 06:38 AM Sanjiyan said this in Post #800
Using the 2.3.0 version, and installed on 2.3.0 fine, apart from I get this:

Page generated in 1,050,903,363.6694 seconds (100.00% PHP - 0.00% MySQL) with 24 queries.
[Debug Mode OFF] [PHP v4.3.1] [GZIP enabled - level 2]

How do I change the Page generated in x.xxxxxxxx down to 1.234 seconds

And

It seems I have 100% PHP Load and 0% MySQL ??

Its running on a Windows XP Box atm.

You did not hacked properly the db_mysql.php file.

Sanjiyan · #**808** 04-23-2003, 02:46 PM

TECH,

I've just reapllied the hack and it still displays 100% for PHP and 0% for MySQL.

I have attached the db_mysql.php file below, if I could borrow some of your time, in looking through the file, just to be sure I would be greatful.

Thanks

Red Blaze · #**809** 04-23-2003, 05:30 PM

Ok, I got this error.

Parse error: parse error, unexpected $ in /home/thesonic/public_html/vbtesting/admin/functions.php on line 1101

I went to line 1101 and couldn't find that "$".

EDIT: Nevermind, it got fixed on its own. :S

solent · #**810** 04-24-2003, 01:38 PM

help please

i have installed this hack and i get no errors at all. the problem is that i dont know the exact place to place this stats. and in some of the variables i get no value (see atach file).

can anyone point to me in which templates i need to edit to show the microstats at the bottom of every page as in vb.org?

also is the result shown in the attachment correct or i am doing something wrong with it?

I am using the template based version on vb2.3.0.

Thanks.

greate hack by the way. i love it.

Red Blaze · #**811** 04-24-2003, 04:54 PM

You have to place the variable into your footer. Preferably towards the bottom. Read the instructions, it tells you what variable to put.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09168 seconds Memory Usage 2,337KB Queries Executed 27 (?)
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 (2)bbcode_php (5)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 (3)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_postinfo_query fetch_postinfo 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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!