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.
* - *There are 2-3 partition keys i see while doing major compaction
throwing large partition warning(100mb threshold) , their sizes around
- All other tables use STCS , their auto compaction is working fine.
Any pointers would be helpful