News for hackers. Stuff that matters.
Re:Loading half a billion rows into MySQL by lann on Tuesday June 05, 2012 @07:54PM (#4071625)
(another Causes engineer here) HASH partitioning could make sense if our queries were primarily filtering on e.g. user_id, but that isn't the case here. Instead we are often querying against one or both of two columns: user_id and action_id. Partitioning by timestamp allows us to ignore partitions older than the user and/or action's creation dates.

There are no comments on this comment yet.