Re: when is the proper time to execute optimize table command ?
Posted by: Rick James
Date: September 18, 2015 11:43PM

In my opinion, "Never".

Seriously, most tables do not have the type of activity that benefit from OPTIMIZE. MyISAM tables can get more fragmented than InnoDB tables. You are using InnoDB, aren't you?

The BTrees in InnoDB are, to a large extent, self adjusting. That is, they rarely get so fragmented that it is worth doing OPTIMIZE.

Numbers? I would say only one table in a thousand _ever_ needs defragmenting. And then only once a month.

Options: ReplyQuote

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.