Manual:$wgTrxProfilerLimits

The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

<translate> Debug</translate>: $wgTrxProfilerLimits
Performance expectations for DB usage
<translate> Introduced in version:</translate>	1.26.0 (Gerrit change 206649; git #7ea13643)
<translate> Removed in version:</translate>	<translate> still in use</translate>
<translate> Allowed values:</translate>	(array)
<translate> Default value:</translate>	`false`
<translate> Other settings:</translate> <translate> Alphabetical</translate> \| <translate> By function</translate>

Default value

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.33

<translate> MediaWiki version:</translate>

$wgTrxProfilerLimits = [
	// HTTP GET/HEAD requests.
	// Primary queries should not happen on GET requests
	'GET' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5,
		'readQueryRows' => 10000
	],
	// HTTP POST requests.
	// Primary reads and writes will happen for a subset of these.
	'POST' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'readQueryRows' => 100000,
		'maxAffected' => 1000
	],
	'POST-nonwrite' => [
		'writes' => 0,
		'readQueryTime' => 5,
		'readQueryRows' => 10000
	],
	// Deferred updates that run after HTTP response is sent for GET requests
	'PostSend-GET' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'readQueryRows' => 10000,
		'maxAffected' => 1000,
		// Log primary queries under the post-send entry point as they are discouraged
		'masterConns' => 0,
		'writes' => 0,
	],
	// Deferred updates that run after HTTP response is sent for POST requests
	'PostSend-POST' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'readQueryRows' => 100000,
		'maxAffected' => 1000
	],
	// Background job runner
	'JobRunner' => [
		'readQueryTime' => 30,
		'writeQueryTime' => 5,
		'readQueryRows' => 100000,
		'maxAffected' => 500 // ballpark of $wgUpdateRowsPerQuery
	],
	// Command-line scripts
	'Maintenance' => [
		'writeQueryTime' => 5,
		'maxAffected' => 1000
	]
];

<translate> Extended content</translate>

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.32</tvar> is unsupported version</translate>">

1.32

<translate> MediaWiki version:</translate>

$wgTrxProfilerLimits = [
	// HTTP GET/HEAD requests.
	// Master queries should not happen on GET requests
	'GET' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5,
		'readQueryRows' => 10000
	],
	// HTTP POST requests.
	// Master reads and writes will happen for a subset of these.
	'POST' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'readQueryRows' => 100000,
		'maxAffected' => 1000
	],
	'POST-nonwrite' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5,
		'readQueryRows' => 10000
	],
	// Deferred updates that run after HTTP response is sent for GET requests
	'PostSend-GET' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'readQueryRows' => 10000,
		'maxAffected' => 1000,
		// Log master queries under the post-send entry point as they are discouraged
		'masterConns' => 0,
		'writes' => 0,
	],
	// Deferred updates that run after HTTP response is sent for POST requests
	'PostSend-POST' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'readQueryRows' => 100000,
		'maxAffected' => 1000
	],
	// Background job runner
	'JobRunner' => [
		'readQueryTime' => 30,
		'writeQueryTime' => 5,
		'readQueryRows' => 100000,
		'maxAffected' => 500 // ballpark of $wgUpdateRowsPerQuery
	],
	// Command-line scripts
	'Maintenance' => [
		'writeQueryTime' => 5,
		'maxAffected' => 1000
	]
];

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.31

<translate> MediaWiki version:</translate>

$wgTrxProfilerLimits = [
	// HTTP GET/HEAD requests.
	// Master queries should not happen on GET requests
	'GET' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5
	],
	// HTTP POST requests.
	// Master reads and writes will happen for a subset of these.
	'POST' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'maxAffected' => 1000
	],
	'POST-nonwrite' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5
	],
	// Deferred updates that run after HTTP response is sent for GET requests
	'PostSend-GET' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'maxAffected' => 1000,
		// Log master queries under the post-send entry point as they are discouraged
		'masterConns' => 0,
		'writes' => 0,
	],
	// Deferred updates that run after HTTP response is sent for POST requests
	'PostSend-POST' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'maxAffected' => 1000
	],
	// Background job runner
	'JobRunner' => [
		'readQueryTime' => 30,
		'writeQueryTime' => 5,
		'maxAffected' => 500 // ballpark of $wgUpdateRowsPerQuery
	],
	// Command-line scripts
	'Maintenance' => [
		'writeQueryTime' => 5,
		'maxAffected' => 1000
	]
];

