perf_mysql Class Reference

Inheritance diagram for perf_mysql:

Public Member Functions
	perf_mysql (&$conn)
	Explain ($sql, $partial=false)
	Tables ()
	GetReads ()
	GetWrites ()
	FindDBHitRatio ()
	GetQHitRatio ()
	GetInnoDBHitRatio ()
	GetKeyHitRatio ()
	optimizeTable ( $table, $mode=ADODB_OPT_LOW)
Public Member Functions inherited from adodb_perf
	_CPULoad ()
	MemInfo ()
	CPULoad ()
	Tracer ($sql)
	Explain ($sql, $partial=false)
	InvalidSQL ($numsql=10)
	_SuspiciousSQL ($numsql=10)
	CheckMemory ()
	SuspiciousSQL ($numsql=10)
	ExpensiveSQL ($numsql=10)
	_ExpensiveSQL ($numsql=10)
	DBParameter ($param)
	PollParameters ()
	_DBParameter ($sql)
	WarnCacheRatio ($val)
	clearsql ()
	UI ($pollsecs=5)
	Poll ($secs=5)
	HealthCheckCLI ()
	HealthCheck ($cli=false)
	Tables ($orderby='1')
	CreateLogTable ()
	DoSQLForm ()
	SplitSQL ($sql)
	undomq ($m)
	OptimizeTables ()
	OptimizeTable ( $table, $mode=ADODB_OPT_LOW)
	optimizeDatabase ()

Public Attributes
	$tablesSQL = 'show table status'
	$createTableSQL
	$settings
	$optimizeTableLow = 'CHECK TABLE %s FAST QUICK'
	$optimizeTableHigh = 'OPTIMIZE TABLE %s'
Public Attributes inherited from adodb_perf
	$conn
	$color = '#F0F0F0'
	$table = '<table border=1 bgcolor=white>'
	$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'
	$warnRatio = 90
	$tablesSQL = false
	$cliFormat = "%32s => %s \r\n"
	$sql1 = 'sql1'
	$explain = true
	$helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"
	$createTableSQL = false
	$maxLength = 2000
	$_lastLoad

Additional Inherited Members
Static Public Member Functions inherited from adodb_perf
static	table ($newtable=false)

Detailed Description

Definition at line 18 of file perf-mysql.inc.php.

Member Function Documentation

Explain()

perf_mysql::Explain	(		$sql,
			$partial = false
	)

Definition at line 89 of file perf-mysql.inc.php.

References $rs, $sql, rs2html(), and adodb_perf\Tracer().

FindDBHitRatio()

perf_mysql::FindDBHitRatio

(

)

Definition at line 192 of file perf-mysql.inc.php.

References $rs, and adodb_perf\DBParameter().

GetInnoDBHitRatio()

perf_mysql::GetInnoDBHitRatio

(

)

Definition at line 246 of file perf-mysql.inc.php.

References $rs.

GetKeyHitRatio()

perf_mysql::GetKeyHitRatio

(

)

Definition at line 275 of file perf-mysql.inc.php.

References adodb_perf\_DBParameter().

GetQHitRatio()

perf_mysql::GetQHitRatio

(

)

Definition at line 222 of file perf-mysql.inc.php.

References adodb_perf\_DBParameter().

GetReads()

perf_mysql::GetReads

(

)

Definition at line 130 of file perf-mysql.inc.php.

References $rs.

GetWrites()

perf_mysql::GetWrites

(

)

Definition at line 159 of file perf-mysql.inc.php.

References $rs.

optimizeTable()

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, $optimizeTableHigh, $optimizeTableLow, $sql, adodb_perf\$table, ADODB_OPT_HIGH, and ADODB_OPT_LOW.

perf_mysql()

perf_mysql::perf_mysql

(

&

$conn

)

Definition at line 84 of file perf-mysql.inc.php.

References adodb_perf\$conn.

Tables()

perf_mysql::Tables

(

)

Definition at line 119 of file perf-mysql.inc.php.

References $rs, and rs2html().

Member Data Documentation

$createTableSQL

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

Definition at line 22 of file perf-mysql.inc.php.

$optimizeTableHigh

perf_mysql::$optimizeTableHigh = 'OPTIMIZE TABLE %s'

Definition at line 286 of file perf-mysql.inc.php.

Referenced by optimizeTable().

$optimizeTableLow

perf_mysql::$optimizeTableLow = 'CHECK TABLE %s FAST QUICK'

Definition at line 285 of file perf-mysql.inc.php.

Referenced by optimizeTable().

$settings

perf_mysql::$settings

Definition at line 31 of file perf-mysql.inc.php.

$tablesSQL

perf_mysql::$tablesSQL = 'show table status'

Definition at line 20 of file perf-mysql.inc.php.