On Wed, Jul 10, 2013 at 5:09 AM, Theo Hultberg <t...@iconara.net> wrote:
> I think I remember reading that if you have sstables that you know contain > only data that whose ttl has expired, it's safe to remove them manually by > stopping c*, removing the *-Data.db files and then starting up c* again. is > this correct? > Yes. > we have a cluster where everything is written with a ttl, and sometimes c* > needs to compact over a 100 gb of sstables where we know ever has expired, > and we'd rather just manually get rid of those. > Have you considered TRUNCATE oriented approaches to this problem? I believe that TRUNCATE (with proper handling/purging of snapshots) oriented approaches have potential for cases where 100% of data in a given time window becomes worthless. =Rob
