cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Colby <>
Subject Re: simple question about merged SSTable sizes
Date Wed, 22 Jun 2011 18:09:30 GMT
Awesome tip on TTL.  We can really use this as a catch-all to make sure all columns are purged
based on time.  Fits our use-case good.  I forgot this feature existed.

On Jun 22, 2011, at 7:11 PM, Eric tamme wrote:

>>> Second, compacting such large files is an IO killer.    What can be tuned
>>> other than compaction_threshold to help optimize this and prevent the files
>>> from getting too big?
>>> Thanks!
> Just a personal implementation note - I make heavy use of column TTL,
> so I have very specifically tuned cassandra to having a pretty
> constant max disk usage based on my data insertion rate, the TTL, the
> memtable flush threshold, and min compaction threshold.  My data
> basically lives for 7 days and depending on where it is in the
> compaction cycle goes from 130 gigs per node up to 160gigs per node.
> If setting TTL is an option for you, It is one way to auto purge data
> and keep overall size in check.
> -Eric

View raw message