MySQL Bugs: #46422: Option to show more accurate Row Count in MySQL Administrator.

Bug #46422	Option to show more accurate Row Count in MySQL Administrator.
Submitted:	28 Jul 2009 4:22	Modified:	20 Oct 2009 6:01
Reporter:	Jeff Daye	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.17	OS:	Windows (Vista Home Premium )
Assigned to:		CPU Architecture:	Any
Tags:	administrator, inaccurate, rowcount, rows

Description:
When viewing the list of tables in a catalog on the 'Schema Tables' tab in MySQL Administrator, the column reporting the number of rows in a table is not accurate.  This does not seem to happen when tables have few rows ( <1000 ) , however it seems to always report the wrong rowcount on tables with several thousand rows.

How to repeat:
Open MySQL administrator and select a database catalog.  View the table list in the right-hand pane on the 'Schema Tables' tab and note the column labeled 'rows'.  Open up a MySQL command line client and run select count(*) queries to determine the actual rowcount for each table, then compare the difference.

Suggested fix:
Make it display the correct rowcount.

Thank you for the problem report. Please, check if all the tables with inaccurate row count are InnoDB ones. Check http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html also.

So far, I have only been able to reproduce this inaccurate rowcount when using the InnoDB engine.

Oops. I just read this:

The number of rows. Some storage engines, such as MyISAM, store the exact count. For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%. In such cases, use SELECT COUNT(*) to obtain an accurate count. 

I guess I just assumed that the Administrator front-end would report the actual rowcount rather than an approximation.  Feel free to move this to a feature request rather than a bug... Thanks... Jeff

It would be nice (in some cases) to have an option to use SELECT count(*) ... to determine the number of rows for the tables in MySQL Administrator.

Many thanks for writing a bug report. We are on the way to implement full functionality of
MySQL Administrator into MySQL Workbench. We won't fix this anymore.

Lots of functionalities of MySQL Administrator are already implemented in Workbench 5.2
which will get GA soon.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/

Bug #49483 was marked as a duplicate of this one.