- ALTER to run:
- https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/3911d67f716d4576be5e1e343d18ccfeda504afe/schema/mysql/patch-cu_changes-drop-cuc_ip.sql
- https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/3911d67f716d4576be5e1e343d18ccfeda504afe/schema/mysql/patch-cu_changes-drop-cuc_agent.sql
- https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/3911d67f716d4576be5e1e343d18ccfeda504afe/schema/mysql/patch-cu_log_event-drop-cule_ip.sql
- https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/3911d67f716d4576be5e1e343d18ccfeda504afe/schema/mysql/patch-cu_log_event-drop-cule_agent.sql
- https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/3911d67f716d4576be5e1e343d18ccfeda504afe/schema/mysql/patch-cu_private_event-drop-cupe_ip.sql
- https://gerrit.wikimedia.org/r/plugins/gitiles/mediawiki/extensions/CheckUser/+/3911d67f716d4576be5e1e343d18ccfeda504afe/schema/mysql/patch-cu_private_event-drop-cupe_agent.sql
DROP INDEX cuc_actor_ip_time ON cu_changes; ALTER TABLE cu_changes DROP cuc_ip; ALTER TABLE cu_changes DROP cuc_agent; DROP INDEX cule_actor_ip_time ON cu_log_event; ALTER TABLE cu_log_event DROP cule_ip; ALTER TABLE cu_log_event DROP cule_agent; DROP INDEX cupe_actor_ip_time ON cu_private_event; ALTER TABLE cu_private_event DROP cupe_ip; ALTER TABLE cu_private_event DROP cupe_agent;
- Where to run those changes: all.dblist
- When to run those changes: When DBA has time
- If the schema change is backwards compatible: No, but we are dropping columns that are no longer written to or read from
- If the schema change has been tested already on some of the test/beta wikis: CheckUser is not on the beta cluster, but have tested these changes locally
- If the data should be made available on the labs replicas and/or dumps: No changes needed (all of these tables should remain private)
Progress
- s1
- codfw
- eqiad
- s2
- codfw
- eqiad
- s3
- codfw
- eqiad
- s4
- codfw
- eqiad
- s5
- codfw
- eqiad
- s6
- codfw
- eqiad
- s7
- codfw
- eqiad
- s8
- codfw
- eqiad