Jump to content

Manual:$wgTrxProfilerLimits

From mediawiki.org
Debug: $wgTrxProfilerLimits
Performance expectations for DB usage
Introduced in version:1.26.0 (Gerrit change 206649; git #7ea13643)
Removed in version:Still in use
Allowed values:(array)
Default value:false

Default value

MediaWiki version:
1.33
$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
	]
];
Extended content
MediaWiki version:
1.32
$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
	]
];
MediaWiki version:
1.31
$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
	]
];
MediaWiki version:
1.30
$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
	]
];
MediaWiki versions:
1.28 – 1.29
$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
	]
];
MediaWiki version:
1.27
$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
	]
];
MediaWiki version:
1.26
$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
	)
);