perf_db2 Class Reference

Inheritance diagram for perf_db2:

Public Member Functions
	__construct (&$conn)
	_CPULoad ()
	_DBParameter ($sql)
	_ExpensiveSQL ($numsql=10)
	_SuspiciousSQL ($numsql=10)
	CheckMemory ()
	clearsql ()
	CPULoad ()
	CreateLogTable ()
	DBParameter ($param)
	DoSQLForm ()
	ExpensiveSQL ($numsql=10)
	Explain ($sql, $partial=false)
	HealthCheck ($cli=false)
	HealthCheckCLI ()
	InvalidSQL ($numsql=10)
	MemInfo ()
	optimizeDatabase ()
	Reorganise current database.
	OptimizeTable ( $table, $mode=ADODB_OPT_LOW)
	Reorganise the table-indices/statistics/.
	OptimizeTables ()
	Poll ($secs=5)
	PollParameters ()
	SplitSQL ($sql)
	SuspiciousSQL ($numsql=10)
	Tables ($throwaway=0)
	Gets a list of tables.
	Tracer ($sql)
	UI ($pollsecs=5)
	WarnCacheRatio ($val)

Static Public Member Functions
static	table ($newtable=false)

Public Attributes
	$_lastLoad
	$cliFormat = "%32s => %s r\n"
	$color = '#F0F0F0'
	$conn
	$createTableSQL
	$explain = true
	$helpurl = '<a href="https://adodb.org/dokuwiki/doku.php?id=v5:performance:logsql">LogSQL help</a>'
	$maxLength = 2000
	$settings
	$sql1 = 'sql1'
	$table = '<table border=1 bgcolor=white>'
	$tablesSQL = false
	$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'
	$warnRatio = 90

Member Function Documentation

Explain()

perf_db2::Explain	(		$sql,
			$partial = false )

Reimplemented from adodb_perf.

optimizeDatabase()

adodb_perf::optimizeDatabase ( )

inherited

Reorganise current database.

Default implementation loops over all MetaTables() and optimize each using optmizeTable()

Author

Markus Staab

Return values

Returns

true on success and false on error

Examples

/home/runner/work/phpdoc/phpdoc/.moodle/lib/adodb/adodb-perf.inc.php.

OptimizeTable()

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

inherited

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

Return values

Returns

true on success and false on error

Examples

/home/runner/work/phpdoc/phpdoc/.moodle/lib/adodb/adodb-perf.inc.php.

Tables()

perf_db2::Tables

(

$throwaway = 0

)

Gets a list of tables.

Parameters

int

$throwaway

discarded variable to match the parent method

Return values

string

The formatted table list

Reimplemented from adodb_perf.

Member Data Documentation

$createTableSQL

perf_db2::$createTableSQL

Initial value:

= "CREATE TABLE adodb_logsql (
          created TIMESTAMP NOT NULL,
          sql0 varchar(250) NOT NULL,
          sql1 varchar(4000) NOT NULL,
          params varchar(3000) NOT NULL,
          tracer varchar(500) NOT NULL,
          timer decimal(16,6) NOT NULL
        )"

$settings

perf_db2::$settings

Initial value:

= array(
    'Ratios',
        'data cache hit ratio' => array('RATIO',
            "SELECT
                case when sum(POOL_DATA_L_READS+POOL_INDEX_L_READS)=0 then 0
                else 100*(1-sum(POOL_DATA_P_READS+POOL_INDEX_P_READS)/sum(POOL_DATA_L_READS+POOL_INDEX_L_READS)) end
                FROM TABLE(SNAPSHOT_APPL('',-2)) as t",
            '=WarnCacheRatio'),
 
    'Data Cache',
        'data cache buffers' => array('DATAC',
        'select sum(npages) from SYSCAT.BUFFERPOOLS',
            'See <a href=http://www7b.boulder.ibm.com/dmdd/library/techarticle/anshum/0107anshum.html#bufferpoolsize>tuning reference</a>.' ),
        'cache blocksize' => array('DATAC',
        'select avg(pagesize) from SYSCAT.BUFFERPOOLS',
            '' ),
        'data cache size' => array('DATAC',
        'select sum(npages*pagesize) from SYSCAT.BUFFERPOOLS',
            '' ),
    'Connections',
        'current connections' => array('SESS',
            "SELECT count(*) FROM TABLE(SNAPSHOT_APPL_INFO('',-2)) as t",
            ''),
 
        false
    )

---

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

• lib/adodb/perf/perf-db2.inc.php