Page MenuHomePhabricator
Create Task
Maniphest T193874

Add new indexes to change_tag table using ct_tag_id instead of ct_tag
Closed, ResolvedPublic
Actions

Description

Fourth part of the normalizing change_tag schema: T185355: Normalize change tag schema

  • Add new indexes using ct_tag_id instead of ct_tag, including unique indexes on (ct_{rc,log,rev}_id, ct_tag_id).

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Schema change for reading ct_tag_id instead of ct_tagmediawiki/coremaster+179 -24
Customize query in gerrit

Related Objects
Search...

Event Timeline

Ladsgroup created this task.May 4 2018, 1:36 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 4 2018, 1:36 PM
Lucas_Werkmeister_WMDE mentioned this in T185355: Normalize change tag schema.May 8 2018, 2:27 PM
Lucas_Werkmeister_WMDE added a project: Wikidata-Campsite.Jun 5 2018, 1:37 PM
• Vvjjkkii renamed this task from Add new indexes to change_tag table using ct_tag_id instead of ct_tag to xldaaaaaaa.Jul 1 2018, 1:11 AM
• Vvjjkkii triaged this task as High priority.
• Vvjjkkii added projects: CheckUser, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), Tamil-Sites, Gamepress, Hashtags, Jade, KartoEditor, Language-2018-Apr-June, New-Editor-Experiences, Mail, TCB-Team (now WMDE-TechWish).
• Vvjjkkii updated the task description. (Show Details)
• Vvjjkkii removed a subscriber: Aklapper.
CommunityTechBot renamed this task from xldaaaaaaa to Add new indexes to change_tag table using ct_tag_id instead of ct_tag.Jul 2 2018, 4:28 PM
CommunityTechBot raised the priority of this task from High to Needs Triage.
CommunityTechBot updated the task description. (Show Details)
CommunityTechBot removed projects: TCB-Team (now WMDE-TechWish), Mail, New-Editor-Experiences, Language-2018-Apr-June, KartoEditor, Jade, Hashtags, Gamepress, Tamil-Sites, Connected-Open-Heritage-Batch-uploads (RAÄ-KMB_1_2017-02), CheckUser.
CommunityTechBot added a subscriber: Aklapper.
Krinkle moved this task from Untriaged to Schema changes on the MediaWiki-libs-Rdbms board.Jul 28 2018, 10:39 PM
gerritbot subscribed.Aug 28 2018, 9:34 PM

Change 456027 had a related patch set uploaded (by Ladsgroup; owner: Amir Sarabadani):
[mediawiki/core@master] Schema change for reading ct_tag_id instead of ct_tag

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

gerritbot added a project: Patch-For-Review.Aug 28 2018, 9:34 PM
Ladsgroup edited projects, added Wikidata-Campsite (Wikidata-Campsite-Iteration-∞ (On Hold)); removed Wikidata-Ministry-Of-Magic.Aug 28 2018, 10:27 PM
Ladsgroup claimed this task.Aug 30 2018, 12:51 PM
Ladsgroup moved this task from To Do (prioritised from top to bottom) to Peer Review on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞ (On Hold)) board.
Restricted Application added a project: User-Ladsgroup. · View Herald TranscriptAug 30 2018, 12:51 PM
gerritbot added a comment.Sep 6 2018, 7:16 PM

Change 456027 merged by jenkins-bot:
[mediawiki/core@master] Schema change for reading ct_tag_id instead of ct_tag

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

Ladsgroup mentioned this in T203709: Schema change for adding indexes of ct_tag_id.Sep 6 2018, 7:45 PM
Ladsgroup moved this task from Peer Review to Done on the Wikidata-Campsite (Wikidata-Campsite-Iteration-∞ (On Hold)) board.
ReleaseTaggerBot added a project: MW-1.32-notes (WMF-deploy-2018-09-18 (1.32.0-wmf.22)).Sep 6 2018, 8:00 PM
Lydia_Pintscher closed this task as Resolved.Sep 16 2018, 10:38 AM
Addshore removed a project: Wikidata-Campsite.Nov 1 2018, 11:21 AM
Marostegui closed subtask T203709: Schema change for adding indexes of ct_tag_id as Resolved.Nov 14 2018, 8:03 AM
Aklapper removed a subscriber: Anomie.Oct 16 2020, 5:39 PM
Restricted Application added a project: Wikidata. · View Herald TranscriptOct 16 2020, 5:39 PM
Maintenance_bot removed a project: Patch-For-Review.Oct 16 2020, 6:20 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 · Credits