Class perf_informix
Description
Located in /adodb5/perf/perf-informix.inc.php (line 22)
adodb_perf | --perf_informix
Variable Summary
Method Summary
Variables
mixed
$createTableSQL
= "CREATE TABLE adodb_logsql (
created datetime year to second NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 varchar(255) NOT NULL,
params varchar(255) NOT NULL,
tracer varchar(255) NOT NULL,
timer decimal(16,6) NOT NULL
)" (line 26)
created datetime year to second NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 varchar(255) NOT NULL,
params varchar(255) NOT NULL,
tracer varchar(255) NOT NULL,
timer decimal(16,6) NOT NULL
)" (line 26)
mixed
$settings
= array(
'Ratios',
'data cache hit ratio' => array('RATIOH',
"select round((1-(wt.value / (rd.value + wr.value)))*100,2)
from sysmaster:sysprofile wr, sysmaster:sysprofile rd, sysmaster:sysprofile wt
where rd.name = 'pagreads' and
wr.name = 'pagwrites' and
wt.name = 'buffwts'",
'=WarnCacheRatio'),'IO','data reads'=>array('IO',"select value from sysmaster:sysprofile where name='pagreads'",'Page reads'),'data writes'=>array('IO',"select value from sysmaster:sysprofile where name='pagwrites'",'Page writes'),'Connections','current connections'=>array('SESS','select count(*) from sysmaster:syssessions','Number of sessions'),false) (line 37)
'Ratios',
'data cache hit ratio' => array('RATIOH',
"select round((1-(wt.value / (rd.value + wr.value)))*100,2)
from sysmaster:sysprofile wr, sysmaster:sysprofile rd, sysmaster:sysprofile wt
where rd.name = 'pagreads' and
wr.name = 'pagwrites' and
wt.name = 'buffwts'",
'=WarnCacheRatio'),'IO','data reads'=>array('IO',"select value from sysmaster:sysprofile where name='pagreads'",'Page reads'),'data writes'=>array('IO',"select value from sysmaster:sysprofile where name='pagwrites'",'Page writes'),'Connections','current connections'=>array('SESS','select count(*) from sysmaster:syssessions','Number of sessions'),false) (line 37)
mixed
$tablesSQL
= "select a.tabname tablename, ti_nptotal*2 size_in_k, ti_nextns extents, ti_nrows records from systables c, sysmaster:systabnames a, sysmaster:systabinfo b where c.tabname not matches 'sys*' and c.partnum = a.partnum and c.partnum = b.ti_partnum" (line 35)
Methods
Documentation generated on Sun, 09 Mar 2008 23:52:44 -0300 by phpDocumentor 1.4.0
