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?
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!
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.
5 People are following this question.
