Moodle PHP Documentation 4.2
Moodle 4.2.8 (Build: 20240610) (2d41ac46f45)
perf_mysql Class Reference
Inheritance diagram for perf_mysql:
adodb_perf

Public Member Functions

 __construct (&$conn)
 
 _CPULoad ()
 
 _DBParameter ($sql)
 
 _ExpensiveSQL ($numsql=10)
 
 _SuspiciousSQL ($numsql=10)
 
 CheckMemory ()
 
 clearsql ()
 
 CPULoad ()
 
 CreateLogTable ()
 
 DBParameter ($param)
 
 DoSQLForm ()
 
 ExpensiveSQL ($numsql=10)
 
 Explain ($sql, $partial=false)
 
 FindDBHitRatio ()
 
 GetInnoDBHitRatio ()
 
 GetKeyHitRatio ()
 
 GetQHitRatio ()
 
 GetReads ()
 
 GetWrites ()
 
 HealthCheck ($cli=false)
 
 HealthCheckCLI ()
 
 InvalidSQL ($numsql=10)
 
 MemInfo ()
 
 optimizeDatabase ()
 Reorganise current database.
 
 OptimizeTable ( $table, $mode=ADODB_OPT_LOW)
 Reorganise the table-indices/statistics/.
 
 optimizeTable ( $table, $mode=ADODB_OPT_LOW)
 
 OptimizeTables ()
 
 Poll ($secs=5)
 
 PollParameters ()
 
 SplitSQL ($sql)
 
 SuspiciousSQL ($numsql=10)
 
 Tables ($orderby='1')
 
 tables ($orderby='1')
 Returns a list of table statuses.
 
 Tracer ($sql)
 
 UI ($pollsecs=5)
 
 WarnCacheRatio ($val)
 

Static Public Member Functions

static table ($newtable=false)
 

Public Attributes

 $_lastLoad
 
 $cliFormat = "%32s => %s r\n"
 
 $color = '#F0F0F0'
 
 $conn
 
 $createTableSQL
 
 $explain = true
 
 $helpurl = '<a href="https://adodb.org/dokuwiki/doku.php?id=v5:performance:logsql">LogSQL help</a>'
 
 $maxLength = 2000
 
 $optimizeTableHigh = 'OPTIMIZE TABLE %s'
 
 $optimizeTableLow = 'CHECK TABLE %s FAST QUICK'
 
 $settings
 
 $sql1 = 'sql1'
 
 $table = '<table border=1 bgcolor=white>'
 
 $tablesSQL = 'show table status'
 
 $titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'
 
 $warnRatio = 90
 

Member Function Documentation

◆ Explain()

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

Reimplemented from adodb_perf.

◆ optimizeDatabase()

adodb_perf::optimizeDatabase ( )
inherited

Reorganise current database.

Default implementation loops over all MetaTables() and optimize each using optmizeTable()

Author
Markus Staab
Return values
Returnstrue on success and false on error
Examples
/home/runner/work/phpdoc/phpdoc/.moodle/lib/adodb/adodb-perf.inc.php.

◆ OptimizeTable()

adodb_perf::OptimizeTable ( $table,
$mode = ADODB_OPT_LOW )
inherited

Reorganise the table-indices/statistics/.

. depending on the given mode. Default Implementation throws an error.

Parameters
stringtable name of the table to optimize
intmode optimization-mode ADODB_OPT_HIGH for full optimization ADODB_OPT_LOW for CPU-less optimization Default is LOW ADODB_OPT_LOW
Author
Markus Staab
Return values
Returnstrue on success and false on error
Examples
/home/runner/work/phpdoc/phpdoc/.moodle/lib/adodb/adodb-perf.inc.php.

◆ optimizeTable()

perf_mysql::optimizeTable ( $table,
$mode = ADODB_OPT_LOW )
See also
adodb_perf\optimizeTable()

◆ Tables()

adodb_perf::Tables ( $orderby = '1')
inherited

Reimplemented in perf_db2.

◆ tables()

perf_mysql::tables ( $orderby = '1')

Returns a list of table statuses.

Parameters
string$orderbyUnused (compatibility with parent method)
Return values
stringA formatted set of recordsets

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

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