$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
)"
$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)
