MySQL Forums :: Partitioning :: Online Partition addition use "add partition" clause or "reorganize" clause?


Advanced Search

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
Online Partition addition use "add partition" clause or "reorganize" clause? 2131 Tom Song 10/21/2014 03:53AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause? 998 Tom Song 10/22/2014 11:58PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause? 957 Rick James 10/23/2014 04:36PM
Re: Online Partition addition use "add partition" clause or "reorganize" clause? 969 Tom Song 10/24/2014 02:05AM
Re: Online Partition addition use "add partition" clause or "reorganize" clause? 923 Mikael Ronström 11/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.