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.
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.