adodb_perf Class Reference

Inheritance diagram for adodb_perf:

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 202 of file adodb-perf.inc.php.

---

Member Function Documentation

adodb_perf._CPULoad (   )

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

adodb_perf._DBParameter (  $  sql  )

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

adodb_perf._ExpensiveSQL (  $  numsql = 10  )

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

adodb_perf._SuspiciousSQL (  $  numsql = 10  )

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

adodb_perf.CheckMemory (   )

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

adodb_perf.CPULoad (   )

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

adodb_perf.CreateLogTable (   )

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

adodb_perf.DBParameter (  $  param  )

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

adodb_perf.DoSQLForm (   )

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

adodb_perf.ExpensiveSQL (  $  numsql = 10  )

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

adodb_perf.Explain (  $  sql, $  partial = false )

Reimplemented in perf_db2, perf_mssql, perf_mysql, and perf_postgres. Definition at line 385 of file adodb-perf.inc.php.

adodb_perf.HealthCheck (  $  cli = false  )

Reimplemented in perf_mssql. Definition at line 778 of file adodb-perf.inc.php.

adodb_perf.HealthCheckCLI (   )

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

adodb_perf.InvalidSQL (  $  numsql = 10  )

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

adodb_perf.MemInfo (   )

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

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 1034 of file 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 Author: Markus Staab Returns: Returns true on success and false on error Definition at line 1020 of file adodb-perf.inc.php.

adodb_perf.OptimizeTables (   )

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

adodb_perf.Poll (  $  secs = 5  )

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

& adodb_perf.PollParameters (   )

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

adodb_perf.SplitSQL (  $  sql  )

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

adodb_perf.SuspiciousSQL (  $  numsql = 10  )

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

adodb_perf.table (  $  newtable = false  )

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

adodb_perf.Tables (  $  orderby = '1'  )

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

adodb_perf.Tracer (  $  sql  )

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

adodb_perf.UI (  $  pollsecs = 5  )

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

adodb_perf.undomq (  $  m  )

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

adodb_perf.WarnCacheRatio (  $  val  )

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

---

Member Data Documentation

adodb_perf.$_lastLoad

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

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

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

adodb_perf.$color = '#F0F0F0'

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

adodb_perf.$conn

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

adodb_perf.$createTableSQL = false

Reimplemented in perf_db2, perf_informix, perf_mssql, perf_mysql, and perf_postgres. Definition at line 213 of file adodb-perf.inc.php.

adodb_perf.$explain = true

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

adodb_perf.$helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"

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

adodb_perf.$maxLength = 2000

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

adodb_perf.$sql1 = 'sql1'

Reimplemented in perf_mssql. Definition at line 210 of file adodb-perf.inc.php.

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

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

adodb_perf.$tablesSQL = false

Reimplemented in perf_informix, perf_mysql, and perf_postgres. Definition at line 208 of file adodb-perf.inc.php.

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

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

adodb_perf.$warnRatio = 90

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

---

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

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

---