Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
vbMicroStats: page load time, queries, GZIP and PHP version Details »»
vbMicroStats: page load time, queries, GZIP and PHP version
Mod Version: 1.00, by TECK (Coder) TECK is offline
Developer Last Online: Aug 2013 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (8 votes - 5.00 average) Installs: 595
Released: 07 Mar 2002 Last Update: Never Downloads: 37
Not Supported  

Looking for VB3 version? Is here.

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
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.

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 @exec("uptime").
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
------------------------------------
VB2.2.5:
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 Install button.
To download the latest version of this hack, click below:

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #151  
Old 21 Mar 2002, 22:58
Jawelin Jawelin is offline
 
Join Date: Nov 2001
Just an addendum

I still obtain negative values (i.e. ending times smaller than starting times in db_mysql ... :surprised: :surprised: ) !!!!

For example, on DETAILS against my forumhome page, I got something like:
Page generated in -0.484897 seconds with 36 queries,
spending 0.47043216228485 doing MySQL queries and -0.95532916228485 doing PHP things.
The same page gave these percentages:
Page generated in 0.20868 seconds (-118.92% PHP v4.1.2 - 218.92% MySQL) with 35 queries.
:dead:

Pragmatically, how could I correct in functions.php out-of-scale values of mySql times ? I though something like val % 100, but... :laugh:

Thanks
Reply With Quote
  #152  
Old 22 Mar 2002, 11:59
JDD JDD is offline
 
Join Date: Oct 2001
for me it's the same, installed the latest version (on vB 2.2.4), and from time to time I get negative values:

this is an result for my forum home page:
Page generated in 0.5797920 seconds (-8.82% PHP - 108.82% MySQL) with 23 queries.
PHP version 4.0.6 (Debug mode) with GZIP library compression disabled. [details]
I am sure that I hacked the files correctly (checked it several times)

Strange is that the timedisplay is positive but the percentage values are negative

I put {getmicrostats} into the footer template

Greets
JDD
Reply With Quote
  #153  
Old 22 Mar 2002, 14:01
wooolF[RM]'s Avatar
wooolF[RM] wooolF[RM] is offline
 
Join Date: Jan 2002
same here...
__________________

It's nice to be important but it's more important to be nice.
--------------------------------------------------------------------------------------------------------------------------------------------
Never discuss with an idiot, he'll just pull you down to his own level and beat you with experience!
--------------------------------------------------------------------------------------------------------------------------------------------
Its not the penis that makes the man, its the way he uses it.
Reply With Quote
  #154  
Old 23 Mar 2002, 20:16
cihangir's Avatar
cihangir cihangir is offline
 
Join Date: Nov 2001
same here:

Page generated in 0.0731950 seconds (-1,558.43% PHP - 1,658.43% MySQL) with 24 queries.
PHP version 4.0.6 (Debug mode) with GZIP library compression enabled (level 1). [details]
but i get negative values only on the frontpage. (installed on v2.2.4 and 'no template' Mod )
__________________
www.zoque.com
Reply With Quote
  #155  
Old 23 Mar 2002, 22:38
forumuser forumuser is offline
 
Join Date: Feb 2002
do you guys ever have a problem editing files, like some files just wont accept anymore text or something? WHat is up with that? I cant install this hack cause the file wont take anymore text
Reply With Quote
  #156  
Old 26 Mar 2002, 02:00
NetherChris NetherChris is offline
 
Join Date: Nov 2001
Why does it always show Debug Mode as on? It's spefically disabled in PHP... but on all other notes this hack is WONDERFUL!
Reply With Quote
  #157  
Old 26 Mar 2002, 05:36
scotty's Avatar
scotty scotty is offline
 
Join Date: Oct 2001
please help!
----
the first few seconds after installing everything worked fine with that hack, but round about a minute after installing it all users became this error:

Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,location) VALUES ('84359734a0c822c487019565d2c15f','1','80.133.*.*','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;','1016380059','/board/index.php?s=')
mysql error: Duplicate entry '84359734a0c822c487019565d2c15f' for key 1

mysql error number: 1062
the error showed up in den "admin" too, when I want to shut off the board...

...what could it be?

bevor this error the microstats where correctly displayed in my footer...

any suggestions?

THX!
Reply With Quote
  #158  
Old 26 Mar 2002, 08:02
TECK's Avatar
TECK TECK is offline
 
