Bug #43777 Problem with counting rows in MySQL Administrator (INNODB Only)
Submitted: 21 Mar 2009 7:54 Modified: 21 Mar 2009 15:36
Reporter: Marcin Bandrowski Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.16 OS:Windows (XP and Vista 64)
Assigned to: CPU Architecture:Any
Tags: administrator, count, rows

[21 Mar 2009 7:54] Marcin Bandrowski 
Description:
In MySQL Administrator > CATALOGLS > schemata > 'some_innodb_schema' > TAB Schema Tables > GRID (Table Name, Engine Rows ...)

Number of rows for InnoDB tables (few thousand and more records in table) is wrong. More: when i click "Refresh" button, number of rows for this tables changes every time.

How to repeat:
-
[21 Mar 2009 15:36] Valeriy Kravchuk 
Sorry, but this is not a bug. Estimated (not precise) number of rows is taken from SHOW TABLE STATUS (not from SELECT count(*)...). And it is documented as not precise. See http://dev.mysql.com/doc/refman/5.1/en/show-table-status.html:

"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. "