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 revision Previous revision
Next revision
Previous revision
v5:performance:performance_index [2015/11/24 16:50]
mnewnham
v5:performance:performance_index [2020/12/29 06:57] (current)
peterdd fix typos
Line 1: Line 1:
 +<WRAP right box>
 +[[v5:performance:index|Index]]\\
 +</WRAP>
 ====== Performance Monitoring ====== ====== Performance Monitoring ======
-~~NOTOC~~+
 ===== 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>
Line 11: Line 11:
 The following databases support performance monitoring The following databases support performance monitoring
  
-  * [[database:ibm_db2|IBM DB2]] +  * [[v5:database:ibm_db2|IBM DB2]] 
-  * [[database:informix|Informix]] +  * [[v5:database:informix|Informix]] 
-  * [[database:microsoft_sql_server|Microsoft SQL Server]] +  * [[v5:database:microsoft_sql_server|Microsoft SQL Server]] 
-  * [[database:mysql|MySQL]] +  * [[v5:database:mysql|MySQL]] 
-  * [[database:oracle|Oracle]] +  * [[v5:database:oracle|Oracle]] 
-  * [[database:postgresql|PostgreSQL]]+  * [[v5:database:postgresql|PostgreSQL]]
    
 </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 33: 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.1448380229.txt.gz · Last modified: 2017/04/21 11:30 (external edit)