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

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

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

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

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 commented ·

Excellent choice. Cheers!

0 Likes 0 ·