Hello, I migrated all my tables to innoDB from MyIsam. After migrated, I ran "Show TAble Status". Why the row count is change.
In MyIsam table status.rows = 316202 the new InnoDB table status.rows = 287341 When doing select count(*) from TABLE. I go 316202 rows. Why this happening? Is there any way to correct the rows count in innoDB table status. thanks Hsiu-Hui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]