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]

Reply via email to