写记录时指定ttl, 时间到期后会产生大量墓碑，这种方式对Cassandra的读写性能是否有影响？

Question

This question was closed Jul 14, 2020 at 02:29 AM by Erick Ramirez for the following reason: The question is answered, right answer was accepted

question

qiuzeliang_194033 asked Jul 13, '20 Erick Ramirez answered Jul 13, '20

写记录时指定ttl, 时间到期后会产生大量墓碑，这种方式对Cassandra的读写性能是否有影响？

例如，每天往一张表写1000W条记录，记录的ttl设置为1个月， 1个月后每天产生1000w个墓碑，此时对这张表的读写性能是否有影响？

tombstones ttl

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

DataStax Enterprise is powered by the best distribution of Apache Cassandra ™

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Privacy Policy Terms of Use

Answer 1 · 2020-07-13T11:52:15Z

Erick Ramirez answered Jul 13, '20

这取决于上面有TTL的数据。如果将TTL应用于整个partition，则tombstones不是问题。

如果要在clustering columns上应用TTL，则如果要遍历过期的行以获取live数据，则可能会出现问题。

我们将需要查看表的schema和带有TTL的查询，以便我们确定是否会出现问题。

Share

10 |1000

Attachments: Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

question

写记录时指定ttl, 时间到期后会产生大量墓碑，这种方式对Cassandra的读写性能是否有影响？

1 Answer

question details

OTHER RESOURCES