Hi We are using 4 node cassandra 3.10 cluster. For some reason autocompaction is not running on one of the table which uses DTCS. TTL on this table is 3 months. Table has high write load , and medium read load.
We have 4 disks per node , each disk growed to around 5k-6k sstables going back to around 6-7 months. I tried running major compaction which takes 1-2 days on each node, which results in 20-30 sstables on all disks except 1. But also after running major compaction , we now see sstables have started growing again. So minor/auto compaction is not running on this table. *Few Observations* * - *There are 2-3 partition keys i see while doing major compaction throwing large partition warning(100mb threshold) , their sizes around 100-200MB - All other tables use STCS , their auto compaction is working fine. Any pointers would be helpful Thanks Anshul