TimeWindowCompactionStrategy and don’t delete the data you should be relying on Cassandra to drop the SSTables once the data inside has expired.
THat 18% is probably waiting on gc_grace, this shouldn’t be an issue if you are letting TWCS drop the data rather then running deletes. Regards, Evelyn. > On 19 Jun 2018, at 8:28 pm, Abhishek Singh <[email protected]> wrote: > > Hi all, > We using Cassandra for storing events which are time series based > for batch processing once a particular batch based on hour is processed we > delete the entries but we were left with almost 18% deletes marked as > Tombstones. > I ran compaction on the particular CF tombstone didn't come > down. > Can anyone suggest what is the optimal tunning/recommended > practice used for compaction strategy and GC_grace period with 100k entries > and deletes every hour. > > Warm Regards > Abhishek Singh --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
