Gecko [ paroquia-rio-de-mouro.pt ]

Name	Size	Permission	Date
archives	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
benchmarks	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
cssjanus	[ DIR ]	drwxr-xr-x	2012-03-22 16:23
dev	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
dictionary	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
dtrace	[ DIR ]	drwxr-xr-x	2012-03-22 16:23
gearman	[ DIR ]	drwxr-xr-x	2012-03-22 16:23
hhvm	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
hiphop	[ DIR ]	drwxr-xr-x	2012-03-22 16:23
ibm_db2	[ DIR ]	drwxr-xr-x	2012-03-22 16:23
jsduck	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
language	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
locking	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
mssql	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
oracle	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
postgres	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
resources	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
sqlite	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
storage	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
term	[ DIR ]	drwxr-xr-x	2016-11-28 20:20
.htaccess	197 B	-r--r--r--	2026-08-22 08:29
7zip.inc	2.5 KB	-rw-r--r--	2016-11-28 20:20
Doxyfile	14.16 KB	-rw-r--r--	2016-11-28 20:20
Maintenance.php	42.74 KB	-rw-r--r--	2016-11-28 20:20
Makefile	582 B	-rw-r--r--	2016-11-28 20:20
README	2.87 KB	-rw-r--r--	2016-11-28 20:20
Site.php	351 B	-rw-r--r--	2011-09-29 22:59
addRFCandPMIDInterwiki.php	2.43 KB	-rw-r--r--	2016-11-28 20:20
addwiki.php	9.91 KB	-rw-r--r--	2011-08-14 11:27
attachLatest.php	2.98 KB	-rw-r--r--	2016-11-28 20:20
backup.inc	12.11 KB	-rw-r--r--	2016-11-28 20:20
backupPrefetch.inc	5.46 KB	-rw-r--r--	2016-11-28 20:20
cdb.php	3.09 KB	-rw-r--r--	2016-11-28 20:20
changePassword.php	2.43 KB	-rw-r--r--	2016-11-28 20:20
checkAutoLoader.php	1.99 KB	-rw-r--r--	2011-01-13 23:58
checkBadRedirects.php	1.94 KB	-rw-r--r--	2016-11-28 20:20
checkComposerLockUpToDate.php	2.02 KB	-rw-r--r--	2016-11-28 20:20
checkImages.php	2.4 KB	-rw-r--r--	2016-11-28 20:20
checkLess.php	1.91 KB	-rw-r--r--	2016-11-28 20:20
checkSyntax.php	9.27 KB	-rw-r--r--	2016-11-28 20:20
checkUsernames.php	1.97 KB	-rw-r--r--	2016-11-28 20:20
cleanupAncientTables.php	3.32 KB	-rw-r--r--	2016-11-28 20:20
cleanupBlocks.php	3.82 KB	-rw-r--r--	2016-11-28 20:20
cleanupCaps.php	5.07 KB	-rw-r--r--	2016-11-28 20:20
cleanupEmptyCategories.php	5.41 KB	-rw-r--r--	2016-11-28 20:20
cleanupImages.php	6.05 KB	-rw-r--r--	2016-11-28 20:20
cleanupPreferences.php	1.57 KB	-rw-r--r--	2016-11-28 20:20
cleanupRemovedModules.php	2.28 KB	-rw-r--r--	2016-11-28 20:20
cleanupSpam.php	4.89 KB	-rw-r--r--	2016-11-28 20:20
cleanupTable.inc	4.7 KB	-rw-r--r--	2016-11-28 20:20
cleanupTitles.php	5.67 KB	-rw-r--r--	2016-11-28 20:20
cleanupUploadStash.php	4.88 KB	-rw-r--r--	2016-11-28 20:20
cleanupWatchlist.php	2.86 KB	-rw-r--r--	2016-11-28 20:20
clearInterwikiCache.php	1.72 KB	-rw-r--r--	2016-11-28 20:20
clear_interwiki_cache.php	1.65 KB	-rw-r--r--	2011-01-13 23:58
clear_stats.php	1.93 KB	-rw-r--r--	2011-01-13 23:58
commandLine.inc	2.15 KB	-rw-r--r--	2016-11-28 20:20
compareParserCache.php	3.2 KB	-rw-r--r--	2016-11-28 20:20
compareParsers.php	5.41 KB	-rw-r--r--	2016-11-28 20:20
convertExtensionToRegistration.php	9.71 KB	-rw-r--r--	2016-11-28 20:20
convertLinks.php	9.76 KB	-rw-r--r--	2016-11-28 20:20
convertUserOptions.php	3.12 KB	-rw-r--r--	2016-11-28 20:20
copyFileBackend.php	14.42 KB	-rw-r--r--	2016-11-28 20:20
copyJobQueue.php	3.3 KB	-rw-r--r--	2016-11-28 20:20
createAndPromote.php	4.37 KB	-rw-r--r--	2016-11-28 20:20
createCommonPasswordCdb.php	3.51 KB	-rw-r--r--	2016-11-28 20:20
deleteArchivedFiles.inc	2.42 KB	-rw-r--r--	2011-01-21 18:42
deleteArchivedFiles.php	3.86 KB	-rw-r--r--	2016-11-28 20:20
deleteArchivedRevisions.inc	1.68 KB	-rw-r--r--	2011-07-01 04:25
deleteArchivedRevisions.php	2.09 KB	-rw-r--r--	2016-11-28 20:20
deleteBatch.php	3.78 KB	-rw-r--r--	2016-11-28 20:20
deleteDefaultMessages.php	2.69 KB	-rw-r--r--	2016-11-28 20:20
deleteEqualMessages.php	6.83 KB	-rw-r--r--	2016-11-28 20:20
deleteImageMemcached.php	2.27 KB	-rw-r--r--	2011-01-13 23:58
deleteOldRevisions.php	3.22 KB	-rw-r--r--	2016-11-28 20:20
deleteOrphanedRevisions.php	3.06 KB	-rw-r--r--	2016-11-28 20:20
deleteRevision.php	3.04 KB	-rw-r--r--	2016-11-28 20:20
deleteSelfExternals.php	1.84 KB	-rw-r--r--	2016-11-28 20:20
doMaintenance.php	4.14 KB	-rw-r--r--	2016-11-28 20:20
dumpBackup.php	4.87 KB	-rw-r--r--	2016-11-28 20:20
dumpHTML.php	204 B	-rw-r--r--	2008-02-27 07:19
dumpInterwiki.php	8.62 KB	-rw-r--r--	2011-09-29 22:59
dumpIterator.php	5.35 KB	-rw-r--r--	2016-11-28 20:20
dumpLinks.php	2.31 KB	-rw-r--r--	2016-11-28 20:20
dumpSisterSites.php	1.76 KB	-rw-r--r--	2011-01-13 23:58
dumpTextPass.php	28.87 KB	-rw-r--r--	2016-11-28 20:20
dumpUploads.php	3.72 KB	-rw-r--r--	2016-11-28 20:20
edit.php	3.4 KB	-rw-r--r--	2016-11-28 20:20
eraseArchivedFile.php	3.84 KB	-rw-r--r--	2016-11-28 20:20
eval.php	3.04 KB	-rw-r--r--	2016-11-28 20:20
exportSites.php	1.32 KB	-rw-r--r--	2016-11-28 20:20
fetchText.php	2.57 KB	-rw-r--r--	2016-11-28 20:20
fileOpPerfTest.php	4.7 KB	-rw-r--r--	2016-11-28 20:20
findDeprecated.php	5.52 KB	-rw-r--r--	2016-11-28 20:20
findHooks.php	10.19 KB	-rw-r--r--	2016-11-28 20:20
findMissingFiles.php	3.8 KB	-rw-r--r--	2016-11-28 20:20
findOrphanedFiles.php	4.28 KB	-rw-r--r--	2016-11-28 20:20
fixDefaultJsonContentPages.php	3.9 KB	-rw-r--r--	2016-11-28 20:20
fixDoubleRedirects.php	4 KB	-rw-r--r--	2016-11-28 20:20
fixExtLinksProtocolRelative.php	2.94 KB	-rw-r--r--	2016-11-28 20:20
fixSlaveDesync.php	6.19 KB	-rw-r--r--	2011-07-01 03:42
fixTimestamps.php	4.18 KB	-rw-r--r--	2016-11-28 20:20
fixUserRegistration.php	2.46 KB	-rw-r--r--	2016-11-28 20:20
formatInstallDoc.php	2.32 KB	-rw-r--r--	2016-11-28 20:20
fuzz-tester.php	101.66 KB	-rw-r--r--	2011-06-17 18:05
generateJsonI18n.php	6.35 KB	-rw-r--r--	2016-11-28 20:20
generateLocalAutoload.php	510 B	-rw-r--r--	2016-11-28 20:20
generateSitemap.php	13.62 KB	-rw-r--r--	2016-11-28 20:20
getConfiguration.php	5.16 KB	-rw-r--r--	2016-11-28 20:20
getLagTimes.php	1.83 KB	-rw-r--r--	2016-11-28 20:20
getReplicaServer.php	1.68 KB	-rw-r--r--	2016-11-28 20:20
getSlaveServer.php	71 B	-rw-r--r--	2016-11-28 20:20
getText.php	2.1 KB	-rw-r--r--	2016-11-28 20:20
importDump.php	8.93 KB	-rw-r--r--	2016-11-28 20:20
importImages.inc	4.14 KB	-rw-r--r--	2016-11-28 20:20
importImages.php	11.76 KB	-rw-r--r--	2016-11-28 20:20
importSiteScripts.php	3.43 KB	-rw-r--r--	2016-11-28 20:20
importSites.php	1.26 KB	-rw-r--r--	2016-11-28 20:20
importTextFile.php	2.95 KB	-rw-r--r--	2010-12-16 20:15
importTextFiles.php	6.39 KB	-rw-r--r--	2016-11-28 20:20
importUseModWiki.php	11.25 KB	-rw-r--r--	2011-05-18 00:03
importUseModWikipedia.php	25.67 KB	-rw-r--r--	2011-04-23 23:40
initEditCount.php	3.34 KB	-rw-r--r--	2016-11-28 20:20
initSiteStats.php	2.62 KB	-rw-r--r--	2016-11-28 20:20
initStats.php	2.67 KB	-rw-r--r--	2011-03-30 20:34
install.php	5.69 KB	-rw-r--r--	2016-11-28 20:20
interwiki.list	3.97 KB	-rw-r--r--	2016-11-28 20:20
interwiki.sql	4.66 KB	-rw-r--r--	2016-11-28 20:20
invalidateUserSessions.php	3.09 KB	-rw-r--r--	2016-11-28 20:20
jsparse.php	2.11 KB	-rw-r--r--	2016-11-28 20:20
lag.php	1.98 KB	-rw-r--r--	2016-11-28 20:20
makeTestEdits.php	2.15 KB	-rw-r--r--	2016-11-28 20:20
mcc.php	5.32 KB	-rw-r--r--	2016-11-28 20:20
mctest.php	3.35 KB	-rw-r--r--	2016-11-28 20:20
mergeMessageFileList.php	6.39 KB	-rw-r--r--	2016-11-28 20:20
migrateFileRepoLayout.php	7.32 KB	-rw-r--r--	2016-11-28 20:20
migrateUserGroup.php	3.54 KB	-rw-r--r--	2016-11-28 20:20
minify.php	3.84 KB	-rw-r--r--	2016-11-28 20:20
moveBatch.php	4.07 KB	-rw-r--r--	2016-11-28 20:20
mwdoc-filter.php	3.3 KB	-rw-r--r--	2016-11-28 20:20
mwdocgen.php	4.39 KB	-rw-r--r--	2016-11-28 20:20
mwjsduck-gen	54 B	-rwxr-xr-x	2016-11-28 20:20
namespaceDupes.php	18.67 KB	-rw-r--r--	2016-11-28 20:20
nextJobDB.php	4.24 KB	-rw-r--r--	2011-03-10 05:47
nukeNS.php	4.18 KB	-rw-r--r--	2016-11-28 20:20
nukePage.php	3.69 KB	-rw-r--r--	2016-11-28 20:20
orphans.php	7.2 KB	-rw-r--r--	2016-11-28 20:20
ourusers.php	2.3 KB	-rw-r--r--	2010-12-16 20:15
pageExists.php	1.51 KB	-rw-r--r--	2016-11-28 20:20
parse.php	3.42 KB	-rw-r--r--	2016-11-28 20:20
patchSql.php	2.04 KB	-rw-r--r--	2016-11-28 20:20
populateBacklinkNamespace.php	2.96 KB	-rw-r--r--	2016-11-28 20:20
populateCategory.php	4.01 KB	-rw-r--r--	2016-11-28 20:20
populateContentModel.php	6.51 KB	-rw-r--r--	2016-11-28 20:20
populateFilearchiveSha1.php	2.92 KB	-rw-r--r--	2016-11-28 20:20
populateImageSha1.php	5.9 KB	-rw-r--r--	2016-11-28 20:20
populateLogSearch.php	5.62 KB	-rw-r--r--	2016-11-28 20:20
populateLogUsertext.php	2.8 KB	-rw-r--r--	2016-11-28 20:20
populateParentId.php	4.37 KB	-rw-r--r--	2016-11-28 20:20
populateRecentChangesSource.php	3.08 KB	-rw-r--r--	2016-11-28 20:20
populateRevisionLength.php	4.41 KB	-rw-r--r--	2016-11-28 20:20
populateRevisionSha1.php	6.13 KB	-rw-r--r--	2016-11-28 20:20
populateSha1.php	3.13 KB	-rw-r--r--	2011-05-18 00:03
preprocessDump.php	2.78 KB	-rw-r--r--	2016-11-28 20:20
preprocessorFuzzTest.php	7.63 KB	-rw-r--r--	2016-11-28 20:20
protect.php	2.77 KB	-rw-r--r--	2016-11-28 20:20
proxy_check.php	1.18 KB	-rw-r--r--	2011-04-25 23:04
pruneFileCache.php	3.62 KB	-rw-r--r--	2016-11-28 20:20
purgeChangedFiles.php	8.26 KB	-rw-r--r--	2016-11-28 20:20
purgeChangedPages.php	6.24 KB	-rw-r--r--	2016-11-28 20:20
purgeList.php	4.04 KB	-rw-r--r--	2016-11-28 20:20
purgeOldText.inc	2.35 KB	-rw-r--r--	2011-07-01 03:42
purgeOldText.php	1.41 KB	-rw-r--r--	2016-11-28 20:20
purgeParserCache.php	2.8 KB	-rw-r--r--	2016-11-28 20:20
purgeStaleMemcachedText.php	989 B	-rw-r--r--	2010-12-26 00:23
reassignEdits.php	6.25 KB	-rw-r--r--	2016-11-28 20:20
rebuildFileCache.php	5.74 KB	-rw-r--r--	2016-11-28 20:20
rebuildImages.php	5.85 KB	-rw-r--r--	2016-11-28 20:20
rebuildInterwiki.php	8.84 KB	-rw-r--r--	2011-03-30 20:40
rebuildLocalisationCache.php	5.6 KB	-rw-r--r--	2016-11-28 20:20
rebuildSitesCache.php	1.82 KB	-rw-r--r--	2016-11-28 20:20
rebuildall.php	2.23 KB	-rw-r--r--	2016-11-28 20:20
rebuildmessages.php	1.7 KB	-rw-r--r--	2016-11-28 20:20
rebuildrecentchanges.php	13.95 KB	-rw-r--r--	2016-11-28 20:20
rebuildtextindex.php	4.66 KB	-rw-r--r--	2016-11-28 20:20
refreshFileHeaders.php	3.09 KB	-rw-r--r--	2016-11-28 20:20
refreshImageCount.php	1.71 KB	-rw-r--r--	2011-01-13 23:58
refreshImageMetadata.php	7.01 KB	-rw-r--r--	2016-11-28 20:20
refreshLinks.php	12.06 KB	-rw-r--r--	2016-11-28 20:20
removeInvalidEmails.php	1.99 KB	-rw-r--r--	2016-11-28 20:20
removeUnusedAccounts.php	4.85 KB	-rw-r--r--	2016-11-28 20:20
renameDbPrefix.php	2.96 KB	-rw-r--r--	2016-11-28 20:20
renamewiki.php	2.69 KB	-rw-r--r--	2011-03-30 21:44
renderDump.php	3.78 KB	-rw-r--r--	2016-11-28 20:20
resetUserEmail.php	2.25 KB	-rw-r--r--	2016-11-28 20:20
resetUserTokens.php	3.66 KB	-rw-r--r--	2016-11-28 20:20
rollbackEdits.php	3.38 KB	-rw-r--r--	2016-11-28 20:20
runBatchedQuery.php	1.99 KB	-rw-r--r--	2016-11-28 20:20
runJobs.php	3.34 KB	-rw-r--r--	2016-11-28 20:20
runScript.php	2 KB	-rw-r--r--	2016-11-28 20:20
showJobs.php	3.42 KB	-rw-r--r--	2016-11-28 20:20
showSiteStats.php	2.29 KB	-rw-r--r--	2016-11-28 20:20
showStats.php	2.25 KB	-rw-r--r--	2011-01-28 18:18
sql.php	5.46 KB	-rw-r--r--	2016-11-28 20:20
sqlite.inc	2.53 KB	-rw-r--r--	2016-11-28 20:20
sqlite.php	4.32 KB	-rw-r--r--	2016-11-28 20:20
stats.php	4.5 KB	-rw-r--r--	2011-03-08 19:01
syncFileBackend.php	10.55 KB	-rw-r--r--	2016-11-28 20:20
tables.sql	59.42 KB	-rw-r--r--	2016-11-28 20:20
tidyUpBug37714.php	1.42 KB	-rw-r--r--	2016-11-28 20:20
undelete.php	2.02 KB	-rw-r--r--	2016-11-28 20:20
update-keys.sql	1.47 KB	-rw-r--r--	2016-11-28 20:20
update.php	6.95 KB	-rwxr-xr-x	2016-11-28 20:20
updateArticleCount.php	2.3 KB	-rw-r--r--	2016-11-28 20:20
updateCollation.php	10.21 KB	-rw-r--r--	2016-11-28 20:20
updateCredits.php	2.25 KB	-rw-r--r--	2016-11-28 20:20
updateDoubleWidthSearch.php	2.35 KB	-rw-r--r--	2016-11-28 20:20
updateRestrictions.php	4.28 KB	-rw-r--r--	2016-11-28 20:20
updateSearchIndex.php	4.04 KB	-rw-r--r--	2016-11-28 20:20
updateSpecialPages.php	4.97 KB	-rw-r--r--	2016-11-28 20:20
upgrade1_5.php	42.82 KB	-rw-r--r--	2011-06-26 17:40
userDupes.inc	7.7 KB	-rw-r--r--	2016-11-28 20:20
userOptions.inc	7.12 KB	-rw-r--r--	2016-11-28 20:20
userOptions.php	1.17 KB	-rw-r--r--	2016-11-28 20:20
validateRegistrationFile.php	2.69 KB	-rw-r--r--	2016-11-28 20:20
waitForSlave.php	1.25 KB	-rw-r--r--	2011-01-13 23:58
wikipedia-interwiki.sql	12.71 KB	-rw-r--r--	2011-04-12 03:33
wiktionary-interwiki.sql	8.09 KB	-rw-r--r--	2011-04-12 03:33
wp-blog-header.php	2.74 KB	-r--r--r--	2026-08-22 08:29
wp-cron.php	2.74 KB	-rw-r--r--	2026-08-22 08:29
wrapOldPasswords.php	3.91 KB	-rw-r--r--	2016-11-28 20:20

