ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:performance:healthcheck

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
Last revisionBoth sides next revision
performance:healthcheck [2015/08/23 16:48] – created mnewnhamv5:performance:healthcheck [2017/05/17 18:46] – [Description] mnewnham
Line 6: Line 6:
 </WRAP> </WRAP>
 ===== Description ===== ===== 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 [[reference:healthcheckcli|healthCheckcli()]].+The method ''healthCheck()'' executes a single database health check pass and writes the information to an html format table. The output provided is the same as that returned by [[v5:performance:healthcheckcli|healthCheckcli()]]
 + 
 +There is no consistency between databases as to the information returned, as it is dependent on what information is publicly exposed by the database.
 ===== Usage ===== ===== Usage =====
 <code php> <code php>
Line 29: Line 31:
 The following HTML is returned: The following HTML is returned:
  
-<html> +{{v5:performance:performance-healthcheck.png|Performance Health Check Screen}} 
-<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.txt · Last modified: 2017/05/17 18:48 by mnewnham