<td class="mw-version-versionbox" title="<translate nowrap> The latest stable version is <tvar name=1>1.41</tvar></translate>">

<translate> ≥</translate> 1.30

<translate> MediaWiki version:</translate>

$wgTrxProfilerLimits = [
	// HTTP GET/HEAD requests.
	// Master queries should not happen on GET requests
	'GET' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5
	],
	// HTTP POST requests.
	// Master reads and writes will happen for a subset of these.
	'POST' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'maxAffected' => 1000
	],
	'POST-nonwrite' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5
	],
	// Deferred updates that run after HTTP response is sent
	'PostSend' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'maxAffected' => 1000,
		// Log master queries under the post-send entry point as they are discouraged
		'masterConns' => 0,
		'writes' => 0,
	],
	// Background job runner
	'JobRunner' => [
		'readQueryTime' => 30,
		'writeQueryTime' => 5,
		'maxAffected' => 500 // ballpark of $wgUpdateRowsPerQuery
	],
	// Command-line scripts
	'Maintenance' => [
		'writeQueryTime' => 5,
		'maxAffected' => 1000
	]
];

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.29</tvar> is unsupported version</translate>">

1.28 – 1.29

<translate> MediaWiki versions:</translate>

$wgTrxProfilerLimits = [
	// HTTP GET/HEAD requests.
	// Master queries should not happen on GET requests
	'GET' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5
	],
	// HTTP POST requests.
	// Master reads and writes will happen for a subset of these.
	'POST' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'maxAffected' => 1000
	],
	'POST-nonwrite' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5
	],
	// Deferred updates that run after HTTP response is sent
	'PostSend' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'maxAffected' => 1000
	],
	// Background job runner
	'JobRunner' => [
		'readQueryTime' => 30,
		'writeQueryTime' => 5,
		'maxAffected' => 500 // ballpark of $wgUpdateRowsPerQuery
	],
	// Command-line scripts
	'Maintenance' => [
		'writeQueryTime' => 5,
		'maxAffected' => 1000
	]
];

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.27</tvar> is unsupported version</translate>">

1.27

MediaWiki version:

$wgTrxProfilerLimits = [
	// HTTP GET/HEAD requests.
	// Master queries should not happen on GET requests
	'GET' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5
	],
	// HTTP POST requests.
	// Master reads and writes will happen for a subset of these.
	'POST' => [
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'maxAffected' => 500
	],
	'POST-nonwrite' => [
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5
	],
	// Background job runner
	'JobRunner' => [
		'readQueryTime' => 30,
		'writeQueryTime' => 5,
		'maxAffected' => 1000
	],
	// Command-line scripts
	'Maintenance' => [
		'writeQueryTime' => 5,
		'maxAffected' => 1000
	]
];

<td class="mw-version-versionbox" title="<translate nowrap> MediaWiki <tvar name=1>1.26</tvar> is unsupported version</translate>">

1.26

MediaWiki version:

$wgTrxProfilerLimits = array(
	// Basic GET and POST requests
	'GET' => array(
		'masterConns' => 0,
		'writes' => 0,
		'readQueryTime' => 5
	),
	'POST' => array(
		'readQueryTime' => 5,
		'writeQueryTime' => 1,
		'maxAffected' => 500
	),
	// Background job runner
	'JobRunner' => array(
		'readQueryTime' => 30,
		'writeQueryTime' => 5,
		'maxAffected' => 500
	),
	// Command-line scripts
	'Maintenance' => array(
		'writeQueryTime' => 5,
		'maxAffected' => 1000
	)
);