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
v5:performance:performance_index [2020/01/13 15:54] – Remove NOTOC, move description section up dregadv5:performance:performance_index [2020/12/29 06:57] (current) – fix typos peterdd
Line 5: Line 5:
  
 ===== 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.
  
 <WRAP 300px right box round> <WRAP 300px right box round>
Line 27: 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 37: 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 44: 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.txt · Last modified: 2020/12/29 06:57 by peterdd