[
https://issues.apache.org/jira/browse/CASSANDRA-13024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stefan Podkowinski updated CASSANDRA-13024:
-------------------------------------------
Component/s: Compaction
> Droppable Tombstone Ratio Calculation
> -------------------------------------
>
> Key: CASSANDRA-13024
> URL: https://issues.apache.org/jira/browse/CASSANDRA-13024
> Project: Cassandra
> Issue Type: Bug
> Components: Compaction
> Reporter: Stefan Podkowinski
>
> Whenever no sstables can be compacted in a standard way, we currently try to
> compact sstables that would make worthwhile candidates by evaluation
> {{sstable.getEstimatedDroppableTombstoneRatio(gcBefore) <=
> tombstoneThreshold}}. You can find out more on how this is supposed to work
> and the various settings options by reading "[About Deletes and Tombstones in
> Cassandra|http://thelastpickle.com/blog/2016/07/27/about-deletes-and-tombstones.html#single-sstable-compaction]"
> by [~arodrime].
> The bad news is that currently the ratio value will vary to a great degree
> depending on the data model and type of deletes, as the ratio will be created
> based on the number of tombstones and number of _columns_. Any kind of
> tombstone will be counted here, no matter if on column or partition level,
> which will give you very different ratios based on the number of columns in
> your table and how you delete the data.
> Considering a 0.20 default threshold for finding sstables with enough
> droppable tombstones, it only takes 3 columns in your table to never hit the
> threshold at all when using partition tombstones.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)