API Documentation
\

\perf_informix

Summary

Methods
Properties
Constants
table()
_CPULoad()
MemInfo()
CPULoad()
Tracer()
Explain()
InvalidSQL()
_SuspiciousSQL()
CheckMemory()
SuspiciousSQL()
ExpensiveSQL()
_ExpensiveSQL()
DBParameter()
PollParameters()
_DBParameter()
WarnCacheRatio()
clearsql()
UI()
Poll()
HealthCheckCLI()
HealthCheck()
Tables()
CreateLogTable()
DoSQLForm()
SplitSQL()
undomq()
OptimizeTables()
OptimizeTable()
optimizeDatabase()
perf_informix()
$conn
$color
$table
$titles
$warnRatio
$tablesSQL
$cliFormat
$sql1
$explain
$helpurl
$createTableSQL
$maxLength
$_lastLoad
$settings
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
No private properties found
N/A

Properties

$conn

$conn :

Type

$color

$color :

Type

$table

$table :

Type

$titles

$titles :

Type

$warnRatio

$warnRatio :

Type

$tablesSQL

$tablesSQL :

Type

$cliFormat

$cliFormat :

Type

$sql1

$sql1 :

Type

$explain

$explain :

Type

$helpurl

$helpurl :

Type

$createTableSQL

$createTableSQL :

Type

$maxLength

$maxLength :

Type

$_lastLoad

$_lastLoad :

Type

$settings

$settings :

Type

Methods

table()

table(  $newtable = false)

Parameters

$newtable

_CPULoad()

_CPULoad()

MemInfo()

MemInfo()

CPULoad()

CPULoad()

Tracer()

Tracer(  $sql)

Parameters

$sql

Explain()

Explain(  $sql,   $partial = false)

Parameters

$sql
$partial

InvalidSQL()

InvalidSQL(  $numsql = 10)

Parameters

$numsql

_SuspiciousSQL()

_SuspiciousSQL(  $numsql = 10)

Parameters

$numsql

CheckMemory()

CheckMemory()

SuspiciousSQL()

SuspiciousSQL(  $numsql = 10)

Parameters

$numsql

ExpensiveSQL()

ExpensiveSQL(  $numsql = 10)

Parameters

$numsql

_ExpensiveSQL()

_ExpensiveSQL(  $numsql = 10)

Parameters

$numsql

DBParameter()

DBParameter(  $param)

Parameters

$param

PollParameters()

PollParameters()

_DBParameter()

_DBParameter(  $sql)

Parameters

$sql

WarnCacheRatio()

WarnCacheRatio(  $val)

Parameters

$val

clearsql()

clearsql()

UI()

UI(  $pollsecs = 5)

Parameters

$pollsecs

Poll()

Poll(  $secs = 5)

Parameters

$secs

HealthCheckCLI()

HealthCheckCLI()

HealthCheck()

HealthCheck(  $cli = false)

Parameters

$cli

Tables()

Tables(  $orderby = '1')

Parameters

$orderby

CreateLogTable()

CreateLogTable()

DoSQLForm()

DoSQLForm()

SplitSQL()

SplitSQL(  $sql)

Parameters

$sql

undomq()

undomq(  $m)

Parameters

$m

OptimizeTables()

OptimizeTables() : \Returns

Reorganise multiple table-indices/statistics/.

. OptimizeMode could be given by last Parameter

Returns

\Returns —

true on success and false on error

Examples

optimizeTables( 'tableA'); </pre> <pre> optimizeTables( 'tableA', 'tableB', 'tableC'); </pre> <pre> optimizeTables( 'tableA', 'tableB', ADODB_OPT_LOW); </pre>
** File not found : <pre> **

OptimizeTable()

OptimizeTable(  $table,   $mode = ADODB_OPT_LOW) : \Returns

Reorganise the table-indices/statistics/.

. depending on the given mode. Default Implementation throws an error.

Parameters

$table
$mode

Returns

\Returns —

true on success and false on error

optimizeDatabase()

optimizeDatabase() : \Returns

Reorganise current database.

Default implementation loops over all MetaTables() and optimize each using optmizeTable()

Returns

\Returns —

true on success and false on error

perf_informix()

perf_informix(  $conn)

Parameters

$conn