#1090 InnoDB row count is not exact using Show Tables

[Anonymous]

Originally created by: graveen....@gmail.com

What is the problem that needs to be solved (required)?
On the list of the tables, the rows count on InnoDB engine table is not
correct.
This is a know behaviour, http://bugs.mysql.com/bug.php?id=127 , the count
is estimated, not determined.

What is the idea in abstract terms (optional)?
Get rid of this estimation that is really not what we should expect from a
recent DB engine.

What is a practical way to implement this idea (optional)?
Allow precise InnoDB rows count in executing the SELECT COUNT(*) statement;
as it is done in preferences (use SHOW TABLES instead of SHOW TABLE
STATUS), add a radio to use SELECT COUNT(*).

[Anonymous]

Originally posted by: a...@anse.de

SELECT COUNT(*) has a huge impact on performance as dicussed in issue #940. That
issue was worked around recently with huge effort, so I tend to dislike adding
another workaround which works the other way (although in a different place)

[Anonymous]

Originally posted by: rosenfie...@gmail.com

(No comment was entered for this change.)

Status: Accepted

[Anonymous]

Originally posted by: a...@anse.de

Won't ever happen...

Status: Upstream