Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.

Differences Between: [Versions 310 and 401] [Versions 311 and 401] [Versions 39 and 401] [Versions 401 and 402] [Versions 401 and 403]

performance monitoring and tuning.

Copyright: 2000-2013 John Lim
Copyright: 2014 Damien Regad, Mark Newnham and the ADOdb community
License: BSD-3-Clause
License: LGPL-2.1-or-later
File Size: 1081 lines (31 kb)
Included or required: 2 times
Referenced: 0 times
Includes or requires: 1 file
 lib/adodb/tohtml.inc.php

Defines 1 class

adodb_perf:: (28 methods):
  table()
  _CPULoad()
  MemInfo()
  CPULoad()
  Tracer()
  Explain()
  InvalidSQL()
  _SuspiciousSQL()
  CheckMemory()
  SuspiciousSQL()
  ExpensiveSQL()
  _ExpensiveSQL()
  DBParameter()
  PollParameters()
  _DBParameter()
  WarnCacheRatio()
  clearsql()
  UI()
  Poll()
  HealthCheckCLI()
  HealthCheck()
  Tables()
  CreateLogTable()
  DoSQLForm()
  SplitSQL()
  OptimizeTables()
  OptimizeTable()
  optimizeDatabase()

Defines 28 functions


Class: adodb_perf  - X-Ref

table($newtable = false)   X-Ref
No description

_CPULoad()   X-Ref
No description

MemInfo()   X-Ref
No description

CPULoad()   X-Ref
No description

Tracer($sql)   X-Ref
No description

Explain($sql,$partial=false)   X-Ref
No description

InvalidSQL($numsql = 10)   X-Ref
No description

_SuspiciousSQL($numsql = 10)   X-Ref
No description

CheckMemory()   X-Ref
No description

SuspiciousSQL($numsql=10)   X-Ref
No description

ExpensiveSQL($numsql=10)   X-Ref
No description

_ExpensiveSQL($numsql = 10)   X-Ref
No description

DBParameter($param)   X-Ref
No description

PollParameters()   X-Ref
No description

_DBParameter($sql)   X-Ref
No description

WarnCacheRatio($val)   X-Ref
No description

clearsql()   X-Ref
No description

UI($pollsecs=5)   X-Ref
No description

Poll($secs=5)   X-Ref
No description

HealthCheckCLI()   X-Ref
No description

HealthCheck($cli=false)   X-Ref
No description

Tables($orderby='1')   X-Ref
No description

CreateLogTable()   X-Ref
No description

DoSQLForm()   X-Ref
No description

SplitSQL($sql)   X-Ref
No description

OptimizeTables()   X-Ref
Reorganise multiple table-indices/statistics/..
OptimizeMode could be given by last Parameter

param: string table name of the table to optimize
param: int mode optimization-mode
author: Markus Staab
return: Returns <code>true</code> on success and <code>false</code> on error

OptimizeTable( $table, $mode = ADODB_OPT_LOW)   X-Ref
Reorganise the table-indices/statistics/.. depending on the given mode.
Default Implementation throws an error.

param: string table name of the table to optimize
param: int mode optimization-mode
author: Markus Staab
return: Returns <code>true</code> on success and <code>false</code> on error

optimizeDatabase()   X-Ref
Reorganise current database.
Default implementation loops over all <code>MetaTables()</code> and
optimize each using <code>optmizeTable()</code>

author: Markus Staab
return: Returns <code>true</code> on success and <code>false</code> on error

Functions that are not part of a class:

adodb_getmem()   X-Ref
No description

adodb_round($n,$prec)   X-Ref
No description

adodb_microtime()   X-Ref
No description

adodb_log_sql(&$connx,$sql,$inputarr)   X-Ref
No description