perf_mysql Class Reference

Inheritance diagram for perf_mysql:

Collaboration 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)
Data Fields
	$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

Explain	(	$	sql,
		$	partial = false
	)

Reimplemented from adodb_perf.

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

Here is the call graph for this function:

FindDBHitRatio

(

)

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

Here is the call graph for this function:

GetInnoDBHitRatio

(

)

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

GetKeyHitRatio

(

)

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

Here is the call graph for this function:

GetQHitRatio

(

)

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

Here is the call graph for this function:

GetReads

(

)

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

GetWrites

(

)

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

optimizeTable	(	$	table,
		$	mode = ADODB_OPT_LOW
	)

See also:

adodb_perf::optimizeTable

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

perf_mysql

(

&$

conn

)

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

Tables

(

)

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

Here is the call graph for this function:

---

Field Documentation

$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.

$optimizeTableHigh = 'OPTIMIZE TABLE %s'

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

$optimizeTableLow = 'CHECK TABLE %s FAST QUICK'

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

$settings

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

$tablesSQL = 'show table status'

Reimplemented from adodb_perf.

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

---

The documentation for this class was generated from the following file:

• C:/xampp/htdocs/moodle/lib/adodb/perf/perf-mysql.inc.php