Re: MySQL 4.1 to 5.1 large scale upgrade
Posted by: Rick James
Date: March 23, 2011 07:36PM

MyISAM creates the .MYI file even if there are no indexes. I suspect it keeps other dynamic information there, perhaps including the current number of rows in the table. It sounds as if the developers put a version number in the .MYI and blindly use that to require REPAIR, even if the actual reasons for the REPAIR may not apply in a particular case.

Thanks for the OS info.

Options: ReplyQuote

Written By
Re: MySQL 4.1 to 5.1 large scale upgrade
March 23, 2011 07:36PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.