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 Erick Ramirez commented

Do we have to keep running nodetool compact after we have done it once?

[FOLLOW UP QUESTION TO #10883]

So, we have already run nodetool compact manually for this keyspace.

Since we already executed compaction manually for the keyspace, do we have to keep doing this going forward? Is this applicable for both STCS and LCS based tables?

stcs
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 Erick Ramirez commented

No, you don't have to keep triggering a major compaction. In fact, it isn't a good idea to do so as I've documented in Why forcing a major compaction is not ideal.

You didn't explain your reasons for manually triggering compactions but I suspect you are doing it as a workaround for another problem.

If you log a ticket with DataStax Support, our engineers will be happy to work with you to address the root cause of your issues instead of having to do temporary workarounds. Cheers!

2 comments 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.

Thank you Erick.. We were actually trying to do some proof of concept testing to understand how each compaction strategy is performing. But after reading your articles and multiple other posts, we have decided against triggering the compaction manually.

0 Likes 0 ·
Erick Ramirez avatar image Erick Ramirez ♦♦ yashwanth.kondeti@verizon.com ·

Excellent choice. Cheers!

0 Likes 0 ·