MySQL Forums
Forum List  »  Partitioning

Re: Partition Pruning Problem on Billion Row Table
Posted by: Rick James
Date: May 23, 2009 02:00AM

Think outside the box.

* Do you really need to keep the old data?

* Can you summarize the data, then toss it?

* Column-oriented storage like InfoBright.

* Perl script to build the PARTITION definition; run it each day to add another day.

* Copy the table over, switching to monthly partitions.

* Look at the queries and decide on some other structure.

Options: ReplyQuote

Written By
Re: Partition Pruning Problem on Billion Row Table
May 23, 2009 02:00AM

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.