Re: Changing table engine to innodb manually
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.
Subject
Views
Written By
Posted
796
January 14, 2021 07:45AM
379
January 14, 2021 12:08PM
370
January 14, 2021 09:07PM
Re: Changing table engine to innodb manually
391
January 14, 2021 11:29PM
310
January 15, 2021 12:35PM
408
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.