Re: TWCS and gc_grace_seconds

2019-10-17 Thread Jeff Jirsa
Is everything in the table TTL’d? Do you do explicit deletes before the data is expected to expire ? Generally speaking, gcgs exists to prevent data resurrection. But ttl’d data can’t be resurrected once it expires, so gcgs has no purpose unless you’re deleting it before the ttl expires. If y

TWCS and gc_grace_seconds

2019-10-17 Thread Adarsh Kumar
Hi, We have a use case of time series data with TTL where we want to use TimeWindowCompactionStrategy because of its better management for TTL and tombstones. In this case, data we have is frequently deleted so we want to reduce gc_grace_seconds to reduce the tombstones' life and reduce pressure o

Re: Configurations for better performance

2019-10-17 Thread Max C .
I haven’t watched it yet, but John Haddad did a talk on performance optimization at the Datastax accelerate conference (and another talk a year/two before): 10 Easy Ways to Tune Your Cassandra Cluster with John Haddad | DataStax Accelerate 2019 https://www.youtube.com/watch?v=swL7bCnolkU - Max