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