MySQL Forums
Forum List  »  MyISAM

Re: convert myisam to innodb - table status
Posted by: Rick James
Date: December 05, 2012 12:26AM

It will take hours.

All writes to the table will be blocked for the entire time.

A temporary InnoDB will be created, the data will be copied into it, and as a final (and quick) step, there will be a RENAME TABLE to switch out the old table and bring in the new.

With a table that large, you should be careful with the datatypes and indexes. See http://mysql.rjweb.org/doc.php/myisam2innodb
Also, if you like, provide SHOW CREATE TABLE and some of the SELECTs so we can help you make the resulting table successful.

I assume you have already discovered that the new table is 300-450GB. Either that, or you ran out of disk space, losing the new table, but hopefully leaving the old table intact.

Options: ReplyQuote


Subject
Views
Written By
Posted
3019
December 03, 2012 06:09AM
Re: convert myisam to innodb - table status
1677
December 05, 2012 12:26AM


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.