Page MenuHomePhabricator

Add a <reviewer, revision> key to the reviewers table
ClosedPublic

Authored by epriestley on Mar 22 2017, 2:00 PM.
Tags
None
Referenced Files
F15430709: D17532.diff
Mon, Mar 24, 8:37 AM
F15429277: D17532.id42174.diff
Mon, Mar 24, 1:29 AM
F15409562: D17532.id42174.diff
Wed, Mar 19, 4:42 AM
F15408733: D17532.id42174.diff
Wed, Mar 19, 12:56 AM
F15377301: D17532.id42174.diff
Thu, Mar 13, 8:34 AM
F15337126: D17532.id42169.diff
Sun, Mar 9, 4:16 AM
F15333447: D17532.id42174.diff
Sat, Mar 8, 2:23 AM
Unknown Object (File)
Fri, Feb 28, 12:21 PM
Subscribers
None

Details

Summary

Ref T10967. I'm not 100% sure we need this, but the old edge table had it and I recall an issue long ago where not having this key left us with a bad query plan.

Our data doesn't really provide a way to test this key (we have many revisions and few reviewers, so the query planner always uses revision keys), and building a convincing test case would take a while (lipsum needs some improvements to add reviewers). But in the worst case this key is mostly useless and wastes a few MB of disk space, which isn't a big deal.

So I can't conclusively prove that this key does anything to the dashboard query, but the migration removed it and I'm more comfortable keeping it so I'm not worried about breaking stuff.

At the very least, MySQL does select this key in the query plan when I do a "Reviewers:" query explicitly so it isn't useless.

Test Plan

Ran bin/storage upgrade, ran dashboard query, the query plan didn't get any worse.

Diff Detail

Repository
rP Phabricator
Branch
key1
Lint
Lint Passed
Unit
Tests Passed
Build Status
Buildable 16084
Build 21341: Run Core Tests
Build 21340: arc lint + arc unit

Event Timeline

This revision is now accepted and ready to land.Mar 22 2017, 3:24 PM
This revision was automatically updated to reflect the committed changes.