Re: Execute table optimization concurrently
Posted by:
Leo Lam
Date: August 07, 2014 10:01PM
Hi Rick,
Thank you for your reply and valuable advises.
I am running MySQL 5.6 (just upgraded) using Innodb and the optimize job will run once a year during application upgrade.
As the db growths larger and larger, the time needed for opitmize tables become longer and longer. I am looking for ways to shorten the optimize tables time, such that shorten the application downtime.
I just wonder optimize all the tables (400 and somehting) together in one go is a solution to shorten the time. Or is it doing more fragmentation instead.
Best,
Leo Lam
Subject
Written By
Posted
Re: Execute table optimization concurrently
August 07, 2014 10:01PM
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.