Join Date: Dec 2001
Real name: Floren Munteanu
Originally posted by JDD
for me it's the same, installed the latest version (on vB 2.2.4), and from time to time I get negative values:

Strange is that the timedisplay is positive but the percentage values are negative
it must be related to your server? i never get a negative value. the best example is vB.org site. firefly can back me up on this, because he had checked my code.
__________________
Floren Munteanu
Axivo Inc.
Axivo Community - Visit the forums to find out more about us
Why Queued - My personal blog
Reply With Quote
  #159  
Old 26 Mar 2002, 21:37
Kyomu Kyomu is offline
 
Join Date: Mar 2002
Originally posted by JDD
for me it's the same, installed the latest version (on vB 2.2.4), and from time to time I get negative values:

this is an result for my forum home page:


I am sure that I hacked the files correctly (checked it several times)

Strange is that the timedisplay is positive but the percentage values are negative

I put {getmicrostats} into the footer template

Greets
JDD
I get the same thing. I think it has to do with being in a shared environment.
Reply With Quote
  #160  
Old 26 Mar 2002, 23:22
TECK's Avatar
TECK TECK is offline
 
Join Date: Dec 2001
Real name: Floren Munteanu
Re: Just an addendum

Originally posted by Jawelin
I still obtain negative values (i.e. ending times smaller than starting times in db_mysql ... :surprised: :surprised: ) !!!!

For example, on DETAILS against my forumhome page...
i'm convinced is a server issue Jawelin. as you see, even in unhacked (details) mode you get negativs. i wish i could do something but i cant. you should contact your host. let me know what they said.. it might help others who have the same prob.
__________________
Floren Munteanu
Axivo Inc.
Axivo Community - Visit the forums to find out more about us
Why Queued - My personal blog
Reply With Quote
  #161  
Old 26 Mar 2002, 23:39
scotty's Avatar
scotty scotty is offline
 
Join Date: Oct 2001
anyone suggestions for my prob?
http://www.vbulletin.org/forum/showt...244#post230244
Reply With Quote
  #162  
Old 27 Mar 2002, 00:06
TECK's Avatar
TECK TECK is offline
 
Join Date: Dec 2001
Real name: Floren Munteanu
Originally posted by scotty
anyone suggestions for my prob?
http://www.vbulletin.org/forum/showt...244#post230244
sessionhash probs. check your hacks.
__________________
Floren Munteanu
Axivo Inc.
Axivo Community - Visit the forums to find out more about us
Why Queued - My personal blog
Reply With Quote
  #163  
Old 27 Mar 2002, 09:15
Jawelin Jawelin is offline
 
Join Date: Nov 2001
Re: Re: Just an addendum

Originally posted by nakkid
i'm convinced is a server issue Jawelin. as you see, even in unhacked (details) mode you get negativs. i wish i could do something but i cant. you should contact your host. let me know what they said.. it might help others who have the same prob.
Yes, sure. My server is quite strange (Linux shared...). Even - thanks to your enhanced hack version - I saw they somethimes turn off the gzip for no reason ... Bah!?!?

Instead I often get a negative value on the forumhome page, with about 35 queries. Some hacks installed, but even with the original index.php and templates, the query time has often strange values.
I asked my host people, but they said it's an 'application' issue cause they use a standard MySQL configuration...

Pragmatically, I would findout a simple way to re-scale strange values with a not-totally-random algorithm... :classic:
I though to 'sql time % 100', but it's too empiric....
Do you have any better idea ?

Thanks and welcome back. As you can see, Nakkid, your work became very popular... :squareeyed:

Bye
Reply With Quote
  #164  
Old 27 Mar 2002, 12:32
lowlight's Avatar
lowlight lowlight is offline
 
Join Date: Mar 2002
So what's a good stat to have?

Most of my pages are like this:

Page generated in 0.5019860 seconds (91.89% PHP - 8.11% MySQL) with 22 queries.

I guess it's good that MySQL isn't bogging down right?
Reply With Quote
  #165  
Old 27 Mar 2002, 12:58
TECK's Avatar
TECK TECK is offline
 
Join Date: Dec 2001
Real name: Floren Munteanu
looks good to me.. your stats are solid. not to many queries (very important for your server - keep it under 40)
__________________
Floren Munteanu
Axivo Inc.
Axivo Community - Visit the forums to find out more about us
Why Queued - My personal blog
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

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


New To Site? Need Help?

All times are GMT. The time now is 06:33.

Layout Options | Width: Wide Color: