Re: 1,000,000 Rows showing as 1,000,224
This is because MySQL Administrator gets the number of rows from the table_rows column in the information_schema.tables table. For InnoDB, this is not a 100% accurate count as it divides the total size of the table by the average row size to get the count. This is mentioned in the InnoDB documentation. This is true for MySQL 5.0, might have been changed in 5.1.
Subject
Views
Written By
Posted
2295
November 28, 2008 03:29AM
Re: 1,000,000 Rows showing as 1,000,224
1754
December 01, 2008 01:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.