Documentation TYPO3 par Ameos

perf_informix Class Reference

Inheritance diagram for perf_informix:
[legend]
Collaboration diagram for perf_informix:
[legend]
List of all members.

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

Detailed Description

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


Member Data Documentation

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.


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


Généré par L'expert TYPO3 avec  doxygen 1.4.6