InnoDB I_S.tables.table_rows out by a factor of 100x

• Ronald Bradford
• September 9, 2009

I’ve always believed that the MySQL Information_schema.tables.table_rows figure for Innodb tables to be while approximate, approximately accurate. Today I found that the figures varied on one table from 10x to 100x wrong.