perf_informix Class Reference

Inheritance diagram for perf_informix:

Collaboration diagram for perf_informix:

Public Member Functions
	perf_informix (&$conn)
Data Fields
	$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

---

Detailed Description

Definition at line 22 of file perf-informix.inc.php.

---

Member Function Documentation

perf_informix

(

&$

conn

)

Definition at line 64 of file perf-informix.inc.php.

---

Field Documentation

$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.

$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.

$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"

Reimplemented from adodb_perf.

Definition at line 35 of file perf-informix.inc.php.

---

The documentation for this class was generated from the following file:

• C:/xampp/htdocs/moodle/lib/adodb/perf/perf-informix.inc.php