Bug #4449 Row counts in SHOW TABLE STATUS keep changing even if table is not changed

• Submitted: 8 Jul 2004 1:39
• Modified: 8 Jul 2004 9:08
• Reporter: Thomas Kleffel
• Status: Duplicate
• Category: MySQL Server: InnoDB storage engine
• Severity: S2 (Serious)
• Version: 4.1.3-beta-max
• OS: Linux (gentoo-linux i386)
• CPU Architecture: Any

[8 Jul 2004 1:39] Thomas Kleffel

Description:
Each time I execute SHOW TABLE STATUS, the row counts reported for my InnoDB-Tables change though I haven't changed anything on that table. Even the server-statistics confirm that no querys other than my SHOW TABLE STATUS have been issued.

The values I get seem to be somewhat relatet to the real number of rows in the table. For example a table with about 8500 rows reports 8671,8233,8349,... and another table with about 90000 rows reports like 91344,86341,93234,...

Aside from that the tables seem to work fine. No data is lost.

How to repeat:
Not sure - happens to all my InnoDB tables

Suggested fix:
Make the engine report the correct number of rows.

[8 Jul 2004 9:08] Sergei Golubchik

Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

This "bug" is reported many times already. Check

http://bugs.mysql.com/bug.php?id=127
http://bugs.mysql.com/bug.php?id=633
http://bugs.mysql.com/bug.php?id=3040
http://bugs.mysql.com/bug.php?id=4396