View source for Manual:$wgTrxProfilerLimits/nl

<languages />
{{SettingSummary
|name=TrxProfilerLimits
|version_min=1.26.0
|sha_introduced=7ea13643f5884dcfb2a8b4e22ae45858a81940b6
|change_introduced=206649
|section=Debug/logging
|range=(array)
|default=<syntaxhighlight lang="php" inline>false</syntaxhighlight>
|summary=Prestatieverwachtingen voor DB-gebruik
}}
<span id="Default_value"></span>
== Standaardwaarde ==
{{MW 1.33|+}}{{-}}
<syntaxhighlight lang="php">
$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
	]
];
</syntaxhighlight>

{{collapse top}}
{{MW 1.32}}{{-}}
<syntaxhighlight lang="php">
$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
	]
];
</syntaxhighlight>

{{MW 1.31|+}}{{-}}
<syntaxhighlight lang="php">
$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
	]
];
</syntaxhighlight>

{{MW 1.30|+}}{{-}}
<syntaxhighlight lang="php">
$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
	]
];
</syntaxhighlight>

{{MW version|version=1.28|version2=1.29}}{{-}}
<syntaxhighlight lang="php">
$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
	]
];
</syntaxhighlight>

{{MW 1.27}}{{-}}
<syntaxhighlight lang="php">
$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
	]
];
</syntaxhighlight>
{{collapse bottom}}

{{MW 1.26}}{{-}}
<syntaxhighlight lang="php">
$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
	)
);
</syntaxhighlight>