Pgehres has uploaded a new change for review.
https://gerrit.wikimedia.org/r/54806
Change subject: Adding wfWaitForSlaves before we melt the centralauth cluster.
......................................................................
Adding wfWaitForSlaves before we melt the centralauth cluster.
Also fixing OBO error and increasing chunk size.
Change-Id: Idac8c11142f0e64acf088aa4037d00f6b7eecbbc
---
M maintenance/migratePass0.php
1 file changed, 6 insertions(+), 2 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/CentralAuth
refs/changes/06/54806/1
diff --git a/maintenance/migratePass0.php b/maintenance/migratePass0.php
index 909130d..601533d 100644
--- a/maintenance/migratePass0.php
+++ b/maintenance/migratePass0.php
@@ -16,7 +16,7 @@
function migratePassZero() {
global $wgDBname;
$dbr = wfGetDB( DB_SLAVE );
- $chunkSize = 1000;
+ $chunkSize = 10000;
$start = microtime( true );
$migrated = 0;
@@ -27,7 +27,7 @@
$lastUser = $dbr->selectField( 'user', 'MAX(user_id)', '', __FUNCTION__
);
for ( $min = 0; $min <= $lastUser; $min += $chunkSize ) {
- $max = $min + $chunkSize;
+ $max = $min + $chunkSize - 1;
$result = $dbr->select( 'user',
array( 'user_id', 'user_name' ),
"user_id BETWEEN $min AND $max",
@@ -48,6 +48,10 @@
min( $max, $lastUser ) / $lastUser * 100.0,
$delta,
$rate );
+
+ echo "Waiting for slaves to catch up ... ";
+ wfWaitForSlaves( false, 'centralauth' );
+ echo "done\n";
}
}
--
To view, visit https://gerrit.wikimedia.org/r/54806
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: Idac8c11142f0e64acf088aa4037d00f6b7eecbbc
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/CentralAuth
Gerrit-Branch: master
Gerrit-Owner: Pgehres <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
