Page MenuHomePhabricator

Daemon worker garbage collector executes query with inefficient key usage
Closed, ResolvedPublic

Description

The Daemon garbage collect runs a query like this:

SELECT * FROM table WHERE dateCreated < X ORDER BY id DESC LIMIT 100

On a huge table, this can't use either the <dateCreated> or <id> keys efficiently. Changing it to ORDER BY dateCreated DESC, id DESC should improve things.

In the cluster, an instance imported the linux kernel, then we ran into trouble 7 days later when GC started.

Revisions and Commits

Restricted Differential Revision

Event Timeline

epriestley raised the priority of this task from to Normal.
epriestley updated the task description. (Show Details)
epriestley added projects: Phacility, Daemons.
epriestley added a subscriber: epriestley.
epriestley added a revision: Restricted Differential Revision.Nov 18 2015, 1:02 AM
epriestley closed this task as Resolved by committing Restricted Diffusion Commit.Nov 18 2015, 1:05 AM
epriestley added a commit: Restricted Diffusion Commit.