cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric tamme <eta...@gmail.com>
Subject Re: simple question about merged SSTable sizes
Date Wed, 22 Jun 2011 17:11:15 GMT
>> 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

Mime
View raw message