Deployment of {T342856}
# **ALTERs to run:** https://gerrit.wikimedia.org/r/c/mediawiki/core/+/995037/2/maintenance/archives/patch-sites-drop_indexes.sql
## Maybe add "optimize table sites;" just for the fun
# **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
Sites table has only 1000 rows and barely gets written (or read for that matter). I'd say just run it on master with replication.
```
DROP INDEX IF EXISTS site_type ON /*_*/sites;
DROP INDEX IF EXISTS site_group ON /*_*/sites;
DROP INDEX IF EXISTS site_source ON /*_*/sites;
DROP INDEX IF EXISTS site_language ON /*_*/sites;
DROP INDEX IF EXISTS site_protocol ON /*_*/sites;
DROP INDEX IF EXISTS site_domain ON /*_*/sites;
DROP INDEX IF EXISTS site_forward ON /*_*/sites;
```
Progress
[] s1
[x] s2
[] s3
[x] s4
[] s5
[x] s6
[x] s7
[x] s8
[x] labtestwiki