Microstats (only for admin) - load times, server loads, queries, uncached templates!

Version 1.0 - works for most servers
Updated 1.1 - optimized code
Updated 1.2 - added names of uncached templates!

Okay, the original was by TECK. This is NOT based on his code - it is based on vB3's native code. If TECK wants me to remove this, I will do so. This is just my version that I use for my private forums.

Information shown:
1) Page loading times
2) Number of Queries
3) Server Loads
4) Number of Any Uncached Templates
5) Name of Uncached Templates (NEW!)

By default only an Admin (usergroup 6) can see it. Feel free to modify this bit.

It's very easy to install.

Open includes/functions.php:

Find:

PHP Code:

// ####################################################################
    // temporary code
    global $_TEMPLATEQUERIES, $tempusagecache, $DEVDEBUG, $_SERVER, $debug; 


UNDERNEATH, ADD:

Version 1.2 - more optimized but requires /proc on your server - try this, if server loads don't show up use Version 1.02 below

PHP Code:

// Microstats hack
if ($bbuserinfo[usergroupid]==6) {
                $pageendtime = microtime(); 
                $starttime = explode(' ', $pagestarttime); 
                $endtime = explode(' ', $pageendtime); 
                $totaltime = vb_number_format($endtime[0] - $starttime[0] + $endtime[1] - $starttime[1], 5); 
                $loadavg = @file_get_contents("/proc/loadavg"); 
                if ($loadavg) { 
                        $regs = explode(" ",$loadavg); 
                        $serverload=' [Server Loads: <b>'.$regs[0].'</b> '.$regs[1].' : '.$regs[2].']'; 
                } 
                $debughtml = "<center><span class=\"smallfont\">Page generated in <b>$totaltime</b> seconds with <b>$query_count</b> queries" . iif($_TEMPLATEQUERIES, " (<b>" . sizeof($_TEMPLATEQUERIES) . "</b> queries for uncached templates)", '') . "$serverload</span></center>"; 
    ksort($tempusagecache);
    foreach ($tempusagecache AS $tempname => $times)
    {
    if ($_TEMPLATEQUERIES["$tempname"]) $debughtml .= "<center><span class=\"smallfont\">Uncached templates: <font color=\"red\"><b>$tempname</b></font> ($times)</span></center>";
    }
                $vartext = str_replace('</body>', "$debughtml\n</body>", $vartext); 
 
}
//Microstats Hack 


Version 1.02 - Use this if Version 1.1 doesn't work for you.

PHP Code:

// Microstats hack 
if ($bbuserinfo[usergroupid]==6) {
$pageendtime = microtime(); 
$starttime = explode(' ', $pagestarttime); 
$endtime = explode(' ', $pageendtime); 
$totaltime = vb_number_format($endtime[0] - $starttime[0] + $endtime[1] - $starttime[1], 5); 
if ($stats=@exec('uptime')) { 
     preg_match('/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/',$stats,$regs); 
     $serverload=' [Server Loads: <b>'.$regs[1].'</b> ? '.$regs[2].' : '.$regs[3].']'; 
     } 
$debughtml = "<center><span class=\"smallfont\">Page generated in <b>$totaltime</b> seconds with <b>$query_count</b> queries" . iif($_TEMPLATEQUERIES, " (<b>" . sizeof($_TEMPLATEQUERIES) . "</b> queries for uncached templates)", '') . "$serverload</span>"; 
$vartext = str_replace('</body>', "$debughtml\n</body>", $vartext); 
    ksort($tempusagecache);
    foreach ($tempusagecache AS $tempname => $times)
    {
    if ($_TEMPLATEQUERIES["$tempname"]) $debughtml .= "<center><span class=\"smallfont\">Uncached templates: <font color=\"red\"><b>$tempname</b></font> ($times)</span></center>";
    }
}
//Microstats Hack 


Done! As simple as that. No need to enable debug mode.

If you want only yourself to have this information, change:
if ($bbuserinfo[usergroupid]==6) {
to
if ($bbuserinfo[userid]==1) {

And replace 1 with your userid.

To let everyone see it, remove that line, and the last } of the code above.

Below is a screenshot of how my forumhome microstats look.

EDIT: Thanks to kmike, I optimized the code. This should lessen the load when checking the server loads slightly.

Version 1.2 and 1.02 now has added code to show NAMES OF UNCACHED TEMPLATES!

[Littlebit]

Originally Posted by Erwin

Yes.

thank you Erwin for this, I'm installing :classic:

[Ted S]

For some reason on one of my styles the data line appears twice (identical valeus), other styles load about as quick with the same query count but only show the results once, is this anything to worry about?

[lifesourcerec]

Originally Posted by Erwin

It has to be at the bottom because it has to read everything that gets parsed out first to get the correct time and number of queries. You could use a float tag to float it elsewhere I suppose.

Mine list at the top and bottom. How can I get rid of that?

[Erwin]

The data line is based on the </body> tag which should be the last tag before </html> - so if your templates have multiple </body> tags (which is bad coding) then you will get more than 1 occurrence of the info.

[BamaTech]

nice was looking for this

thanks for the effort and the share

[dwh]

I'm fooling around with some hacks on a test server that have lots of queries. Thanks Erwin for helping me determine just how many with this hack (not to mention uncached templates).

I've put them into a HEAP table so that they lessen the load. Do you think a query to a HEAP table is even worth counting? Can it get me in trouble with high load on a production board?

[Torqued]

I installed 1.2 and it gave me the names of the uncached templates, but not server load..

So I installed 1.02 and it gives me server load and the # of uncached templates, but not the names..

should 1.02 be showing me the names as well?

I am on v3.03

[Erwin]

Originally Posted by Torqued

I installed 1.2 and it gave me the names of the uncached templates, but not server load..

So I installed 1.02 and it gives me server load and the # of uncached templates, but not the names..

should 1.02 be showing me the names as well?

I am on v3.03

Weird, both should show server loads and uncached template names.

[Torqued]

Originally Posted by Erwin

Weird, both should show server loads and uncached template names.

That's what I thought. I just doublechecked and reinstalled the 1.02 code and am not getting the uncached template names.

Any ideas?

[Torqued]

Ok. I fixed it... don't know why it works, but it does! LOL

I took the code @ the bottom of 1.2 for evaluating/displaying uncached templates and put that code in the same spot in 1.02 and it works!

Now how is it that I fix uncached templates? I'm running vBAdvanced CMPS 1.0.0 and vBLinks 1.0.0. The two uncached templates are related to the links directory.