Documentation TYPO3 par Ameos |
Public Member Functions | |
| perf_informix (&$conn) | |
Public Attributes | |
| $createTableSQL | |
| $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" | |
| $settings | |
Definition at line 22 of file perf-informix.inc.php.
| perf_informix::$createTableSQL |
Initial value:
"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 )"
Reimplemented from adodb_perf.
Definition at line 26 of file perf-informix.inc.php.
| perf_informix::$settings |
Initial value:
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
)
Definition at line 37 of file perf-informix.inc.php.
1.4.6