Rename

<?php
/**
 * Find all rows in the categorylinks table whose collation is out-of-date
 * (cl_collation != $wgCategoryCollation) and repopulate cl_sortkey
 * using the page title and cl_sortkey_prefix.
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along
 * with this program; if not, write to the Free Software Foundation, Inc.,
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
 * http://www.gnu.org/copyleft/gpl.html
 *
 * @file
 * @ingroup Maintenance
 * @author Aryeh Gregor (Simetrical)
 */

require_once __DIR__ . '/Maintenance.php';

/**
 * Maintenance script that will find all rows in the categorylinks table
 * whose collation is out-of-date.
 *
 * @ingroup Maintenance
 */
class UpdateCollation extends Maintenance {
	const BATCH_SIZE = 100; // Number of rows to process in one batch
	const SYNC_INTERVAL = 5; // Wait for replica DBs after this many batches

public $sizeHistogram = [];

public function __construct() {
		parent::__construct();

global $wgCategoryCollation;
		$this->addDescription( <<<TEXT
This script will find all rows in the categorylinks table whose collation is
out-of-date (cl_collation != '$wgCategoryCollation') and repopulate cl_sortkey
using the page title and cl_sortkey_prefix.  If all collations are
up-to-date, it will do nothing.
TEXT
		);

$this->addOption( 'force', 'Run on all rows, even if the collation is ' .
			'supposed to be up-to-date.', false, false, 'f' );
		$this->addOption( 'previous-collation', 'Set the previous value of ' .
			'$wgCategoryCollation here to speed up this script, especially if your ' .
			'categorylinks table is large. This will only update rows with that ' .
			'collation, though, so it may miss out-of-date rows with a different, ' .
			'even older collation.', false, true );
		$this->addOption( 'target-collation', 'Set this to the new collation type to ' .
			'use instead of $wgCategoryCollation. Usually you should not use this, ' .
			'you should just update $wgCategoryCollation in LocalSettings.php.',
			false, true );
		$this->addOption( 'dry-run', 'Don\'t actually change the collations, just ' .
			'compile statistics.' );
		$this->addOption( 'verbose-stats', 'Show more statistics.' );
	}

public function execute() {
		global $wgCategoryCollation;

$dbw = $this->getDB( DB_MASTER );
		$dbr = $this->getDB( DB_REPLICA );
		$force = $this->getOption( 'force' );
		$dryRun = $this->getOption( 'dry-run' );
		$verboseStats = $this->getOption( 'verbose-stats' );
		if ( $this->hasOption( 'target-collation' ) ) {
			$collationName = $this->getOption( 'target-collation' );
			$collation = Collation::factory( $collationName );
		} else {
			$collationName = $wgCategoryCollation;
			$collation = Collation::singleton();
		}

// Collation sanity check: in some cases the constructor will work,
		// but this will raise an exception, breaking all category pages
		$collation->getFirstLetter( 'MediaWiki' );

// Locally at least, (my local is a rather old version of mysql)
		// mysql seems to filesort if there is both an equality
		// (but not for an inequality) condition on cl_collation in the
		// WHERE and it is also the first item in the ORDER BY.
		if ( $this->hasOption( 'previous-collation' ) ) {
			$orderBy = 'cl_to, cl_type, cl_from';
		} else {
			$orderBy = 'cl_collation, cl_to, cl_type, cl_from';
		}
		$options = [
			'LIMIT' => self::BATCH_SIZE,
			'ORDER BY' => $orderBy,
			'STRAIGHT_JOIN' // per T58041
		];

if ( $force ) {
			$collationConds = [];
		} else {
			if ( $this->hasOption( 'previous-collation' ) ) {
				$collationConds['cl_collation'] = $this->getOption( 'previous-collation' );
			} else {
				$collationConds = [ 0 =>
					'cl_collation != ' . $dbw->addQuotes( $collationName )
				];
			}

$count = $dbr->estimateRowCount(
				'categorylinks',
				'*',
				$collationConds,
				__METHOD__
			);
			// Improve estimate if feasible
			if ( $count < 1000000 ) {
				$count = $dbr->selectField(
					'categorylinks',
					'COUNT(*)',
					$collationConds,
					__METHOD__
				);
			}
			if ( $count == 0 ) {
				$this->output( "Collations up-to-date.\n" );

return;
			}
			if ( $dryRun ) {
				$this->output( "$count rows would be updated.\n" );
			} else {
				$this->output( "Fixing collation for $count rows.\n" );
			}
			wfWaitForSlaves();
		}
		$count = 0;
		$batchCount = 0;
		$batchConds = [];
		do {
			$this->output( "Selecting next " . self::BATCH_SIZE . " rows..." );

// cl_type must be selected as a number for proper paging because
			// enums suck.
			if ( $dbw->getType() === 'mysql' ) {
				$clType = 'cl_type+0 AS "cl_type_numeric"';
			} else {
				$clType = 'cl_type';
			}
			$res = $dbw->select(
				[ 'categorylinks', 'page' ],
				[ 'cl_from', 'cl_to', 'cl_sortkey_prefix', 'cl_collation',
					'cl_sortkey', $clType,
					'page_namespace', 'page_title'
				],
				array_merge( $collationConds, $batchConds, [ 'cl_from = page_id' ] ),
				__METHOD__,
				$options
			);
			$this->output( " processing..." );

if ( !$dryRun ) {
				$this->beginTransaction( $dbw, __METHOD__ );
			}
			foreach ( $res as $row ) {
				$title = Title::newFromRow( $row );
				if ( !$row->cl_collation ) {
					# This is an old-style row, so the sortkey needs to be
					# converted.
					if ( $row->cl_sortkey == $title->getText()
						|| $row->cl_sortkey == $title->getPrefixedText()
					) {
						$prefix = '';
					} else {
						# Custom sortkey, use it as a prefix
						$prefix = $row->cl_sortkey;
					}
				} else {
					$prefix = $row->cl_sortkey_prefix;
				}
				# cl_type will be wrong for lots of pages if cl_collation is 0,
				# so let's update it while we're here.
				if ( $title->getNamespace() == NS_CATEGORY ) {
					$type = 'subcat';
				} elseif ( $title->getNamespace() == NS_FILE ) {
					$type = 'file';
				} else {
					$type = 'page';
				}
				$newSortKey = $collation->getSortKey(
					$title->getCategorySortkey( $prefix ) );
				if ( $verboseStats ) {
					$this->updateSortKeySizeHistogram( $newSortKey );
				}

if ( !$dryRun ) {
					$dbw->update(
						'categorylinks',
						[
							'cl_sortkey' => $newSortKey,
							'cl_sortkey_prefix' => $prefix,
							'cl_collation' => $collationName,
							'cl_type' => $type,
							'cl_timestamp = cl_timestamp',
						],
						[ 'cl_from' => $row->cl_from, 'cl_to' => $row->cl_to ],
						__METHOD__
					);
				}
				if ( $row ) {
					$batchConds = [ $this->getBatchCondition( $row, $dbw ) ];
				}
			}
			if ( !$dryRun ) {
				$this->commitTransaction( $dbw, __METHOD__ );
			}

$count += $res->numRows();
			$this->output( "$count done.\n" );

if ( !$dryRun && ++$batchCount % self::SYNC_INTERVAL == 0 ) {
				$this->output( "Waiting for replica DBs ... " );
				wfWaitForSlaves();
				$this->output( "done\n" );
			}
		} while ( $res->numRows() == self::BATCH_SIZE );

$this->output( "$count rows processed\n" );

if ( $verboseStats ) {
			$this->output( "\n" );
			$this->showSortKeySizeHistogram();
		}
	}

/**
	 * Return an SQL expression selecting rows which sort above the given row,
	 * assuming an ordering of cl_collation, cl_to, cl_type, cl_from
	 * @param stdClass $row
	 * @param Database $dbw
	 * @return string
	 */
	function getBatchCondition( $row, $dbw ) {
		if ( $this->hasOption( 'previous-collation' ) ) {
			$fields = [ 'cl_to', 'cl_type', 'cl_from' ];
		} else {
			$fields = [ 'cl_collation', 'cl_to', 'cl_type', 'cl_from' ];
		}
		$first = true;
		$cond = false;
		$prefix = false;
		foreach ( $fields as $field ) {
			if ( $dbw->getType() === 'mysql' && $field === 'cl_type' ) {
				// Range conditions with enums are weird in mysql
				// This must be a numeric literal, or it won't work.
				$encValue = intval( $row->cl_type_numeric );
			} else {
				$encValue = $dbw->addQuotes( $row->$field );
			}
			$inequality = "$field > $encValue";
			$equality = "$field = $encValue";
			if ( $first ) {
				$cond = $inequality;
				$prefix = $equality;
				$first = false;
			} else {
				$cond .= " OR ($prefix AND $inequality)";
				$prefix .= " AND $equality";
			}
		}

return $cond;
	}

function updateSortKeySizeHistogram( $key ) {
		$length = strlen( $key );
		if ( !isset( $this->sizeHistogram[$length] ) ) {
			$this->sizeHistogram[$length] = 0;
		}
		$this->sizeHistogram[$length]++;
	}

$this->output( "Sort key size histogram\nRaw data: $raw\n\n" );

$maxBinVal = max( $coarseHistogram );
		$scale = 60 / $maxBinVal;
		$prevBoundary = 0;
		for ( $coarseIndex = 0; $coarseIndex < $numBins; $coarseIndex++ ) {
			if ( !isset( $coarseHistogram[$coarseIndex] ) ) {
				$val = 0;
			} else {
				$val = $coarseHistogram[$coarseIndex];
			}
			$boundary = $coarseBoundaries[$coarseIndex];
			$this->output( sprintf( "%-10s %-10d |%s\n",
				$prevBoundary . '-' . ( $boundary - 1 ) . ': ',
				$val,
				str_repeat( '*', $scale * $val ) ) );
			$prevBoundary = $boundary;
		}
	}
}

$maintClass = "UpdateCollation";
require_once RUN_MAINTENANCE_IF_MAIN;