Patch: https://gerrit.wikimedia.org/r/#/c/318553/22/maintenance/archives/patch-l10n_cache-primary-key.sql
DELETE FROM /*$wgDBprefix*/l10n_cache; -- Or truncate- truncate is faster but it has metadata locking issues ALTER TABLE /*$wgDBprefix*/l10n_cache DROP KEY /*i*/lc_lang_key, ADD PRIMARY KEY(lc_lang, lc_key)
All wikis. Nice to have, but not urgent (but should be easy). It may be already done on some wikis: T146591#3139282
Truncation done at: T150306
Schema change progress:
- s1
- codfw
- eqiad progress T146591#4407008
- s2
- codfw
- eqiad progress T146591#4403312
- s3
- codfw
- eqiad progress T146591#4414817
- s4
- codfw
- eqiad progress T146591#4408161
- s5
- codfw
- eqiad progress T146591#4398630
- s6
- codfw
- eqiad progress T146591#4402331
- s7
- codfw
- eqiad progress T146591#4410833
- s8
- codfw
- eqiad progress T146591#4410666