Hello.
I've found a good answer of Heikki Tuuri:
InnoDB does not keep accurate row counts. They are only estimates based on 10
random dives into the clustered index tree.
See:
http://dev.mysql.com/doc/mysql/en/InnoDB_restrictions.html
Jeff Burgoon [EMAIL PROTECTED] wrote:
I have
I have table with 83,065 rows. Each time I go to MySQL Administrator and
look at the catalogs, the number of Rows reported by the administrator
changes. I can keep clicking refresh and the number of rows fluctuates
between roughly 81,000 and 86,000. I also see similar behavior when I
access the
It's because the table type is InnoDB. InnoDB tables can only give and
estimate of how many rows are in the table. That's just the way InnoDB
works.
From the manual:
SHOW TABLE STATUS does not give accurate statistics on InnoDB tables,
except for the physical size reserved by the table. The
Thanks. Makes sense ... but strange.
Jeff
Brent Baisley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
It's because the table type is InnoDB. InnoDB tables can only give and
estimate of how many rows are in the table. That's just the way InnoDB
works.
From the manual:
SHOW