> With STCS, estimated droppable tombstones being always 0.0 (thus also no
> automatic single SSTable compaction may happen): Is this a matter of not
> writing with TTL? If yes, would enabling TTL with STCS improve the disk
> reclaim situation, cause then single SSTAble compactions will kick in?
Estimated droppable tombstones will increase if you have tombstones in an
SSTable. It is just an estimate however, but if you are deleting in any way
(TTL or manual) it should increase. Enabling TTL would increase disk
reclaim, but only because you would be deleting more data. Doing so only
makes sense if you actually can TTL your data. Probably don't do that
without fully understanding all the potential impacts to your data. In fact
it's not a great idea with STCS anyway.
Also, single SSTable compactions aren't very good for removing tombstones
anyway so probably shouldn't be relied on. To get rid of a tombstone the
tombstone needs to be compacted with every other SSTable that contains data
the tombstone covers.
What is the semantic of “default_time_to_live” at table level? From:
> http://docs.datastax.com/en/cql/3.1/cql/cql_using/use_expire_c.html :
> “After the default_time_to_live TTL value has been exceed, Cassandra
> tombstones the entire table”. What does “entire table” mean? Hopefully / I
> guess I don’t end up with an empty table every X past TTLs?
I didn't read that page but Cassandra doesn't tombstone the entire table.
If the default TTL is set on the table, then whenever any data inserted
into the table surpasses the TTL it is becomes expired (essentially a
tombstone). You won't end up with an empty table unless you stop inserting
I know, changing compaction is a matter of executing ALTER TABLE (or
> temporary via JMX for a single node), but as we have legacy data being
> written without TTL, I wonder if we may end up in stuck SSTable again
Yes, if you have legacy data you should make sure you delete it before you
change compaction strategy to TWCS. Otherwise you may have SSTables with
live data that never get deleted.
Short on time, sorry I didn't answer all your questions!