我在下表中插入数据,TTL为2天 . 时间戳超过2天的SSTABLES应该已经被删除但是没有发生 . 没有删除也没有更新 . 窗口大小为1小时,gc_grace_seconds为7200. read_repair已设置为0.0
CREATE TABLE events."290" (
key text PRIMARY KEY,
raw_log text
) WITH COMPACT STORAGE
AND bloom_filter_fp_chance = 0.01
AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
AND comment = ''
AND compaction = {'class': 'org.apache.cassandra.db.compaction.TimeWindowCompactionStrategy', 'compaction_window_size': '1', 'compaction_window_unit': 'HOURS', 'max_threshold': '64', 'min_threshold': '32'}
AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.SnappyCompressor'}
AND crc_check_chance = 1.0
AND dclocal_read_repair_chance = 0.0
AND default_time_to_live = 0
AND gc_grace_seconds = 7200
AND max_index_interval = 2048
AND memtable_flush_period_in_ms = 0
AND min_index_interval = 128
AND read_repair_chance = 0.0
AND speculative_retry = 'NONE';
在重新启动cassandra时,已过期的sstables按预期被删除 .
我应该设置unchecked_tombstone_compaction = true吗?理想情况下,我希望sstables完全丢弃,而不是经过多次压缩才能被删除 .
之前我使用的是DateTieredCompaction和cassandra 2.2 . 一切都很好 . 升级到cassandra 3.0.13并观察上述行为 . 将压缩从DTCS更改为TWCS仍然是相同的行为 .
如果重新启动过期的sstables没有被删除,我会考虑重叠sstables的情况https://issues.apache.org/jira/browse/CASSANDRA-13418