MySQL Forums
Forum List  »  Partitioning

Re: reorganize syntax / procedure
Posted by: Rick James
Date: January 13, 2012 07:34PM

> mysql> ALTER TABLE ap_log REORGANIZE PARTITION p12 INTO (
PARTITION p12t VALUES LESS THAN (1333252800) ENGINE = InnoDB);

* No, you want to recreate the MAXVALUE partition again.
* Unless you have an old version of MySQL, you can recreate p12 from p12

I recommend
ALTER TABLE ap_log REORGANIZE PARTITION p12 INTO (
PARTITION p12 VALUES LESS THAN (1333252800),
PARTITION future VALUES LESS THAN MAXVALUE
);

Next time, REORGAINZE future INTO p13 and future.
Etc.

As for SUBPARTITIONs, I don't know. I have never found a use for them. What queries benefit from partitioning?

Options: ReplyQuote


Subject
Views
Written By
Posted
3805
January 12, 2012 03:36PM
3833
January 13, 2012 10:35AM
1523
January 13, 2012 03:57PM
Re: reorganize syntax / procedure
1986
January 13, 2012 07:34PM


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.