"TYPO3 4.0.1: adodb_perf Class Reference", "datetime" => "Sat Dec 2 19:23:49 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

adodb_perf Class Reference

Inheritance diagram for adodb_perf:

Inheritance graph
[legend]
List of all members.

Public Member Functions

 table ($newtable=false)
 _CPULoad ()
 MemInfo ()
 CPULoad ()
 Tracer ($sql)
 Explain ($sql, $partial=false)
 InvalidSQL ($numsql=10)
 _SuspiciousSQL ($numsql=10)
 CheckMemory ()
 SuspiciousSQL ($numsql=10)
 ExpensiveSQL ($numsql=10)
 _ExpensiveSQL ($numsql=10)
 DBParameter ($param)
& PollParameters ()
 _DBParameter ($sql)
 WarnCacheRatio ($val)
 UI ($pollsecs=5)
 Poll ($secs=5)
 HealthCheckCLI ()
 HealthCheck ($cli=false)
 Tables ($orderby='1')
 CreateLogTable ()
 DoSQLForm ()
 SplitSQL ($sql)
 undomq ($m)
 OptimizeTables ()
 OptimizeTable ($table, $mode=ADODB_OPT_LOW)
 optimizeDatabase ()

Public Attributes

 $conn
 $color = '#F0F0F0'
 $table = '<table border=1 bgcolor=white>'
 $titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'
 $warnRatio = 90
 $tablesSQL = false
 $cliFormat = "%32s => %s \r\n"
 $sql1 = 'sql1'
 $explain = true
 $helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"
 $createTableSQL = false
 $maxLength = 2000
 $_lastLoad

Detailed Description

Definition at line 202 of file adodb-perf.inc.php.

Member Function Documentation

adodb_perf::optimizeDatabase (   ) 
 

Reorganise current database. Default implementation loops over all MetaTables() and optimize each using optmizeTable()

Author:
Markus Staab
Returns:
Returns true on success and false on error

Definition at line 1037 of file adodb-perf.inc.php.

References $table.

adodb_perf::OptimizeTable (  $  table,
$  mode = ADODB_OPT_LOW
) 
 

Reorganise the table-indices/statistics/.. depending on the given mode. Default Implementation throws an error.

Parameters:
string table name of the table to optimize
int mode optimization-mode ADODB_OPT_HIGH for full optimization ADODB_OPT_LOW for CPU-less optimization Default is LOW ADODB_OPT_LOW
Author:
Markus Staab
Returns:
Returns true on success and false on error

Definition at line 1023 of file adodb-perf.inc.php.

References ADOConnection::outp().

The documentation for this class was generated from the following file: