Hi Flavien,
I hit some problem with minor compations recently (just some days ago) -
but with many more tables. In my case compactions got not triggered, you
can check this with nodetool compactionstats.
Reason for me was that those minor compactions did not get triggered
since there were almost no reads on that tables. Setting
'cold_reads_to_omit' to 0 did the job for me:
ALTER TABLE <tablename> WITH compaction = {'class':
'SizeTieredCompactionStrategy', 'min_threshold': '4', 'max_threshold': '32',
'cold_reads_to_omit': 0.0};
Credits to Tyler and Eric for the pointers.
Cheers,
Roland