perf_informix Class Reference

Inheritance diagram for perf_informix:

Public Member Functions
	perf_informix (&$conn)
Public Member Functions inherited from adodb_perf
	_CPULoad ()
	MemInfo ()
	CPULoad ()
	Tracer ($sql)
	Explain ($sql, $partial=false)
	InvalidSQL ($numsql=10)
	_SuspiciousSQL ($numsql=10)
	CheckMemory ()
	SuspiciousSQL ($numsql=10)
	ExpensiveSQL ($numsql=10)
	_ExpensiveSQL ($numsql=10)
	DBParameter ($param)
	PollParameters ()
	_DBParameter ($sql)
	WarnCacheRatio ($val)
	clearsql ()
	UI ($pollsecs=5)
	Poll ($secs=5)
	HealthCheckCLI ()
	HealthCheck ($cli=false)
	Tables ($orderby='1')
	CreateLogTable ()
	DoSQLForm ()
	SplitSQL ($sql)
	undomq ($m)
	OptimizeTables ()
	OptimizeTable ( $table, $mode=ADODB_OPT_LOW)
	optimizeDatabase ()

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
Public Attributes inherited from adodb_perf
	$conn
	$color = '#F0F0F0'
	$table = '<table border=1 bgcolor=white>'
	$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'
	$warnRatio = 90
	$tablesSQL = false
	$cliFormat = "%32s => %s \r\n"
	$sql1 = 'sql1'
	$explain = true
	$helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"
	$createTableSQL = false
	$maxLength = 2000
	$_lastLoad

Additional Inherited Members
Static Public Member Functions inherited from adodb_perf
static	table ($newtable=false)

Detailed Description

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

Member Function Documentation

perf_informix()

perf_informix::perf_informix

(

&

$conn

)

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

References adodb_perf\$conn.

Member Data Documentation

$createTableSQL

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

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

$settings

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.

$tablesSQL

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

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