MySQL Forums
Forum List  »  Archive Storage Engine

Advanced Search
New Topic

Re: HELP! need sparse index for archive engine tables!!!
Posted by: KimSeong Loh
Date: February 27, 2007 06:51PM

For archive purpose, you can try MERGE storage engine with compressed MyISAM for the old data. Note that compressed MyISAM is read only, so you need to have the latest table to be MyISAM for insertion, the rest can be compressed.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
HELP! need sparse index for archive engine tables!!!
11567
Ijaz Rashid
February 15, 2007 03:48AM
Re: HELP! need sparse index for archive engine tables!!!
5853
Ijaz Rashid
February 16, 2007 06:52AM
Re: HELP! need sparse index for archive engine tables!!!
6027
Ijaz Rashid
February 18, 2007 03:51AM
Re: HELP! need sparse index for archive engine tables!!!
15610
Ijaz Rashid
February 19, 2007 05:56AM
Re: HELP! need sparse index for archive engine tables!!!
5984
KimSeong Loh
February 27, 2007 06:51PM
Re: HELP! need sparse index for archive engine tables!!!
6107
Ijaz Rashid
March 04, 2007 01:29AM


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.