Database Abstraction Layer for PHP

User Tools

Site Tools


This is an old revision of the document!

Performance Monitoring


ADOdb contains a number of performance monitoring tools, such as query logging hardware performance and caching statistics. In order to use perfomance monitoring, the driver must be one of those specified below.


To add performance monitoring to the ADOdb system make a call to the newPerfMonitor method.

Database Extensions

The following databases have database specific Performance Monitoring extensions

See the Feature Comparison Matrix and the Connection Matrix

$db = newAdoConnection('db2');
 * Initialize the performance monitoring module
$perf = NewPerfMonitor($db);


User Interface

A simple user interface to the performance monitoring tools is provided through the uI() method.

Query Logging

logSql() Enables or disables the logging functionality
expensiveSql() Returns an analysis of expensive SQL statements from acquired data
suspiciousSql() Returns an analysis of suspicious SQL statements from acquired data
invalidSql() Returns an analysis of invald SQL statements from acquired data
clearSql() Empties the SQL logging table

CPU and Other Performance Indicators

healthCheck() Executes a basic database health check and returns an HTML table
healthCheckCli() Executes a basic database health check and reports to the console
cpuLoad() Returns information about CPU utilization
v5/performance/performance_index.1440342629.txt.gz · Last modified: 2017/04/21 11:30 (external edit)