Docs For Class perf

Description

Located in /adodb5/perf/perf-mysql.inc.php (line 18)

adodb_perf
   |
   --perf_mysql

Variable Summary

mixed $createTableSQL

mixed $optimizeTableHigh

mixed $optimizeTableLow

mixed $settings

mixed $tablesSQL

Method Summary

perf_mysql perf_mysql ( &$conn)

void Explain ( $sql, [ $partial = false])

void FindDBHitRatio ()

void GetInnoDBHitRatio ()

void GetKeyHitRatio ()

void GetQHitRatio ()

void GetReads ()

void GetWrites ()

void optimizeTable ( $table, [ $mode = ADODB_OPT_LOW])

void Tables ()

Variables

mixed $createTableSQL = "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
)" (line 22)

mixed $optimizeTableHigh = 'OPTIMIZE TABLE %s' (line 286)

mixed $optimizeTableLow = 'CHECK TABLE %s FAST QUICK' (line 285)

mixed $settings = array(
'Ratios',
'MyISAM cache hit ratio' => array('RATIO',
'=GetKeyHitRatio',
'=WarnCacheRatio'),'InnoDB cache hit ratio'=>array('RATIO','=GetInnoDBHitRatio','=WarnCacheRatio'),'data cache hit ratio'=>array('HIDE',# only if called
'=FindDBHitRatio','=WarnCacheRatio'),'sql cache hit ratio'=>array('RATIO','=GetQHitRatio',''),'IO','data reads'=>array('IO','=GetReads','Number of selects (Key_reads is not accurate)'),'data writes'=>array('IO','=GetWrites','Number of inserts/updates/deletes * coef (Key_writes is not accurate)'),'Data Cache','MyISAM data cache size'=>array('DATAC',array("show variables",'key_buffer_size'),''),'BDB data cache size'=>array('DATAC',array("show variables",'bdb_cache_size'),''),'InnoDB data cache size'=>array('DATAC',array("show variables",'innodb_buffer_pool_size'),''),'Memory Usage','read buffer size'=>array('CACHE',array("show variables",'read_buffer_size'),'(per session)'),'sort buffer size'=>array('CACHE',array("show variables",'sort_buffer_size'),'Size of sort buffer (per session)'),'table cache'=>array('CACHE',array("show variables",'table_cache'),'Number of tables to keep open'),'Connections','current connections'=>array('SESS',array('show status','Threads_connected'),''),'max connections'=>array('SESS',array("show variables",'max_connections'),''),false) (line 31)

mixed $tablesSQL = 'show table status' (line 20)

Methods

Constructor perf_mysql (line 84)

perf_mysql perf_mysql ( &$conn)

&$conn

Explain (line 89)

void Explain ( $sql, [ $partial = false])

$sql
$partial

FindDBHitRatio (line 192)

void FindDBHitRatio ()

GetInnoDBHitRatio (line 246)

void GetInnoDBHitRatio ()

GetKeyHitRatio (line 275)

void GetKeyHitRatio ()

GetQHitRatio (line 222)

void GetQHitRatio ()

GetReads (line 130)

void GetReads ()

GetWrites (line 159)

void GetWrites ()

optimizeTable (line 291)

see: optimizeTable

void optimizeTable ( $table, [ $mode = ADODB_OPT_LOW])

$table
$mode

Tables (line 119)

void Tables ()

Class perf_mysql