HomePhabricator

Reduce disruption during updateCollation.php

Authored by tstarling.

Description

Reduce disruption during updateCollation.php

Have updateCollation.php order by cl_to, so that each category is
updated all at once. This minimises the time during which a category
will appear to be incorrectly sorted, while the maintenance script is in
progress.

Mark the cl_collation index as needing deletion, it was always pretty
pointless. You can't do much better than a full table scan when you're
changing the collation value on a wiki.

Increase the batch size since the lack of a cl_to,cl_from index means
that it will have to filesort each category. A larger batch size means
less sorts. As noted by Liangent on bug 45970, you can't order by
cl_sortkey since that will change during execution.

Also fix an inappropriate use of $wgMiserMode and remove a no-op from
the SET clause of the UPDATE.

Very lightly tested.

Change-Id: I19bc8d6701f5f78040aa9c521427ac98ef488d89

Details

Committed
Gerrit Code ReviewMar 12 2013, 11:08 PM
Parents
rMWf9f32542f121: Merge "Localisation updates from http://translatewiki.net."
Branches
Unknown
Tags
Unknown
ChangeId
I19bc8d6701f5f78040aa9c521427ac98ef488d89