The DTCS windowing algorithm is timestamp sensitive - are you using 
milliseconds or microseconds in your writes? What’s your exact DTCS config for 
that table?

3.10 has TWCS, too, which may be considerably easier to use. It also uses 
timestamp units in its config, so you’ll need to know which resolution you’re 
using on writes


-- 
Jeff Jirsa


> On Jul 4, 2018, at 11:08 AM, Anshul Rathore <anshulrathor...@gmail.com> wrote:
> 
> 
> 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.
> 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

Reply via email to