TYPO3 CMS  TYPO3_6-2
•All Classes Namespaces Files Functions Variables Pages
Public Member Functions | Public Attributes | List of all members
perf_mysql Class Reference
Inheritance diagram for perf_mysql:
adodb_perf

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.