MySQL Forums
Forum List  »  Partitioning

Re: Partitioning without # of partitions
Posted by: Phil Hildebrand
Date: August 12, 2008 10:12PM

Sounds like you want a new partition automatically created every time you insert a new key?

(so adding a new state_id would create a new partition for values with that state id..)

Currently, I don't think it's possible to happen automatically. It would be straight forward, however, to have a values < MAXVALUE partition for catching new entries, and then reorganizing the MAXVALUE partition on a regular basis to handle new state_id's. You'd probably want a list or range partition in that case.

Options: ReplyQuote

Written By
August 12, 2008 06:32AM
Re: Partitioning without # of partitions
August 12, 2008 10:12PM

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.