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:

Inheritance graph
[legend]
Collaboration diagram for perf_mysql:

Collaboration graph
[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:

Généré par Le spécialiste TYPO3 avec  doxygen 1.4.6