Bug #4396 Show table status is inaccurate with InnoDB tables
Submitted: 3 Jul 2004 18:13 Modified: 3 Jul 2004 18:29
Reporter: Nickolai Nielsen Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:4.0.18-nt OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[3 Jul 2004 18:13] Nickolai Nielsen 
Description:
After converting tables to InnoDB the table status seems to be inaccurate, i noticed it by doing a count(*), and looking at the rows reported by show table status.

I use the "Show Table Status" to compare 2 mysql servers doing replication, and this problem began when some of the tables was converted to InnoDB, with MyISAM it works fine.

How to repeat:
do a count(*) on a table and compare to show table status
[3 Jul 2004 18:28] Nickolai Nielsen 
doh, you already know this
[3 Jul 2004 18:29] Paul DuBois 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

For InnoDB, the row count is an approximation.
I'll note this in the manual.