Deployment of T342856: Drop random indexes of sites table
- 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
- s2
- s3
- s4
- s5
- s6
- s7
- s8
- labtestwiki