Hsiu-Hui Tseng wrote:
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
I think the row count that you get from 'show table status' is a guess
for innodb. Ignore it. If select count(*) from table shows the right
number, you're OK.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
