MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

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.

Regards,

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Changing table engine to innodb manually
817
Mohammad Hossain
January 14, 2021 07:45AM
Re: Changing table engine to innodb manually
387
Peter Brawley
January 14, 2021 12:08PM
Re: Changing table engine to innodb manually
380
Mohammad Mohammad
January 14, 2021 09:07PM
Re: Changing table engine to innodb manually
400
Peter Brawley
January 14, 2021 11:29PM
Re: Changing table engine to innodb manually
326
Peter Brawley
January 15, 2021 12:35PM
Re: Changing table engine to innodb manually
417
Mohammad Mohammad
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.