MySQL Bugs: #9142: Wrong number of rows indicated for InnoDB tables

Bug #9142	Wrong number of rows indicated for InnoDB tables
Submitted:	12 Mar 2005 12:31	Modified:	12 Mar 2005 15:56
Reporter:	Adrian Murariu
Status:	Not a Bug
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.19	OS:	Microsoft Windows (Windows 2000 Professional)
Assigned to:		Target Version:

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

Description:
On catalog view, each table has a number of rows reported. For InnoDB tables with more
than 40.000 rows, succesive Refresh button will show you different number of rows even if
no clients are accessing server. Bug observed on my PC, I am the only user.

How to repeat:
Just look at rows number for tables and click several times Refresh button

Hi!

For InnoDB SHOW TABLE STATUS indeed shows an estimate, calculated from 8 dives into the
clustered index tree. This is documented in the manual.

Regards,

Heikki