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
Last revisionBoth sides next revision
performance:performance_monitoring [2015/08/23 17:01] – [Table] mnewnhamv5:performance:performance_index [2020/01/13 15:54] – Remove NOTOC, move description section up dregad
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 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. 
  
 <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>
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 invald 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 an 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