Inheritance diagram for adodb_perf:

Public Member Functions
	_CPULoad ()

	_DBParameter ($sql)

	_ExpensiveSQL ($numsql=10)

	_SuspiciousSQL ($numsql=10)

	CheckMemory ()

	clearsql ()

	CPULoad ()

	CreateLogTable ()

	DBParameter ($param)

	DoSQLForm ()

	ExpensiveSQL ($numsql=10)

	Explain ($sql, $partial=false)

	HealthCheck ($cli=false)

	HealthCheckCLI ()

	InvalidSQL ($numsql=10)

	MemInfo ()

	optimizeDatabase ()
	Reorganise current database.

	OptimizeTable ( $table, $mode=ADODB_OPT_LOW)
	Reorganise the table-indices/statistics/.

	OptimizeTables ()

	Poll ($secs=5)

	PollParameters ()

	SplitSQL ($sql)

	SuspiciousSQL ($numsql=10)

	Tables ($orderby='1')

	Tracer ($sql)

	UI ($pollsecs=5)

	WarnCacheRatio ($val)

Static Public Member Functions
static	table ($newtable=false)

Public Attributes
	$_lastLoad

	$cliFormat = "%32s => %s r\n"

	$color = '#F0F0F0'

	$conn

	$createTableSQL = false

	$explain = true

	$helpurl = '<a href="https://adodb.org/dokuwiki/doku.php?id=v5:performance:logsql">LogSQL help</a>'

	$maxLength = 2000

array	$settings = []
	Settings data.

	$sql1 = 'sql1'

	$table = '<table border=1 bgcolor=white>'

	$tablesSQL = false

	$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'

	$warnRatio = 90

Detailed Description

Examples: /home/runner/work/phpdoc/phpdoc/.moodle/lib/adodb/adodb-perf.inc.php.

Member Function Documentation

adodb_perf::optimizeDatabase ( )

Reorganise current database.

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

Return values

bool	true on success, false on error

Examples: /home/runner/work/phpdoc/phpdoc/.moodle/lib/adodb/adodb-perf.inc.php.

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`

Return values

bool	true on success, false on error

Examples: /home/runner/work/phpdoc/phpdoc/.moodle/lib/adodb/adodb-perf.inc.php.

adodb_perf::Tables ( $orderby = '1' )

Reimplemented in perf_db2.

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