Bug #18545 Reports incorrect number of rows in a table
Submitted: 27 Mar 2006 15:57 Modified: 28 Mar 2006 15:46
Reporter: Peter Roux Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.19 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[27 Mar 2006 15:57] Peter Roux 
Description:
The number of rows displayed for a table varies each time the refresh button is clicked within the "Schema Tables" page.

I have tested this a number of times with same result.  

It usually reports more rows than actually exists.  As an example, one of my tables has 11960 rows - and MySQL Administrator returns 12092 rows.  In MySQL Query 1.1.20 is reports correctly 11960 rows when doing "select count *"

How to repeat:
Select a database within MySQL Administator.  Note the total number of rows at bottom of page.

Click "Refreash".  Note difference in total number of rows.
[27 Mar 2006 17:53] MySQL Verification Team 
Thank you for the bug report.
Are you tables InnoDB enginer type?

http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html

SHOW TABLE STATUS does not give accurate statistics on InnoDB tables, except for the physical size reserved by the table. The row count is only a rough estimate used in SQL optimization.

Then MA just shows the result from SHOW TABLE STATUS.

Thank you in advance.
[28 Mar 2006 8:43] Peter Roux 
Hi Miguel.  Yes, the table is InnoDB.  Appologies is this has already been covered.  I did scan through existing bugs and could not find this being reported.

Thanks again for your help.

Peter Roux
[28 Mar 2006 15:46] MySQL Verification Team 
Thank you for the feedback. It is expected behavior since InnoDB
restriction.