[jira] [Commented] (CASSANDRA-9079) "respectTombstoneThresholds" should be configurable

["Lyuben Todorov (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-9079?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14544600#comment-14544600 ] 

Lyuben Todorov commented on CASSANDRA-9079:
-------------------------------------------

[~thobbs]'s point about too many config options in cassandra.yaml seems to be a common pain point in a lot of patches. Perhaps an acceptable approach would be to allow {{respectTombstoneThresholds}} to be configurable via JMX and the nodetool? 

> "respectTombstoneThresholds" should be configurable 
> ----------------------------------------------------
>
>                 Key: CASSANDRA-9079
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9079
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Core
>            Reporter: Vinay Chella
>              Labels: tombstone
>         Attachments: 9079.txt
>
>
> Currently there is no way to control/ configure the functionality of "drop queries exceeding a configurable number of tombstones". Making this functionality configurable through yaml helps use case like:
> We have several production clusters with large number of tombstones due to aggressive TTLs with very small payloads, and low gc_grace_seconds. Most of the read queries on these column families are ending up in drop operations or excessive warn messages due to "tombstone_failure_threshold" and "tombstone_warn_threshold". One cannot deterministically disable these tombstone thresholds by setting high values. Hence, making "SliceQueryFilter.respectTombstoneThresholds()" configurable through yaml would be the better approach. 
> Column families with small payloads (couple hundred bytes) having large number of tombstones would not lead to "Avoid death-by-tombstone by default (CASSANDRA-6117)", which is the reason for observed drop operations. We see drop operations before compactions catch up, and clean those tombstones with both STCS and LCS. Configurable "respectTombstoneThresholds()" will help in reducing tombstone warnings noise.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)