Documentation TYPO3 par Ameos

adodb_perf Class Reference

Inheritance diagram for adodb_perf:
[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 215 of file adodb-perf.inc.php.


Member Function Documentation

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 1035 of file adodb-perf.inc.php.

References ADOConnection::outp().

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 1049 of file adodb-perf.inc.php.

References $conn, and $table.


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


Généré par Le spécialiste TYPO3 avec  doxygen 1.4.6