Inheritance diagram for adodb_perf:

Public Member Functions
	_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 ()
Static Public Member Functions
static	table ($newtable=false)
Data Fields
	$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

Detailed Description

Definition at line 217 of file adodb-perf.inc.php.

Member Function Documentation

_CPULoad ( )

Definition at line 242 of file adodb-perf.inc.php.

Here is the caller graph for this function:

_DBParameter ( $ sql )

Definition at line 605 of file adodb-perf.inc.php.

Here is the caller graph for this function:

_ExpensiveSQL ( $ numsql = 10 )

Definition at line 524 of file adodb-perf.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

_SuspiciousSQL ( $ numsql = 10 )

Definition at line 445 of file adodb-perf.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

CheckMemory ( )

Definition at line 502 of file adodb-perf.inc.php.

Here is the caller graph for this function:

clearsql ( )

Definition at line 663 of file adodb-perf.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

CPULoad ( )

Definition at line 352 of file adodb-perf.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

CreateLogTable ( )

Definition at line 903 of file adodb-perf.inc.php.

Here is the call graph for this function:

DBParameter ( $ param )

Definition at line 583 of file adodb-perf.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

DoSQLForm ( )

Definition at line 915 of file adodb-perf.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

ExpensiveSQL ( $ numsql = 10 )

Definition at line 513 of file adodb-perf.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

Explain	(	$	sql,
		$	partial = `false`
	)

Reimplemented in perf_postgres, perf_mysql, perf_mssql, perf_mssqlnative, and perf_db2.

Definition at line 418 of file adodb-perf.inc.php.

HealthCheck ( $ cli = false )

Reimplemented in perf_mssql, and perf_mssqlnative.

Definition at line 822 of file adodb-perf.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

HealthCheckCLI ( )

Definition at line 813 of file adodb-perf.inc.php.

Here is the call graph for this function:

InvalidSQL ( $ numsql = 10 )

Definition at line 423 of file adodb-perf.inc.php.

Here is the call graph for this function:

Here is the caller graph for this function:

MemInfo ( )

Definition at line 320 of file adodb-perf.inc.php.

optimizeDatabase ( )

Reorganise current database. Default implementation loops over all MetaTables() and optimize each using optmizeTable()

Author:: Markus Staab

Returns:: Returns true on success and false on error

Definition at line 1080 of file adodb-perf.inc.php.

OptimizeTable	(	$	table,
		$	mode = `ADODB_OPT_LOW`
	)

Reorganise the table-indices/statistics/.. depending on the given mode. Default Implementation throws an error.

Parameters:

string	table name of the table to optimize
int	mode optimization-mode `ADODB_OPT_HIGH` for full optimization `ADODB_OPT_LOW` for CPU-less optimization Default is LOW `ADODB_OPT_LOW`