MySQL Forums
Forum List  »  Archive Storage Engine

Enable deletion for archive engine.
Posted by: David Drouin
Date: November 02, 2009 01:31PM

The archive engine should obviously support deletion. It's somewhat ridiculous that it's prevented - seems almost like spin on a lack of an ability than a feature. There are often situations where you would like to archive data for a few years, a decade maybe but not necessarily "forever". So for those use cases (the majority) we're still left wanting. Live -> Archive -> Delete.

Wouldn't it be far more reasonable to have the ability to toggle whether deletes are allowed for a particular table perhaps upon creation only - or to be clearer supply effectively a copy of the archive engine with deletion disabled called perhaps the audit storage engine to facilitate this where needed?

Options: ReplyQuote


Subject
Views
Written By
Posted
Enable deletion for archive engine.
9681
November 02, 2009 01:31PM
5364
November 03, 2009 02:05PM


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.