MySQL Forums
Forum List  »  Partitioning

Re: Online Partition addition use "add partition" clause or "reorganize" clause?
Posted by: Mikael Ronström
Date: November 13, 2014 06:54AM

Tom Song Wrote:
-------------------------------------------------------
> Hi Rick James,
>
> Thank you for your help.
>
> As your response that can do the reorganize
> online, will use it to add partition online.

No partition change operation are truly on-line,
the table is still readable but not writeable
for a short time. However as mentioned when the
partition that you reorg is empty, it is a very
quick operation which will complete in probably
less than a second, so it is practically online.

Also all other partition change operations
minimise the amount of time for changing
the table since only the relevant parts of
the table are reorganised.

Rgrds Mikael Ronström

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Online Partition addition use "add partition" clause or "reorganize" clause?
989
November 13, 2014 06:54AM


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.