Fastest way? Stop cassandra, use sstablemetadata to remove any files with maxTimestamp > 2 days. Start cassandra. Works better with some compaction strategies than others (probably find a few droppable sstables with either DTCS / STCS, but not perfect).
Cleanest way? One by one (starting with oldest sstables first), use forceUserDefinedCompaction on each sstable and let it purge out the droppable garbage. This is what the tombstone sub properties would do. From: Anubhav Kale Reply-To: "user@cassandra.apache.org" Date: Tuesday, May 17, 2016 at 4:17 PM To: "user@cassandra.apache.org" Subject: Applying TTL Change quickly Hello, We use STCS and DTCS on our tables and recently made a TTL change (reduced from 8 days to 2) on a table with large amounts of data. What is the best way to quickly purge old data ? I am playing with tombstone_compaction_interval at the moment, but would like some suggestions on what else can be done to reclaim the space as quick as possible. Thanks !
smime.p7s
Description: S/MIME cryptographic signature