ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:performance:performance_index

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
performance:performance_monitoring [2015/08/23 17:01] – [Table] mnewnhamv5:performance:performance_index [2020/12/29 06:57] (current) – fix typos peterdd
Line 1: Line 1:
 +<WRAP right box>
 +[[v5:performance:index|Index]]\\
 +</WRAP>
 ====== Performance Monitoring ====== ====== Performance Monitoring ======
 +
 ===== Description ===== ===== 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+ADOdb contains a number of performance monitoring tools, such as query logginghardware performanceand caching statistics. In order to use performance 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.+
  
 <WRAP 300px right box round> <WRAP 300px right box round>
-== Database Extensions == +== Supported Drivers == 
-The following databases have database specific Performance Monitoring extensions+The following databases support performance monitoring
  
-  * [[database:performance:IBM DB2]] +  * [[v5:database:ibm_db2|IBM DB2]] 
-  * [[database:performance:Informix]] +  * [[v5:database:informix|Informix]] 
-  * [[database:performance:Microsoft SQL Server]] +  * [[v5:database:microsoft_sql_server|Microsoft SQL Server]] 
-  * [[database:performance:MySQL]] +  * [[v5:database:mysql|MySQL]] 
-  * [[database:performance:Oracle]]+  * [[v5:database:oracle|Oracle]] 
 +  * [[v5:database:postgresql|PostgreSQL]]
    
- 
-See the [[database:feature_comparison|Feature Comparison Matrix]] and the [[database:connection_matrix|Connection Matrix]] 
- 
 </WRAP> </WRAP>
 +
 +===== Setup =====
 +To add performance monitoring to the ADOdb system make a call to the ''newPerfMonitor'' method.
 +---------------------
  
 <code php> <code php>
  
 $db = newAdoConnection('db2'); $db = newAdoConnection('db2');
-$db->connect('','user','password','database')+$db->connect('','user','password','database');
 /* /*
  * Initialize the performance monitoring module  * Initialize the performance monitoring module
Line 34: Line 37:
 ===== Features ===== ===== Features =====
 ==== User Interface ==== ==== User Interface ====
-A simple user interface to the performance monitoring tools is provided through the [[performance:ui|uI()]] method.+A simple user interface to the performance monitoring tools is provided through the [[v5:performance:ui|UI()]] method.
  
 ==== Query Logging ==== ==== Query Logging ====
  
-| [[performance:logsql|logSQL()]]                | Enables or disables the logging functionality                        | +| [[v5:performance:logsql|logSql()]]                | Enables or disables the logging functionality                        | 
-| [[performance:expensivesql|expensiveSQL()]]    | Returns an analysis of expensive SQL statements from acquired data   | +| [[v5:performance:expensivesql|expensiveSql()]]    | Returns an analysis of expensive SQL statements from acquired data   | 
-| [[performance:suspicioussql|suspiciousSQL()]]  | Returns an analysis of suspicious SQL statements from acquired data  | +| [[v5:performance:suspicioussql|suspiciousSql()]]  | Returns an analysis of suspicious SQL statements from acquired data  | 
-| [[performance:invalidsql|invalidSQL()]]        | Returns an analysis of invald SQL statements from acquired data      | +| [[v5:performance:invalidsql|invalidSql()]]        | Returns an analysis of invalid SQL statements from acquired data      | 
-| [[performance:clearsql|clearSQL()]]            | Empties the SQL logging table                                        |+| [[v5:performance:clearsql|clearSql()]]            | Empties the SQL logging table                                        |
  
 ==== CPU and Other Performance Indicators ==== ==== CPU and Other Performance Indicators ====
  
-| [[performance:healthcheck|healthCheck()]]  | Executes a basic database health check and returns an HTML table   | +| [[v5:performance:healthcheck|healthCheck()]]  | Executes a basic database health check and returns HTML table   | 
-| [[performance:healthCheckCli()]]           | Executes a basic database health check and reports to the console +| [[v5:performance:healthcheckcli]]           | Executes a basic database health check and reports to the console 
-| [[performance:cpuload|cpuLoad()]]          | Returns information about CPU utilization                               |+| [[v5:performance:cpuload|cpuLoad()]]          | Returns information about CPU utilization                               |
v5/performance/performance_index.txt · Last modified: 2020/12/29 06:57 by peterdd