MySQL Forums
Forum List  »  InnoDB

Re: Changing table engine to innodb manually
Posted by: Mohammad Mohammad
Date: January 15, 2021 03:50AM

Thanks a ton for your response.I will arrange testing as you suggested.

For the timebeing,if I want to get a little bit performance relief by changing all the table using:

ALTER TABLE table_name ENGINE=InnoDB; And,want to see how it behaves, will this be safe??? I meant is there any risk to change engine for table other than performance??

If there is any problem, than we can rollback to MyISAM.


Options: ReplyQuote

Written By
Re: Changing table engine to innodb manually
January 15, 2021 03:50AM

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.