Page MenuHomePhabricator
Create Task
Maniphest T190444

Add index on rc_namespace, rc_title, rc_timestamp on recentchanges table
Closed, ResolvedPublic
Actions

Description

Based on the discussion on this patch

Details

SubjectRepoBranchLines +/-
Change index on rc_namespace, rc_title to rc_namespace, rc_title, rc_timestampmediawiki/coremaster+44 -5
Customize query in gerrit

Related Objects
Search...

Event Timeline

Ladsgroup triaged this task as Low priority.Mar 22 2018, 7:43 PM
Ladsgroup created this task.
Restricted Application removed a project: Patch-For-Review. · View Herald TranscriptMar 22 2018, 7:43 PM
gerritbot added a comment.Mar 22 2018, 7:47 PM

Change 421372 had a related patch set uploaded (by Ladsgroup; owner: Amir Sarabadani):
[mediawiki/core@master] Change index on rc_namespace, rc_title to rc_namespace, rc_title, rc_timestamp

https://gerrit.wikimedia.org/r/421372

gerritbot added a project: Patch-For-Review.Mar 22 2018, 7:47 PM
Ladsgroup moved this task from Tasks to Needs Review on the Wikidata-Ministry-Of-Magic board.Mar 22 2018, 7:48 PM
• Jonas moved this task from Needs Review to In Progress on the Wikidata-Ministry-Of-Magic board.Mar 26 2018, 9:46 AM
Ladsgroup moved this task from In Progress to Needs Review on the Wikidata-Ministry-Of-Magic board.Mar 26 2018, 11:34 AM
hoo moved this task from Needs Review to In Progress on the Wikidata-Ministry-Of-Magic board.Apr 3 2018, 7:11 PM
Ladsgroup moved this task from In Progress to Needs Review on the Wikidata-Ministry-Of-Magic board.Apr 4 2018, 7:32 AM
gerritbot added a comment.Apr 4 2018, 7:45 PM

Change 421372 merged by jenkins-bot:
[mediawiki/core@master] Change index on rc_namespace, rc_title to rc_namespace, rc_title, rc_timestamp

https://gerrit.wikimedia.org/r/421372

ReleaseTaggerBot added a project: MW-1.31-release-notes (WMF-deploy-2018-04-10 (1.31.0-wmf.29)).Apr 4 2018, 8:00 PM
hoo removed a project: Patch-For-Review.Apr 4 2018, 8:11 PM
hoo moved this task from Needs Review to Done on the Wikidata-Ministry-Of-Magic board.
hoo subscribed.

The next step here is to request changing the index in production.

Ladsgroup mentioned this in T191519: Schema change for rc_namespace_title_timestamp index.Apr 5 2018, 11:33 AM
Lucas_Werkmeister_WMDE closed this task as Resolved.Apr 9 2018, 2:26 PM

Closing this task, since we have a separate task for applying the schema change in production.

Ladsgroup mentioned this in T194302: Schema change for new change_tag_def.May 9 2018, 6:47 PM
Ladsgroup mentioned this in T195193: Schema change for ct_tag_id field to change_tag.May 20 2018, 11:46 AM
• Marostegui closed subtask T191519: Schema change for rc_namespace_title_timestamp index as Resolved.May 28 2018, 9:07 AM
Ladsgroup mentioned this in T202167: Schema change for rc_this_oldid index.Aug 17 2018, 9:07 PM
Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:43 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL