The numbers reported by SHOW TABLE STATUS in the case of an InnoDb table are *approximate*, not the real count.
"Note that the statistics SHOW gives about InnoDB tables are only approximate: they are used in SQL optimization. Table and index reserved sizes in bytes are accurate, though. " See section 4 of the InnoDb manual. http://www.innodb.com/ibman.html Hope this helps ===== ------------------------- Benoit St-Jean [EMAIL PROTECTED] Yahoo! Messenger: bstjean http://cactus.swiki.net ------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php