When I try to SHOW TABLE STATUS FROM $TABLENAME some of the tables have the 'Rows' = 0 even when it has a row (mostly when it has only 1 row)
SQL: SHOW TABLE STATUS FROM $TABLENAME "Rows" value is 0 even if it has a row
Viewed 17
1 Answers
InnoDB doesn't keep the row count up to date. as this great man mentioned in the comment.
Related