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

perf_mysql Class Reference

Inheritance diagram for perf_mysql:[legend]Collaboration diagram for perf_mysql:[legend]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.

---

Member Function Documentation

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

See also:

adodb_perf::optimizeTable

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

References adodb_perf::$conn, adodb_perf::$table, and ADOConnection::outp().

---

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.

---

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

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

---