Documentation TYPO3 par Ameos

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:


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