- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:performance:performance_index

Index

# Performance Monitoring

##### Supported Drivers

The following databases support performance monitoring

- IBM DB2
- Informix
- Microsoft SQL Server
- MySQL
- Oracle
- PostgreSQL

## 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.txt · Last modified: 2016/01/13 07:15 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top