Re: How to remove tombstones in a levelled compaction table in Cassandra 2.1.16?

2021-07-06 Thread manish khandelwal
Thanks Jeff and Vytenis. Jeff, could you explain what do you mean by If you just pipe all of your sstables to user defined compaction jmx > endpoint one at a time you’ll purge many of the tombstones as long as you > don’t have a horrific data model. Regards Manish On Wed, Jul 7, 2021 at 4:21

Re: How to remove tombstones in a levelled compaction table in Cassandra 2.1.16?

2021-07-06 Thread Jeff Jirsa
In 2.1 the only option is enable auto compaction or queue up manual user defined compaction If you just pipe all of your sstables to user defined compaction jmx endpoint one at a time you’ll purge many of the tombstones as long as you don’t have a horrific data model. > On Jul 6, 2021, at

Re: How to remove tombstones in a levelled compaction table in Cassandra 2.1.16?

2021-07-06 Thread vytenis silgalis
You might want to take a look at `unchecked_tombstone_compaction` table setting. The best way to see if this is affecting you is to look at the sstablemetadata for the sstables and see if your tombstone ratio is higher than the configured tombstone_threshold ratio (0.2 be default) for the table.