Brian Wolff has uploaded a new change for review.
https://gerrit.wikimedia.org/r/148296
Change subject: Reduce batch size of populateBacklinkNamespace from 200 to 20
......................................................................
Reduce batch size of populateBacklinkNamespace from 200 to 20
Based on beta wiki slave lag, 200 is clearly too large.
Each batch involves 1 (cheap) select, and up to 3*$batchSize
(cheap) update statements. There is a wfWaitForSlaves() after
each batch.
Bug: 68349
Change-Id: Ic9e7ca2c3ff742dea1dbcc308b414da74dbe1d3b
---
M maintenance/populateBacklinkNamespace.php
1 file changed, 1 insertion(+), 0 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/core
refs/changes/96/148296/1
diff --git a/maintenance/populateBacklinkNamespace.php
b/maintenance/populateBacklinkNamespace.php
index 271a3f6..0851dd0 100644
--- a/maintenance/populateBacklinkNamespace.php
+++ b/maintenance/populateBacklinkNamespace.php
@@ -32,6 +32,7 @@
public function __construct() {
parent::__construct();
$this->mDescription = "Populate the *_from_namespace fields";
+ $this->setBatchSize( 20 );
}
protected function getUpdateKey() {
--
To view, visit https://gerrit.wikimedia.org/r/148296
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Ic9e7ca2c3ff742dea1dbcc308b414da74dbe1d3b
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/core
Gerrit-Branch: master
Gerrit-Owner: Brian Wolff <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
