Bug #3040 SHOW TABLE STATUS report incorrect row number in InnoDB tables
Submitted: 2 Mar 2004 9:08 Modified: 2 Mar 2004 9:26
Reporter: Dmitry Nikiforov Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:4.0.17, 4.0.18 OS:Linux (Linux)
Assigned to: Dean Ellis CPU Architecture:Any

[2 Mar 2004 9:08] Dmitry Nikiforov 
Description:
'show table status' reports incorrect number of rows in InnoDB tables. If you keep executing this query, the number of rows reported will always be different (though it's close to the real number).

How to repeat:
Execute 'show table status' query multiple times on database that has InnoDB tables in it. Check if the number of rows is correct.
[2 Mar 2004 9:26] Dean Ellis 
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:

There is a comment about this in the manual:

http://www.mysql.com/doc/en/Using_InnoDB_tables.html