MySQL Forums
Forum List  »  Partitioning

INTERVAL Partitioning
Posted by: Andrew A
Date: July 26, 2007 10:07AM


Thought I would chuck this in here.

Like Oracle's INTERVAL partitioning system, you can schedule new partitions to automatically be created as specified by range.

For example, I may choose to do INTERVAL partitioning by RANGE on a day.

So that at the start of each new day (based off the timestamp column on a row) I want a new partition to take all rows with that day.

This is exactly what people (especially in a data warehouse environment) are after.

Ideally this sort of thing can be managed by the database and so time is spent developing and not having to write code to automate this ourselves :[


Options: ReplyQuote

Written By
INTERVAL Partitioning
July 26, 2007 10:07AM
July 26, 2007 10:46PM
July 31, 2007 03:41PM
August 09, 2007 05:04PM
August 24, 2007 02:22PM

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.