Thank you. So, the Rows in show table status is meaningless.
One more question, the data_length for small table in show table status are all 16384, even the tabel without any data? thank you again Hsiu-Hui -----Original Message----- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:05 PM To: Hsiu-Hui Tseng; [EMAIL PROTECTED] Subject: Re: migrate data from myisam to innoDB 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
