I have read multiple questions where it was explained that it is not ideal to run a manual compaction on Cassandra tables using SizeTieredCompactionStrategy. Also, it was noted that running the manual compaction even once would mean that we need to continue to do it manually going forward as well. So the temporary solution was given to split the output files.
My question is based on a weird scenario my team is in: There are 5 tables in the keyspace:
--- 4 of the tables are very small tables (5-10GB size) and use STCS
--- 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.
So, we have already run nodetool compact manually for this keyspace. Given this situation, I have the following questions.
1. [Follow up question posted in #10976]
2. [Follow up question posted in #11014]
3. [Follow up question posted in #11006]
Your suggestions and inputs are greatly appreciated.