MySQL Forums
Forum List  »  InnoDB

Re: Changing table engine to innodb manually
Posted by: Peter Brawley
Date: January 14, 2021 11:29PM

Upgrading tables to InnoDB will provide much better optimisation opportunities.

If you follow that path, you should set up a copy of the production system, do the Alter Table commands there, turn on the slow query log,increase innodb_buffer_pool_size to perhaps 2GB, optimise the slow queries, add transactional logic where appropriate, regression test, then replicate those changes on the production system in off-peak hours.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Changing table engine to innodb manually
80
January 14, 2021 11:29PM


Sorry, only registered users may post in this forum.

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.