perf_mysql Class Reference

Inheritance diagram for perf_mysql:

List of all members.

Public Member Functions
	perf_mysql (&$conn)
	Explain ($sql, $partial=false)
	Tables ()
	GetReads ()
	GetWrites ()
	FindDBHitRatio ()
	GetQHitRatio ()
	GetInnoDBHitRatio ()
	GetKeyHitRatio ()
	optimizeTable ($table, $mode=ADODB_OPT_LOW)
Public Attributes
	$tablesSQL = 'show table status'
	$createTableSQL
	$settings
	$optimizeTableLow = 'CHECK TABLE %s FAST QUICK'
	$optimizeTableHigh = 'OPTIMIZE TABLE %s'

---

Detailed Description

Definition at line 18 of file perf-mysql.inc.php.

---

Constructor & Destructor Documentation

perf_mysql.perf_mysql (  &$  conn  )

Definition at line 84 of file perf-mysql.inc.php.

---

Member Function Documentation

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

Reimplemented from adodb_perf. Definition at line 89 of file perf-mysql.inc.php.

perf_mysql.FindDBHitRatio (   )

Definition at line 192 of file perf-mysql.inc.php.

perf_mysql.GetInnoDBHitRatio (   )

Definition at line 246 of file perf-mysql.inc.php.

perf_mysql.GetKeyHitRatio (   )

Definition at line 275 of file perf-mysql.inc.php.

perf_mysql.GetQHitRatio (   )

Definition at line 222 of file perf-mysql.inc.php.

perf_mysql.GetReads (   )

Definition at line 130 of file perf-mysql.inc.php.

perf_mysql.GetWrites (   )

Definition at line 159 of file perf-mysql.inc.php.

perf_mysql.optimizeTable (  $  table, $  mode = ADODB_OPT_LOW )

See also: adodb_perf.optimizeTable Definition at line 291 of file perf-mysql.inc.php.

perf_mysql.Tables (   )

Definition at line 119 of file perf-mysql.inc.php.

---

Member Data Documentation

perf_mysql.$createTableSQL

Initial value: "CREATE TABLE adodb_logsql ( created datetime NOT NULL, sql0 varchar(250) NOT NULL, sql1 text NOT NULL, params text NOT NULL, tracer text NOT NULL, timer decimal(16,6) NOT NULL )" Reimplemented from adodb_perf. Definition at line 22 of file perf-mysql.inc.php.

perf_mysql.$optimizeTableHigh = 'OPTIMIZE TABLE %s'

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

perf_mysql.$optimizeTableLow = 'CHECK TABLE %s FAST QUICK'

Definition at line 285 of file perf-mysql.inc.php.

perf_mysql.$settings

Definition at line 31 of file perf-mysql.inc.php.

perf_mysql.$tablesSQL = 'show table status'

Reimplemented from adodb_perf. Definition at line 20 of file perf-mysql.inc.php.

---

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

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

---