Bug #4061 number of tables rows changes when refreshing

• Submitted: 8 Jun 2004 16:27
• Modified: 8 Jun 2004 16:39
• Reporter: Mickael Besson
• Status: Not a Bug
• Category: MySQL Administrator
• Severity: S2 (Serious)
• Version: 1.0.5 beta
• OS: Windows (Windows NT4)
• CPU Architecture: Any

[8 Jun 2004 16:27] Mickael Besson

Description:

Hi,

I inform you that number of tables (and so the database sum) rows isn't correct, and change (I am the only one connected) when I click 'refresh' button.
It's funny but not very justified ;-)

How to repeat:

Catalogs -> nb of rows isnt't always correct

Catalogs/'Refresh' Button -> nb has changed !

Suggested fix:

verying count(*) or other method to obtain number of rows

[8 Jun 2004 16:39] Heikki Tuuri

Hi!

If these are InnoDB tables, then the behavior you are describing is quite normal.

For InnoDB tables, SHOW TABLE STATUS calculates an estimate on the row count, based on 8 random dives into the clustered index tree.

Best rergards,

Heikki