I have a 8 nodes cluster, MemtableThreshold is 2 GB/CF, MemtableObjectsCount is 1.2, heap (min/max) is 30 GB and only 4 ColumnFamilies
It appears from system.log that flush happens for every < 50 operations (read or write) and compaction is happening very frequently and i could see lots of sstable is getting created (with smaller size). For a just 1000 inserts, i could see around 20 sstables.
When i change the MemtableThreshold to 1 GB/CF, everything works as desired.
Any idea, what could be the problem when i specify MemtableThreshold to 2 GB/CF even though i specified the large heap?