MySQL Forums
Forum List  »  Data Warehouse

converting from InnoDB to MyISAM
Posted by: shyam ahuja
Date: June 08, 2010 03:08PM

Hi,

I am converting my tables from InnoDB to MyISAM using Alter table command. one table which was 23000 records took few seconds to convert. I have other table which is approximately 220 million records, alter command is running since 5 days now and not finished yet. Is this a right behavior? Is there way to find out how much data is converted and if the script is really running and not hung somewhere?

thanks,
shyam

Options: ReplyQuote


Subject
Views
Written By
Posted
converting from InnoDB to MyISAM
8837
June 08, 2010 03:08PM
3744
August 25, 2010 09:02AM


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.