ID #1159

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

Please rate this FAQ:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

comment this FAQ

Your Name:
Your email address:
Your comment:

Please enter the characters you're reading in the image