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 [2016/01/13 02:14]
mnewnham ↷ Links adapted because of a move operation
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 ===== 
 +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.
  
 <WRAP 300px right box round> <WRAP 300px right box round>
Line 14: Line 19:
    
 </WRAP> </WRAP>
-===== 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 ===== ===== Setup =====
Line 24: Line 27:
  
 $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 [[v5: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 ====
Line 41: Line 44:
 | [[v5: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   |
 | [[v5: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  |
-| [[v5: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      |
 | [[v5: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 ====
  
-| [[v5: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   |
 | [[v5: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  |
 | [[v5:performance:cpuload|cpuLoad()]]          | Returns information about CPU utilization                               | | [[v5:performance:cpuload|cpuLoad()]]          | Returns information about CPU utilization                               |
v5/performance/performance_index.1452647658.txt.gz · Last modified: 2017/04/21 11:30 (external edit)