"TYPO3 4.0.1: perf_mysql Class Reference", "datetime" => "Sat Dec 2 19:25:21 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

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: