MySQL Forums
Forum List  »  Partitioning

Uneven rolling partition
Posted by: Yehuda Alon
Date: April 12, 2008 05:24PM

We have a table with ~10M rows.

Currently, new rows are added by users' activities, while 'old' ones are archived (and deleted), based on age and status.

90% of queries are for the most recent rows (those inserted in the last hour, 10-30K rows), 9% are for rows aged up to 5 days (~1M rows) and the rest is for 'old' rows.

Ideally, we would like to have 3 partitions ('hot', 'warm' and 'cold') and have rows moving between them automatically as they aged. Any suggestion on how to setup this ?

Options: ReplyQuote

Written By
Uneven rolling partition
April 12, 2008 05:24PM
April 13, 2008 12:24AM

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.