News for hackers. Stuff that matters.
Re:MySQL and partitioning tables with millions of rows by jfarmer on Sunday January 31, 2010 @04:53PM (#1091171)
Sort of true -- for the InnoDB engine SELECT COUNT(*) FROM table is more complicated because each transaction has its own view of the table. So unlike MyISAM (which uses one big table-level lock to guarantee consistency), it can't store a row count on a per-table basis.

There are no comments on this comment yet.