Re: TWCS and autocompaction

2018-01-16 Thread Alexander Dejanovski
The ticket I was referring to is the following : https://issues.apache.org/jira/browse/CASSANDRA-13418 It's been merged in 3.11.1, so just make sure you enable unsafe_aggressive_sstable_expiration and you'll evict expired SSTables regardless of overlaps (and IMHO it's totally safe to do this). Do

Re: TWCS and autocompaction

2018-01-16 Thread Cogumelos Maravilha
Hi, My read_repair_chance is 0 (AND read_repair_chance = 0.0) When I bootstrap a new node there is around 700 sstables, but after auto compaction the number drop to around 100. I'm using C* 3.11.1. To solve the problem I've already changed to 'unchecked_tombstone_compaction': 'true'. Now should

Re: TWCS and autocompaction

2018-01-16 Thread Alexander Dejanovski
Hi, The overlaps you're seeing on time windows aren't due to automatic compactions, but to read repairs. You must be reading at quorum or local_quorum which can perform foreground read repair in case of digest mismatch. You can set unchecked_tombstone_compaction to true if you want to perform

TWCS and autocompaction

2018-01-16 Thread Cogumelos Maravilha
Hi list, My settings: AND compaction = {'class': 'org.apache.cassandra.db.compaction.TimeWindowCompactionStrategy', 'compaction_window_size': '4', 'compaction_window_unit': 'HOURS', 'enabled': 'true', 'max_threshold': '64', 'min_threshold': '2', 'tombstone_compaction_interval': '15000',