MySQL Forums
Forum List  »  Archive Storage Engine

Delete old records
Posted by: Joss BH
Date: February 27, 2009 01:13AM

Hi All,

I am required to store large amount of textual data. the information source is CSV files holding CDRs (call details records).
The data is accessed infrequently for data mining but needs to be kept for few months, this leads me to using the Archive engine with partitions per interval (month, week, according to table scan performance).

The only issue I need to figure out is how to remove old data after a retention period has expired, as I know 'Delete' is not supported by this engine.
Conversion to another engine is also impractical as after decompression the data is too large to fit on disk.
What is the best practice for such scenario? dropping the partition for the expired interval?



Edited 1 time(s). Last edit at 02/27/2009 01:22AM by Joss BH.

Options: ReplyQuote


Subject
Views
Written By
Posted
Delete old records
11822
February 27, 2009 01:13AM


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.