I feel like similar questions have been asked recently but not in this specific way:
I have a cluster that has some I/O capacity issues, which I know is what's really causing this, but I've got the case where (using leveled compaction strategy) my SSTables are piling up at the lowest level. In some cases it's even enough to cause Cassandra to crash due to not having enough available open file handles (by which I mean my cfstats output for the problem child table ends up looking something like 114000/4, 10/10, 98, 0, 0, 0). My question is this: Is there a command that I'm missing that I could use to force that node to do compaction on those tables and clean up some of the thousands of 100-500byte tables while Cassandra itself is offline? I've got plenty of disk space so that's not an issue. I'm running Cassandra 2.0.9. -- Josh
