Deployment of {T342854}
# **ALTERs to run:** https://gerrit.wikimedia.org/r/c/mediawiki/core/+/993147/1/maintenance/archives/patch-drop-cl_collation_ext.sql
## Maybe add "optimize table categorylinks;" to replicas to clean up the mess as well.
# **Where to run those changes:** all.dblist
# **When to run those changes:** any time
# **If the schema change is backwards compatible:** Yes
# **If the schema change has been tested already on some of the test/beta wikis:** beta cluster is running with the new schema
# **if the data should be made available on the labs replicas and/or dumps:** no change of the existing rules
Noting that categorylinks is quite large and drop of an index in such large tables can be risky. We searched everywhere and made sure it's not being used (and it's showing in list of unused indexes: {T342697}) but general precautions apply.
Progress
[] s1
** [] eqiad (pending master)
** [x] codfw
[x] s2
** [x] eqiad (pending master)
** [x] codfw
[] s3
** [] eqiad (pending master)
** [x] codfw
[] s4
** [] eqiad (pending master)
** [x] codfw
[] s5
** [] eqiad (pending master)
** [x] codfw
[] s6
** [] eqiad (pending master)
** [x] codfw
[] s7
** [] eqiad (running)
** [x] codfw
[] s8
** [] eqiad (pending master)
** [x] codfw
[x] labtestwiki