ID #1159

In INFO tab for a database the 'Rows' count for InnoDB tables does not show the exact value.

In INFO tab for a database the 'Rows' count for InnoDB tables does not show the exact value.

This is an InnoDB issue with the SHOW TABLE STATUS statement. With InnoDB tables the 'Rows' count is an estimate only. So it is not really a bug - it is expected behaviour wiht InnoDB tables.

To get exact values you can execute "select count(*) from ´table´" to get the correct row count (and the Avg_row_length which will be Data_length (from SHOW TABLE STATUS)/Rows).  But exact rows count on InnoDB can be very slow so we display the (not always exact) output for 'Rows' count from SHOW TABLE STATUS.

More information: http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

Tags: -

Related entries:

You can comment this FAQ