perf_mysql Class Reference

Inheritance diagram for perf_mysql:

Public Member Functions
	__construct (&$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://adodb.sourceforge.net/docs-adodb.htm#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 20 of file perf-mysql.inc.php.

Constructor & Destructor Documentation

__construct()

perf_mysql::__construct

(

&

$conn

)

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

References adodb_perf\$conn.

Member Function Documentation

Explain()

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

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

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

FindDBHitRatio()

perf_mysql::FindDBHitRatio

(

)

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

References $rs, and adodb_perf\DBParameter().

GetInnoDBHitRatio()

perf_mysql::GetInnoDBHitRatio

(

)

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

References $rs.

GetKeyHitRatio()

perf_mysql::GetKeyHitRatio

(

)

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

References adodb_perf\_DBParameter().

GetQHitRatio()

perf_mysql::GetQHitRatio

(

)

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

References adodb_perf\_DBParameter().

GetReads()

perf_mysql::GetReads

(

)

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

References $rs.

GetWrites()

perf_mysql::GetWrites

(

)

Definition at line 161 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 293 of file perf-mysql.inc.php.

References adodb_perf\$conn, $optimizeTableHigh, $optimizeTableLow, $sql, adodb_perf\$table, ADODB_OPT_HIGH, and ADODB_OPT_LOW.

Tables()

perf_mysql::Tables

(

)

Definition at line 121 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 24 of file perf-mysql.inc.php.

$optimizeTableHigh

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

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

Referenced by optimizeTable().

$optimizeTableLow

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

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

Referenced by optimizeTable().

$settings

perf_mysql::$settings

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

$tablesSQL

perf_mysql::$tablesSQL = 'show table status'

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