Add new index to make updateCollation.php painless
authorBrian Wolff <bawolff+wn@gmail.com>
Sun, 21 Feb 2016 21:59:14 +0000 (16:59 -0500)
committerKaldari <rkaldari@wikimedia.org>
Tue, 22 Mar 2016 22:32:52 +0000 (16:32 -0600)
commiteec016ece6d2b30addcdf3d3efcc2ba59b10e858
tree2680aa08db1d13542640112f2b15582835e99572
parentf62f84f1750ad75044aa3f116d48354e07b99e20
Add new index to make updateCollation.php painless

We want to update categories in order, to minimize disruption
to users. Previous indexes required a filesort to do this, which
exploded things on large wikis. See bug for details

Bug: T58041
Change-Id: Iee6cd997ff87a313a46fda19d8ab063d0fed8ce8
includes/installer/MysqlUpdater.php
includes/installer/SqliteUpdater.php
maintenance/archives/patch-add-cl_collation_ext_index.sql [new file with mode: 0644]
maintenance/archives/patch-categorylinks-better-collation.sql
maintenance/archives/patch-kill-cl_collation_index.sql [new file with mode: 0644]
maintenance/tables.sql
maintenance/updateCollation.php