Vladimir Prieto Muñoz wrote:
> Almost all tables on the DB has wrong total records. I get into one table and
> count by one all the records and it doesn't fit with the total of mysqlcc.
>
> Even more, i install phpMyAdmin and this one does show the correct total
> records of each table. So definitively it is a bug on MySQLCC.
No, phpMyAdmin must be using an inefficient workaround. It's a "bug" in
MySQL (I use quotes because it's intentional). Here's what the InnoDB
manual has to say about it (http://www.innodb.com/ibman.php):
"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."
--
Adam Hooper
adamh@stripped
