We're running a Cassandra 2.2.0 cluster with 8 nodes. We are doing frequent
updates to our data and we have very few reads, and we are using Leveled
Compaction with a sstable_size_in_mb of 160MB. We don't have that much data
currently since we're just testing the cluster.
We are seeing the SSTable count linearly increase even though `nodetool
compactionhistory` shows that compaction have definitely ran. When I ran
nodetool cfstats, I get the following output:
SSTable count: 56
SSTables in each level: [1, 0, 0, 0, 0, 0, 0, 0, 0]
Does it make sense that there is such a huge difference between the number
of SStables in each level and the total count of SStables? It seems like
old SSTables are lying around and never cleaned-up/compacted. Does this
theory sound plausible? If so, what could be the problem?