This requires to actually rework updateCollation.php maint script to iterate over batches of cl_from.
I did codesearch and didn't find any case that they would need this index in code.
Description
Description
Details
Details
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Schema: Drop cl_collation_ext index | mediawiki/core | master | +204 -17 | |
| updateCollation: Simplify and redo how batching works | mediawiki/core | master | +16 -87 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Ladsgroup | T342697 Audit of unused indexes, 2023 | |||
| Resolved | Ladsgroup | T342854 Drop cl_collation_ext index from categorylinks |
Event Timeline
Comment Actions
Change 991418 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@master] updateCollation: Simplify and redo how batching works
Comment Actions
Categorylinks in commons is 210GB now. This needs to be done like yesterday. (One of this Q's OKR)
Comment Actions
Change 991418 merged by jenkins-bot:
[mediawiki/core@master] updateCollation: Simplify and redo how batching works
Comment Actions
Change 993147 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@master] Schema: Drop cl_collation_ext index
Comment Actions
Change 993147 merged by jenkins-bot:
[mediawiki/core@master] Schema: Drop cl_collation_ext index