Hi, do you mean LeveledCompactionStrategy?
Also you will need to run nodetool upgradesstables [keyspace][cf_name] after changing the compaction strategy. Thanks, Haithem Jarraya On 21 Aug 2013, at 15:15, tamas.fold...@thomsonreuters.com<mailto:tamas.fold...@thomsonreuters.com> wrote: Hi, After upgrading from 1.0 to 1.2, I wanted to make use of the automatic tombstone compaction feature, so using CQL3 I issued: ALTER TABLE versions WITH compaction = {'class' : 'SizeTieredCompactionStrategy', 'min_threshold' : 4, 'max_threshold' : 32, 'tombstone_compaction_interval' : 1, 'tombstone_threshold' : '0.1'}; But I still see no trace that would suggest this works – we had 60G of data with TTL=1week pushed a while ago to the test cluster, the majority of it should be expired & compacted away by now. Not sure if it is relevant, but this old data is in one ~60G file + I have a few smaller files with latest data in them. Looking at JMX: DroppableTombstoneRatio = 0.892076544, which seems to back my theory. Am I doing something wrong, or am I expecting the wrong thing? Thanks, Tamas
