Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

yashwanth.kondeti@verizon.com avatar image
yashwanth.kondeti@verizon.com asked ·

Is LCS a better option for large tables?

[FOLLOW UP QUESTION TO #10883]

1 large table (will reach 1-3 TB eventually) is using LCS. We decided on this compactionstrategy because this table is going to have lot of updates compared to inserts.

Is it right to believe that LCS is the better option for the large table mentionedabove?

lcs
10 |1000 characters needed characters left characters exceeded

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

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

No, LeveledCompactionStrategy is often not a good choice as a compaction strategy (though "your miles may vary").

In my experience, LCS is only suitable for data which rarely gets updated because LCS is quite aggressive in a sense that it will continuously compact SSTables in lower levels to coalesce/merge partition fragments (updated portions of a partition) into one SSTable.

For tables with a high update workload, the high IO requirements from the continuous compactions can significantly affect the performance of your cluster. Cheers!

1 comment Share
10 |1000 characters needed characters left characters exceeded

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