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.
[ Parent
| on HN ]
There are no comments on this comment yet.