After T190444: Add index on rc_namespace, rc_title, rc_timestamp on recentchanges table It would be great to apply this change
From the checklist at https://wikitech.wikimedia.org/wiki/Schema_changes:
- ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/450083/2/maintenance/archives/patch-recentchanges-rc_this_oldid-index.sql
- Where to run those changes: all.dblist
- When to run those changes: ?
- If the schema change is backwards compatible: Yes.
- If the schema change has been tested already on some of the test/beta wikis: Tested in beta cluster
- if the data should be made available on the labs replicas and/or dumps: Yes, data in this table is public (unless the wiki is private which we don't replicate at all)
One note: This index might be already existing but under name of tmp_1 or tmp_2 or tmp_3. I don't know how complex renaming an index is but that'd be useful.
Progress:
s1
- eqiad progress T202167#4848180
- codfw
s2
- eqiad progress T202167#4788212
- codfw
s3
- eqiad progress T202167#4822929
- codfw
s4
- eqiad progress T202167#4796465
- codfw
s5
- eqiad progress T202167#4793284
- codfw
s6
- eqiad progress T202167#4773117
- codfw progress T202167#4773117
s7
- eqiad progress T202167#4816251
- codfw
s8
- eqiad progress T202167#4809890
- codfw
wikitech
- eqiad
- codfw