Documentation TYPO3 par Ameos

Disponible dans d'autres versions de TYPO3 -> 3.7.0  3.8.1  4.0.0  4.0.1  4.1.0   <- Available in other TYPO3 versions

adodb_perf Class Reference

Inheritance diagram for adodb_perf:[legend]List of all members.

Public Member Functions
	table ($newtable=false)
	_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)
	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
	$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 215 of file adodb-perf.inc.php.

---

Member Function Documentation

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

Author:

Markus Staab

Returns:

Returns true on success and false on error

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

References ADOConnection::outp().

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

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

References $conn, and $table.

---

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

• typo3_src-4.1/typo3/sysext/adodb/adodb/adodb-perf.inc.php

---