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)

Public Attributes
	$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

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

Member Function Documentation

◆ _CPULoad()

adodb_perf::_CPULoad ( )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

Referenced by CPULoad().

◆ _DBParameter()

adodb_perf::_DBParameter ( $sql )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $rs, and $sql.

Referenced by DBParameter(), perf_mysql\GetKeyHitRatio(), perf_mysql\GetQHitRatio(), and HealthCheck().

◆ _ExpensiveSQL()

adodb_perf::_ExpensiveSQL ( $numsql = 10 )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $maxLength, $rs, $sql, $sql1, and table().

Referenced by ExpensiveSQL().

◆ _SuspiciousSQL()

adodb_perf::_SuspiciousSQL ( $numsql = 10 )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $maxLength, $rs, $sql, $sql1, and table().

Referenced by SuspiciousSQL().

◆ CheckMemory()

adodb_perf::CheckMemory ( )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

Referenced by UI().

◆ clearsql()

adodb_perf::clearsql ( )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References table().

Referenced by UI().

◆ CPULoad()

adodb_perf::CPULoad ( )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $_lastLoad, and _CPULoad().

Referenced by Poll().

◆ CreateLogTable()

adodb_perf::CreateLogTable ( )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $sql, and table().

◆ DBParameter()

adodb_perf::DBParameter ( $param )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $sql, and _DBParameter().

Referenced by perf_mysql\FindDBHitRatio(), and PollParameters().

◆ DoSQLForm()

adodb_perf::DoSQLForm ( )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $rs, $sql, rs2html(), SplitSQL(), table(), and undomq().

Referenced by UI().

◆ ExpensiveSQL()

adodb_perf::ExpensiveSQL ( $numsql = 10 )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References _ExpensiveSQL().

Referenced by UI().

◆ Explain()

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

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

◆ HealthCheck()

adodb_perf::HealthCheck ( $cli = false )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $titles, _DBParameter(), and table().

Referenced by perf_mssql\HealthCheck(), perf_mssqlnative\HealthCheck(), HealthCheckCLI(), and UI().

◆ HealthCheckCLI()

adodb_perf::HealthCheckCLI ( )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References HealthCheck().

◆ InvalidSQL()

adodb_perf::InvalidSQL ( $numsql = 10 )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $rs, rs2html(), and table().

Referenced by UI().

◆ MemInfo()

adodb_perf::MemInfo ( )

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

◆ optimizeDatabase()

adodb_perf::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

Examples:: /mnt/app/typo3/sysext/adodb/adodb/adodb-perf.inc.php.

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

References $conn.

◆ OptimizeTable()

adodb_perf::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`