News for hackers. Stuff that matters.
Re:Reddit's database has only two tables by burke on Sunday September 02, 2012 @11:20PM (#4468982)
> It does not take locks, other than for very briefly.

A lock (even a very brief one) can be infeasible on a sufficiently high-traffic table, though there's always the possibility of, say, a 30-second maintenance window.

Mysql 5.5 supports atomic table switch, meaning no lock is necessary at all.

There are no comments on this comment yet.