Helper class that detects high-contention DB queries via profiling calls. More...

Inheritance diagram for TransactionProfiler:

Collaboration diagram for TransactionProfiler:

Public Member Functions
	__construct ()

	recordConnection ($server, $db, $isMaster)
	Mark a DB as having been connected to with a new handle. More...

	recordQueryCompletion ($query, $sTime, $isWrite=false, $n=0)
	Register the name and time of a method for slow DB trx detection. More...

	resetExpectations ()
	Reset performance expectations and hit counters. More...

	setExpectation ($event, $value, $fname)
	Set performance expectations. More...

	setExpectations (array $expects, $fname)
	Set multiple performance expectations. More...

	setLogger (LoggerInterface $logger)

	setSilenced ($value)

	transactionWritingIn ($server, $db, $id)
	Mark a DB as in a transaction with one or more writes pending. More...

	transactionWritingOut ($server, $db, $id, $writeTime=0.0)
	Mark a DB as no longer in a transaction. More...

Protected Member Functions
	reportExpectationViolated ($expect, $query, $actual=null)

Protected Attributes
float	$dbLockThreshold = 3.0
	Seconds. More...

array	$dbTrxHoldingLocks = []
	transaction ID => (write start time, list of DBs involved) More...

array	$dbTrxMethodTimes = []
	transaction ID => list of (query name, start time, end time) More...

float	$eventThreshold = .25
	Seconds. More...

array array	$expect

array array array	$expectBy = []

array	$hits

bool	$silenced = false

Private Attributes
LoggerInterface	$logger

Detailed Description

Helper class that detects high-contention DB queries via profiling calls.

This class is meant to work with an IDatabase object, which manages queries

Since: 1.24

Definition at line 36 of file TransactionProfiler.php.

Constructor & Destructor Documentation

TransactionProfiler::__construct ( )

Definition at line 74 of file TransactionProfiler.php.

References setLogger().

Member Function Documentation

TransactionProfiler::recordConnection	(	$server,
		$db,
		$isMaster
	)

Mark a DB as having been connected to with a new handle.

Note that there can be multiple connections to a single DB.

Parameters

string	$server	DB server
string	$db	DB name
bool	$isMaster

Definition at line 154 of file TransactionProfiler.php.

References reportExpectationViolated().

TransactionProfiler::recordQueryCompletion	(	$query,
		$sTime,
		$isWrite = `false`,
		$n = `0`
	)

Register the name and time of a method for slow DB trx detection.

This assumes that all queries are synchronous (non-overlapping)

Parameters

string	$query	Function name or generalized SQL
float	$sTime	Starting UNIX wall time
bool	$isWrite	Whether this is a write query
integer	$n	Number of affected rows

Definition at line 200 of file TransactionProfiler.php.

References $name, $query, as, and reportExpectationViolated().

TransactionProfiler::reportExpectationViolated	(	$expect,
		$query,
		$actual = `null`
	)

protected

Parameters

string	$expect
string	$query
string \| float \| int	$actual	[optional]

Definition at line 321 of file TransactionProfiler.php.

References $expect.

Referenced by recordConnection(), recordQueryCompletion(), and transactionWritingOut().

TransactionProfiler::resetExpectations ( )

Reset performance expectations and hit counters.

Since: 1.25

Definition at line 133 of file TransactionProfiler.php.

References as.

TransactionProfiler::setExpectation	(	$event,
		$value,
		$fname
	)

Set performance expectations.

With conflicting expectations, the most narrow ones will be used

Parameters

string	$event	(writes,queries,conns,mConns)
integer	$value	Maximum count of the event
string	$fname	Caller

Since: 1.25

Definition at line 104 of file TransactionProfiler.php.

References $fname, and $value.

Referenced by setExpectations().

TransactionProfiler::setExpectations	(	array	$expects,
			$fname
	)

Set multiple performance expectations.

With conflicting expectations, the most narrow ones will be used

Parameters

array	$expects	Map of (event => limit)
	$fname

Since: 1.26

Definition at line 122 of file TransactionProfiler.php.

References $fname, $value, as, and setExpectation().

TransactionProfiler::setLogger ( LoggerInterface $logger )

Definition at line 78 of file TransactionProfiler.php.

References $logger.

Referenced by __construct().

TransactionProfiler::setSilenced ( $value )

Parameters

bool $value New value

Returns: bool Old value

Since: 1.28

Definition at line 87 of file TransactionProfiler.php.

References $silenced, and $value.

TransactionProfiler::transactionWritingIn	(	$server,
		$db,
		$id
	)

Mark a DB as in a transaction with one or more writes pending.

Note that there can be multiple connections to a single DB.

Parameters

string	$server	DB server
string	$db	DB name
string	$id	ID string of transaction

Definition at line 173 of file TransactionProfiler.php.

References $name, and as.

TransactionProfiler::transactionWritingOut	(	$server,
		$db,
		$id,
		$writeTime = `0.0`
	)

Mark a DB as no longer in a transaction.

This will check if locks are possibly held for longer than needed and log any affected transactions to a special DB log. Note that there can be multiple connections to a single DB.

Parameters

string	$server	DB server
string	$db	DB name
string	$id	ID string of transaction
float	$writeTime	Time spent in write queries

Definition at line 266 of file TransactionProfiler.php.

References $name, $query, as, list, and reportExpectationViolated().

Member Data Documentation

float TransactionProfiler::$dbLockThreshold = 3.0

protected

Seconds.

Definition at line 38 of file TransactionProfiler.php.

array TransactionProfiler::$dbTrxHoldingLocks = []

protected

transaction ID => (write start time, list of DBs involved)

Definition at line 45 of file TransactionProfiler.php.

array TransactionProfiler::$dbTrxMethodTimes = []

protected

transaction ID => list of (query name, start time, end time)

Definition at line 47 of file TransactionProfiler.php.

float TransactionProfiler::$eventThreshold = .25

protected

Seconds.

Definition at line 40 of file TransactionProfiler.php.

array array TransactionProfiler::$expect

protected

Initial value:

= [

'writes' => INF

Definition at line 57 of file TransactionProfiler.php.

Referenced by reportExpectationViolated().

array array array TransactionProfiler::$expectBy = []

protected

Definition at line 67 of file TransactionProfiler.php.

array TransactionProfiler::$hits

protected

Initial value:

= [

'writes' => 0

Definition at line 50 of file TransactionProfiler.php.

LoggerInterface TransactionProfiler::$logger

private

Definition at line 72 of file TransactionProfiler.php.

Referenced by setLogger().

bool TransactionProfiler::$silenced = false

protected

Definition at line 42 of file TransactionProfiler.php.

Referenced by setSilenced().

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

includes/libs/rdbms/TransactionProfiler.php

Public Member Functions

Protected Member Functions

Protected Attributes

Private Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation