Moodle PHP Documentation 4.2
Moodle 4.2.8 (Build: 20240610) (2d41ac46f45)
perf_db2 Class Reference
Inheritance diagram for perf_db2:
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 ()
 
 SplitSQL ($sql)
 
 SuspiciousSQL ($numsql=10)
 
 Tables ($throwaway=0)
 Gets a list of 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 = 'sql1'
 
 $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_db2::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.

◆ Tables()

perf_db2::Tables ( $throwaway = 0)

Gets a list of tables.

Parameters
int$throwawaydiscarded variable to match the parent method
Return values
stringThe formatted table list

Reimplemented from adodb_perf.

Member Data Documentation

◆ $createTableSQL

perf_db2::$createTableSQL
Initial value:
= "CREATE TABLE adodb_logsql (
created TIMESTAMP 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
)"

◆ $settings

perf_db2::$settings
Initial value:
= array(
'Ratios',
'data cache hit ratio' => array('RATIO',
"SELECT
case when sum(POOL_DATA_L_READS+POOL_INDEX_L_READS)=0 then 0
else 100*(1-sum(POOL_DATA_P_READS+POOL_INDEX_P_READS)/sum(POOL_DATA_L_READS+POOL_INDEX_L_READS)) end
FROM TABLE(SNAPSHOT_APPL('',-2)) as t",
'=WarnCacheRatio'),
'Data Cache',
'data cache buffers' => array('DATAC',
'select sum(npages) from SYSCAT.BUFFERPOOLS',
'See <a href=http://www7b.boulder.ibm.com/dmdd/library/techarticle/anshum/0107anshum.html#bufferpoolsize>tuning reference</a>.' ),
'cache blocksize' => array('DATAC',
'select avg(pagesize) from SYSCAT.BUFFERPOOLS',
'' ),
'data cache size' => array('DATAC',
'select sum(npages*pagesize) from SYSCAT.BUFFERPOOLS',
'' ),
'Connections',
'current connections' => array('SESS',
"SELECT count(*) FROM TABLE(SNAPSHOT_APPL_INFO('',-2)) as t",
''),
false
)

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