cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Coli <>
Subject Re: manually removing sstable
Date Wed, 10 Jul 2013 16:43:11 GMT
On Wed, Jul 10, 2013 at 5:09 AM, Theo Hultberg <> 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?


> 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.


View raw message