cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Haddad <...@jonhaddad.com>
Subject Re: Best compaction strategy
Date Thu, 25 Oct 2018 19:43:36 GMT
To add to what Alex suggested, if you know what keys use what TTL you could
store them in different tables, with different window settings.

Jon

On Fri, Oct 26, 2018 at 1:28 AM Alexander Dejanovski <alex@thelastpickle.com>
wrote:

> Hi Raman,
>
> TWCS is the best compaction strategy for TTL data, even if you have
> different TTLs (set the time window based on your largest TTL, so it would
> be 1 day in your case).
> Enable unchecked tombstone compaction to clear the data with 2 days TTL
> along the way. This is done by setting :
>
> ALTER TABLE my_table WITH compaction =
> {'class':'TimeWindowCompactionStrategy',
> 'unchecked_tombstone_compaction':'true', ...}
>
> If you're running 3.11.1 at least, you can turn on the
> unsafe_aggressive_sstable_expiration introduced by CASSANDRA-13418
> <https://issues.apache.org/jira/browse/CASSANDRA-13418>.
>
> Cheers,
>
> On Thu, Oct 25, 2018 at 2:59 PM raman gugnani <ramangugnani.007@gmail.com>
> wrote:
>
>> Hi All,
>>
>> I have one table in which i have some data which has TTL of 2days and
>> some data which has TTL of 60 days. What compaction strategy will suits the
>> most.
>>
>>    1. LeveledCompactionStrategy (LCS)
>>    2. SizeTieredCompactionStrategy (STCS)
>>    3. TimeWindowCompactionStrategy (TWCS)
>>
>>
>> --
>> Raman Gugnani
>>
>> 8588892293 <(858)%20889-2293>
>>
>> --
> -----------------
> Alexander Dejanovski
> France
> @alexanderdeja
>
> Consultant
> Apache Cassandra Consulting
> http://www.thelastpickle.com
>
-- 
Jon Haddad
http://www.rustyrazorblade.com
twitter: rustyrazorblade

Mime
View raw message