# \#tombstone

**URL:** https://forum.scylladb.com/tag/tombstone/98.md

[Latest](https://forum.scylladb.com/latest.md) · [Categories](https://forum.scylladb.com/categories.md) · [Tags](https://forum.scylladb.com/tags.md)

---

## [Will tombstones be frequently repaired after being compressed?](https://forum.scylladb.com/t/will-tombstones-be-frequently-repaired-after-being-compressed/4755)

<div class="topic-metadata">

**Author:** [@bo\_li](https://forum.scylladb.com/u/bo_li)\
**Replies:** 3\
**Last updated:** [July 16, 2025, 1:54pm UTC](https://forum.scylladb.com/t/will-tombstones-be-frequently-repaired-after-being-compressed/4755 "2025-07-16T13:54:02Z")

</div>

Installation details #ScyllaDB version: 5.2.18 #Cluster size: 35 os (RHEL/CentOS/Ubuntu/AWS AMI): centos I have a 35 node 5 replica cluster and the traffic pattern involves a lot of writes and deletes through altern…

---

## [Tombstones warning, threshold, creating and removing tables every few hours, performance impacts](https://forum.scylladb.com/t/tombstones-warning-threshold-creating-and-removing-tables-every-few-hours-performance-impacts/4843)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [May 20, 2025, 7:13am UTC](https://forum.scylladb.com/t/tombstones-warning-threshold-creating-and-removing-tables-every-few-hours-performance-impacts/4843 "2025-05-20T07:13:46Z")

</div>

---

## [How to Optimize Tombstone Issues Caused by Updating Primary Keys in ScyllaDB Materialized Views?](https://forum.scylladb.com/t/how-to-optimize-tombstone-issues-caused-by-updating-primary-keys-in-scylladb-materialized-views/4189)

<div class="topic-metadata">

**Author:** [@qijia\_wang](https://forum.scylladb.com/u/qijia_wang)\
**Replies:** 1\
**Last updated:** [April 15, 2025, 12:13pm UTC](https://forum.scylladb.com/t/how-to-optimize-tombstone-issues-caused-by-updating-primary-keys-in-scylladb-materialized-views/4189 "2025-04-15T12:13:09Z")

</div>

I’m using ScyllaDB to store subscription relationships in the following business scenario: Requirements: The data model needs to support these queries: app\_id = ? AND user\_id = ? AND ts \>= \<lastTs\> LIMIT 10 for increm…

---

## [Tombstone warnings for system\_schema.tables, using Kubernetes, frequently creating and deleting tables](https://forum.scylladb.com/t/tombstone-warnings-for-system-schema-tables-using-kubernetes-frequently-creating-and-deleting-tables/4740)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [April 15, 2025, 4:23am UTC](https://forum.scylladb.com/t/tombstone-warnings-for-system-schema-tables-using-kubernetes-frequently-creating-and-deleting-tables/4740 "2025-04-15T04:23:32Z")

</div>

---

## [System batchlog table, tombstones compactions and effect on performance](https://forum.scylladb.com/t/system-batchlog-table-tombstones-compactions-and-effect-on-performance/4645)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [March 24, 2025, 4:57am UTC](https://forum.scylladb.com/t/system-batchlog-table-tombstones-compactions-and-effect-on-performance/4645 "2025-03-24T04:57:08Z")

</div>

---

## [Is DELETE + INSERT to update immutable data in rows a recommended approach?](https://forum.scylladb.com/t/is-delete-insert-to-update-immutable-data-in-rows-a-recommended-approach/4576)

<div class="topic-metadata">

**Author:** [@jarPotato](https://forum.scylladb.com/u/jarPotato)\
**Replies:** 1\
**Last updated:** [March 6, 2025, 7:55am UTC](https://forum.scylladb.com/t/is-delete-insert-to-update-immutable-data-in-rows-a-recommended-approach/4576 "2025-03-06T07:55:50Z")

</div>

In the leaderboard modeling blog, it’s mentioned that updating fields that are part of the primary key (whether partition or clustering keys) requires deleting the existing row and inserting a modified version. However,…

---

## [I want to know Best Practices for Designing an Efficient Data Model in ScyllaDB?](https://forum.scylladb.com/t/i-want-to-know-best-practices-for-designing-an-efficient-data-model-in-scylladb/4526)

<div class="topic-metadata">

**Author:** [@samuelwatson](https://forum.scylladb.com/u/samuelwatson)\
**Replies:** 1\
**Last updated:** [February 23, 2025, 6:14am UTC](https://forum.scylladb.com/t/i-want-to-know-best-practices-for-designing-an-efficient-data-model-in-scylladb/4526 "2025-02-23T06:14:47Z")

</div>

Hey everyone, I am working on designing a data model for a new project using ScyllaDB & want to get some insights from the community. I know that ScyllaDB is built for high performance & scalability but I want to make s…

---

## [Why do tombstones exist in the scylla\_cdc\_log table?](https://forum.scylladb.com/t/why-do-tombstones-exist-in-the-scylla-cdc-log-table/4395)

<div class="topic-metadata">

**Author:** [@bo\_li](https://forum.scylladb.com/u/bo_li)\
**Replies:** 1\
**Last updated:** [January 22, 2025, 12:27pm UTC](https://forum.scylladb.com/t/why-do-tombstones-exist-in-the-scylla-cdc-log-table/4395 "2025-01-22T12:27:30Z")

</div>

Installation details #ScyllaDB version: 5.4.10 #Cluster size: 6 os (RHEL/CentOS/Ubuntu/AWS AMI): CentOS Hi ！ After I turned on cdc for the table, I found tombstones when scanning the cdc\_log table. The log is as fo…

---

## [How to update the tombstone\_warn\_threshold value, rolling restart](https://forum.scylladb.com/t/how-to-update-the-tombstone-warn-threshold-value-rolling-restart/4276)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [December 26, 2024, 5:29am UTC](https://forum.scylladb.com/t/how-to-update-the-tombstone-warn-threshold-value-rolling-restart/4276 "2024-12-26T05:29:00Z")

</div>

---

## [Hinted Handoff with gc\_mode = immediate](https://forum.scylladb.com/t/hinted-handoff-with-gc-mode-immediate/3206)

<div class="topic-metadata">

**Author:** [@Artem\_Golovko](https://forum.scylladb.com/u/Artem_Golovko)\
**Replies:** 4\
**Last updated:** [December 20, 2024, 9:58pm UTC](https://forum.scylladb.com/t/hinted-handoff-with-gc-mode-immediate/3206 "2024-12-20T21:58:29Z")

</div>

Installation details ScyllaDB version: 6.2.1 Question: According to that question How the tombstones work in Scylla, the difference with gc\_grace\_seconds = 0 and gc\_mode = immediate in Hinted Handoff mechanism. I red …

---

## [Tombstones, gc\_grace\_seconds, propagation\_delay\_in\_seconds, TWCS, compaction and related questions](https://forum.scylladb.com/t/tombstones-gc-grace-seconds-propagation-delay-in-seconds-twcs-compaction-and-related-questions/4064)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [December 4, 2024, 4:32am UTC](https://forum.scylladb.com/t/tombstones-gc-grace-seconds-propagation-delay-in-seconds-twcs-compaction-and-related-questions/4064 "2024-12-04T04:32:19Z")

</div>

---

## [Does tombstone blocks shadowed data SSTables from being purged in TWCS](https://forum.scylladb.com/t/does-tombstone-blocks-shadowed-data-sstables-from-being-purged-in-twcs/3205)

<div class="topic-metadata">

**Author:** [@Artem\_Golovko](https://forum.scylladb.com/u/Artem_Golovko)\
**Replies:** 1\
**Last updated:** [November 22, 2024, 4:52am UTC](https://forum.scylladb.com/t/does-tombstone-blocks-shadowed-data-sstables-from-being-purged-in-twcs/3205 "2024-11-22T04:52:12Z")

</div>

Installation details ScyllaDB version: 6.2.1 From the documentation: Avoid overwriting data and deleting data explicitly at all costs, as this can potentially block an expired SSTable from being purged, due to the che…

---

## [How the tombstones work in Scylla](https://forum.scylladb.com/t/how-the-tombstones-work-in-scylla/3165)

<div class="topic-metadata">

**Author:** [@Artem\_Golovko](https://forum.scylladb.com/u/Artem_Golovko)\
**Replies:** 2\
**Last updated:** [November 18, 2024, 4:38pm UTC](https://forum.scylladb.com/t/how-the-tombstones-work-in-scylla/3165 "2024-11-18T16:38:37Z")

</div>

Hello everyone, I’m so confused in understanding how tombstones works in scylla and will be really happy if someone could reveal my doubts. I’m using scylla version 6.1.2 Tombstone “validity” As far as I understood t…

---

## [Time to Live (TTL) with mixed expiration times, tombstone\_threshold and sstable expiration issues](https://forum.scylladb.com/t/time-to-live-ttl-with-mixed-expiration-times-tombstone-threshold-and-sstable-expiration-issues/3151)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [November 7, 2024, 6:03am UTC](https://forum.scylladb.com/t/time-to-live-ttl-with-mixed-expiration-times-tombstone-threshold-and-sstable-expiration-issues/3151 "2024-11-07T06:03:41Z")

</div>

---

## [Querying an Index via Alternator results in a different behavior than DynamoDB](https://forum.scylladb.com/t/querying-an-index-via-alternator-results-in-a-different-behavior-than-dynamodb/2917)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [September 19, 2024, 5:02am UTC](https://forum.scylladb.com/t/querying-an-index-via-alternator-results-in-a-different-behavior-than-dynamodb/2917 "2024-09-19T05:02:14Z")

</div>

@Joseph\_Stroman: The expected behavior is Alternator would return all the items it can and if there are leftovers then provide the last evaluated key (cursor) to continue “paginating” through the table. It looks like t…

---

## [What is tombstone\_compaction\_interval mean?](https://forum.scylladb.com/t/what-is-tombstone-compaction-interval-mean/2028)

<div class="topic-metadata">

**Author:** [@chih-hao\_wang](https://forum.scylladb.com/u/chih-hao_wang)\
**Replies:** 2\
**Last updated:** [August 19, 2024, 6:42am UTC](https://forum.scylladb.com/t/what-is-tombstone-compaction-interval-mean/2028 "2024-08-19T06:42:22Z")

</div>

I read the doc troubleshooting/pointless-compactions here is my table schema ALTER TABLE foo.bar WITH compaction = {'class' : 'LeveledCompactionStrategy','tombstone\_threshold' : 0.1,'sstable\_size\_in\_mb' : 160, 'tombs…

---

## [Deleting Materialized View and affect on tombstone data, disk usage](https://forum.scylladb.com/t/deleting-materialized-view-and-affect-on-tombstone-data-disk-usage/2504)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [August 18, 2024, 9:29am UTC](https://forum.scylladb.com/t/deleting-materialized-view-and-affect-on-tombstone-data-disk-usage/2504 "2024-08-18T09:29:42Z")

</div>

---

## [Why flush\_hints when gc\_mode is repair?](https://forum.scylladb.com/t/why-flush-hints-when-gc-mode-is-repair/2100)

<div class="topic-metadata">

**Author:** [@bo\_li](https://forum.scylladb.com/u/bo_li)\
**Replies:** 7\
**Last updated:** [August 4, 2024, 10:10am UTC](https://forum.scylladb.com/t/why-flush-hints-when-gc-mode-is-repair/2100 "2024-08-04T10:10:36Z")

</div>

I saw in repair.cc that flush\_hints are required when tombstone\_gc\_mode is repair. When writing fails, request data will be recorded in the hints directory. Does flush\_hints flush these records to disk?

---

## [Range queries, paging, and tombstones in ScyllaDB and Cassandra](https://forum.scylladb.com/t/range-queries-paging-and-tombstones-in-scylladb-and-cassandra/2287)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [July 11, 2024, 7:16am UTC](https://forum.scylladb.com/t/range-queries-paging-and-tombstones-in-scylladb-and-cassandra/2287 "2024-07-11T07:16:44Z")

</div>

---

## [Slow queries when indexing, BYPASS CACHE and non-expired tombstones](https://forum.scylladb.com/t/slow-queries-when-indexing-bypass-cache-and-non-expired-tombstones/2150)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [June 10, 2024, 5:54am UTC](https://forum.scylladb.com/t/slow-queries-when-indexing-bypass-cache-and-non-expired-tombstones/2150 "2024-06-10T05:54:02Z")

</div>

---

## [Can we use tombstone\_gc = {'mode': 'repair'} for GSI tables?](https://forum.scylladb.com/t/can-we-use-tombstone-gc-mode-repair-for-gsi-tables/1273)

<div class="topic-metadata">

**Author:** [@vincent](https://forum.scylladb.com/u/vincent)\
**Replies:** 7\
**Last updated:** [May 20, 2024, 7:32am UTC](https://forum.scylladb.com/t/can-we-use-tombstone-gc-mode-repair-for-gsi-tables/1273 "2024-05-20T07:32:21Z")

</div>

I have two questions here about tombstone\_gc = {‘mode’: ‘repair’} for GSI tables. I am not sure whether tombstone\_gc = {‘mode’: ‘repair’} is supported for GSI tables or not. How can I ensure that the tombstone\_gc mode …

---

## [The tombston\_gc={'mode': 'repair'} option doesn't remove tombstones](https://forum.scylladb.com/t/the-tombston-gc-mode-repair-option-doesnt-remove-tombstones/1471)

<div class="topic-metadata">

**Author:** [@sonny](https://forum.scylladb.com/u/sonny)\
**Replies:** 4\
**Last updated:** [April 22, 2024, 10:37pm UTC](https://forum.scylladb.com/t/the-tombston-gc-mode-repair-option-doesnt-remove-tombstones/1471 "2024-04-22T22:37:02Z")

</div>

I’m using ScyllaDB 5.4.x version. I tested the tombstone\_gc={‘mode’: ‘repair’} option and found it doesn’t remove tombstones. I had three ScyllaDB nodes and created keyspace and table like this. CREATE KEYSPACE test W…

---

## [TimeWindow Compaction Strategy, TTL, Tombstones, and window size](https://forum.scylladb.com/t/timewindow-compaction-strategy-ttl-tombstones-and-window-size/1485)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [April 15, 2024, 6:31pm UTC](https://forum.scylladb.com/t/timewindow-compaction-strategy-ttl-tombstones-and-window-size/1485 "2024-04-15T18:31:07Z")

</div>

---

## [INSERT =\> READ =\> DELETE workflow with single rows](https://forum.scylladb.com/t/insert-read-delete-workflow-with-single-rows/1420)

<div class="topic-metadata">

**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\
**Replies:** 0\
**Last updated:** [March 25, 2024, 6:38am UTC](https://forum.scylladb.com/t/insert-read-delete-workflow-with-single-rows/1420 "2024-03-25T06:38:09Z")

</div>

---

## [Cassandra's unchecked\_tombstone\_compaction not recognized](https://forum.scylladb.com/t/cassandras-unchecked-tombstone-compaction-not-recognized/1360)

<div class="topic-metadata">

**Author:** [@hanishi](https://forum.scylladb.com/u/hanishi)\
**Replies:** 4\
**Last updated:** [March 7, 2024, 6:23am UTC](https://forum.scylladb.com/t/cassandras-unchecked-tombstone-compaction-not-recognized/1360 "2024-03-07T06:23:03Z")

</div>

I’m engaging with the community to share an experience and seek insights regarding ScyllaDB’s handling of specific Cassandra’s tombstone compaction option, particularly unchecked\_tombstone\_compaction. While integrating …
