ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:performance:performance_index

This is an old revision of the document!


Performance Monitoring

Supported Drivers

The following databases support performance monitoring

Description

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.

Setup

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


$db = newAdoConnection('db2');
$db->connect('','user','password','database')
/*
 * Initialize the performance monitoring module
 */
$perf = NewPerfMonitor($db);

Features

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.1452646428.txt.gz · Last modified: 2017/04/21 11:30 (external edit)