MySQL Forums
Forum List  »  Partitioning

Re: Partitioning table by timestamp column type
Posted by: Rick James
Date: March 25, 2011 09:14AM

Alas, nothing automatic about creating future PARTITIONs. You should create a cron jobs for such.

Also, note that there is a limit of 1024 partitions, so you cannot even get to 3 years' worth of partitions.

Prematurely creating partitions leads to some queries doing extra work to check the empty partitions.

If you are not using the partitions to facilitate dropping old data, why do you want to PARTITION?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partitioning table by timestamp column type
1831
March 25, 2011 09:14AM


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.