ADOdb contains a number of performance monitoring tools, such as query logging, hardware performance, and caching statistics. In order to use performance monitoring, the driver must be one of those specified below.
The following databases support performance monitoring
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);
A simple user interface to the performance monitoring tools is provided through the UI() method.
| 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 invalid SQL statements from acquired data |
| clearSql() | Empties the SQL logging table |
| healthCheck() | Executes a basic database health check and returns a HTML table |
| healthCheckCli | Executes a basic database health check and reports to the console |
| cpuLoad() | Returns information about CPU utilization |