Moodle PHP Documentation 4.2
Moodle 4.2.8 (Build: 20240610) (2d41ac46f45)
perf_mssql Class Reference
Inheritance diagram for perf_mssql:
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)
 
 HealthCheck ($cli=false)
 
 HealthCheckCLI ()
 
 InvalidSQL ($numsql=10)
 
 MemInfo ()
 
 optimizeDatabase ()
 Reorganise current database.
 
 OptimizeTable ( $table, $mode=ADODB_OPT_LOW)
 Reorganise the table-indices/statistics/.
 
 OptimizeTables ()
 
 Poll ($secs=5)
 
 PollParameters ()
 
 sp_who ()
 
 SplitSQL ($sql)
 
 SuspiciousSQL ($numsql=10)
 
 Tables ($orderby='1')
 
 Tables ()
 
 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
 
 $settings
 
 $sql1 = 'cast(sql1 as text)'
 
 $table = '<table border=1 bgcolor=white>'
 
 $tablesSQL = false
 
 $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_mssql::Explain ( $sql,
$partial = false )

Reimplemented from adodb_perf.

◆ HealthCheck()

perf_mssql::HealthCheck ( $cli = 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.

◆ Tables()

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

Reimplemented in perf_db2.

Member Data Documentation

◆ $createTableSQL

perf_mssql::$createTableSQL
Initial value:
= "CREATE TABLE adodb_logsql (
created datetime NOT NULL,
sql0 varchar(250) NOT NULL,
sql1 varchar(4000) NOT NULL,
params varchar(3000) NOT NULL,
tracer varchar(500) NOT NULL,
timer decimal(16,6) NOT NULL
)"

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