Page MenuHomePhabricator
Create Task
Maniphest T114654

[Task] Delete by primary key in EntityUsageTable::pruneStaleUsages and EntityUsageTable::removeEntities
Closed, ResolvedPublic
Actions

Description

Might help reduce the locks on that table. See also T111769.

Details

Related Changes in Gerrit:
SubjectAuthorRepoBranchLines +/-
Remove UsageTracker::removeEntities and all implementationsHoo manmediawiki/extensions/Wikibasemaster+0 -160
Batch the query and delete by primary key in EntityUsageTable::pruneStaleUsagesHoo manmediawiki/extensions/Wikibasemaster+25 -9
Customize query in gerrit

Related Objects

Event Timeline

hoo created this task.Oct 5 2015, 3:49 PM
hoo raised the priority of this task from to High.
hoo updated the task description. (Show Details)
hoo added projects: Wikidata, MediaWiki-extensions-Wikibase-Client, Performance Issue.
hoo added subscribers: hoo, daniel.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 5 2015, 3:49 PM
gerritbot subscribed.Oct 5 2015, 5:17 PM

Change 243696 had a related patch set uploaded (by Hoo man):
Batch the query and delete by primary key in EntityUsageTable::pruneStaleUsages

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

gerritbot added a project: Patch-For-Review.Oct 5 2015, 5:17 PM
gerritbot added a comment.Oct 5 2015, 5:33 PM

Change 243699 had a related patch set uploaded (by Hoo man):
Remove UsageTracker::removeEntities and all implementations

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

gerritbot added a comment.Oct 7 2015, 4:19 PM

Change 243696 merged by jenkins-bot:
Batch the query and delete by primary key in EntityUsageTable::pruneStaleUsages

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

Diffusion mentioned this in rMEXTe6e797273470: Updated mediawiki/extensions Project: mediawiki/extensions/Wikibase….Oct 7 2015, 4:19 PM
hoo mentioned this in rEWBAefd4ace6760a: Batch the query and delete by primary key in EntityUsageTable::pruneStaleUsages.Oct 7 2015, 4:19 PM
gerritbot added a comment.Oct 13 2015, 5:19 PM

Change 243699 merged by jenkins-bot:
Remove UsageTracker::removeEntities and all implementations

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

JanZerebecki closed this task as Resolved.Oct 13 2015, 7:31 PM
JanZerebecki added a project: Wikidata-Sprint-2015-10-13.
JanZerebecki set Security to None.
JanZerebecki moved this task from Proposed to Done on the Wikidata-Sprint-2015-10-13 board.
hoo claimed this task.Oct 14 2015, 9:44 AM
hoo removed a project: Patch-For-Review.
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