ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:performance:healthcheck

This is an old revision of the document!


healthCheck

Syntax
mixed healthCheck()

Description

The function healthCheckCli executes a single database health check pass and writes the information to an html format table. A valid performance monitoring The output provided is the same as that returns by healthCheckcli().

Usage

/*
* Connection to DB2 database
*/
 
$perf = newPerfMonitor($db);
echo $perf->healthCheckCli();
/*
  -- Ratios --  
            data cache hit ratio => 0
  -- Data Cache --
              data cache buffers => 1000
                 cache blocksize => 8192
                 data cache size => 8000K
  -- Connections --
             current connections => 7
*/

The following HTML is returned:

<html> <table border=1 bgcolor=white><tr><td colspan=3><h3>db2</h3></td></tr><tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr><tr bgcolor=#F0F0F0><td colspan=3><i>Ratios</i> &nbsp;</td></tr><tr><td>data cache hit ratio</td><td>0</td><td><font color=red><b>Cache ratio should be at least 90%</b></font></td></tr> <tr bgcolor=#F0F0F0><td colspan=3><i>Data Cache</i> &nbsp;</td></tr><tr><td>data cache buffers</td><td>1000</td><td>See <a href=http://www7b.boulder.ibm.com/dmdd/library/techarticle/anshum/0107anshum.html#bufferpoolsize>tuning reference</a>.</td></tr> <tr><td>cache blocksize</td><td>8192</td><td>&nbsp;</td></tr> <tr><td>data cache size</td><td>8000K</td><td>&nbsp;</td></tr> <tr bgcolor=#F0F0F0><td colspan=3><i>Connections</i> &nbsp;</td></tr><tr><td>current connections</td><td>7</td><td>&nbsp;</td></tr> </table> </html>

v5/performance/healthcheck.1440341289.txt.gz · Last modified: 2017/04/21 11:30 (external edit)