Re: LeveledCompactionStrategy

2015-05-26 Thread Stefano Ortolani
Hi Jean, I am trying to solve a similar problem here. I would say that the only deterministic way is to rebuild the SStable of that column family via nodetool scrub. Otherwise you'd need to : * decrease tombstone_threshold * wait for gc_grace_time Cheers, Stefano On Tue, May 26, 2015 at 12:51

Re: LeveledCompactionStrategy

2015-05-26 Thread Jean Tremblay
I played around with these settings, namely the tombstone_threshold, and it **eventually** triggered a Tombstone Compaction. Now I see that getting rid of these Tombstone is a process which takes some times. I would like to be able to schedule a Tombstone Compaction. Is there a way to trigger i

Re: LeveledCompactionStrategy

2015-05-14 Thread Jean Tremblay
Thanks a lot. On 14 May 2015, at 22:45 , Nate McCall mailto:n...@thelastpickle.com>> wrote: You can make LCS more aggressive with tombstone-only compactions via seting unchecked_tombstone_compaction=true and turn down tombstone_threshold to 0.05 (maybe going up or down as needed). Details on bo

Re: LeveledCompactionStrategy

2015-05-14 Thread Nate McCall
You can make LCS more aggressive with tombstone-only compactions via seting unchecked_tombstone_compaction=true and turn down tombstone_threshold to 0.05 (maybe going up or down as needed). Details on both can be found here: http://docs.datastax.com/en/cql/3.1/cql/cql_reference/compactSubprop.html