Re: Execute table optimization concurrently
Posted by: Leo Lam
Date: August 06, 2014 11:24PM

Hi Rick,

Thanks for your reply to my post.

Yes, I am talking about running optimize table concurrently in MySQL.

I have arround 400 something tables in my MySQL server databases.

I have a miantenance task to run optimize databases for all the databases which takes arround 5 hours to complete, hence 5 hours downtime.

Currently, I have a script to run the optimize databases one by one and there is only one Optimize table command running in the database.

To better utilitize the database (I think it can), I have written a script to concurrently run Optimize tables. It is running 400 something optimize tables at the same time and the total time for optimize tables is shorten to 2 hours and more.

Is it a suitable way to run optimize table in parallel?

Is it creating fragmentation in tables?

Best,

Leo Lam

Options: ReplyQuote


Subject
Written By
Posted
Re: Execute table optimization concurrently
August 06, 2014 11:24PM


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.