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
539
January 14, 2021 07:45AM
258
January 14, 2021 12:08PM
247
January 14, 2021 09:07PM
Re: Changing table engine to innodb manually
251
January 14, 2021 11:29PM
227
January 15, 2021 12:35PM
250
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.