The default minthreshold for compactions is 4: http://www.datastax.com/docs/1.1/references/nodetool#nodetool-setcompactionthreshold
Is there a reason that this value is not "2", the lowest possible value? If we change this to 2 what should we expect to see? Should we see less growth in storage load and fewer files to seek through when reading but at the cost of higher CPU usage? Thanks, Peter
