Take a look at the very recent thread called 'Alternate "major compaction"'. There are some ideas in there about splitting up a large SSTable.
http://www.mail-archive.com/user@cassandra.apache.org/msg30956.html On 07/17/2013 04:17 PM, Langston, Jim wrote: > Hi all, > > Is there a way to get an SSTable to a smaller size ? By this I mean > that I > currently have an SSTable that is nearly 1.2G, so that subsequent SSTables > when they compact are trying to grow to that size. The result is that > when > the min_compaction_threshold reaches it value and a compaction is needed, > the compaction is taking a long time as the file grows (it is > currently at 52MB and > takes ~22s to compact). > > I'm not sure how the SSTable initially grew to its current size of > 1.2G, since the > servers have been up for a couple of years. I hadn't noticed until I > just upgraded to 1.2.6, > but now I see it affects everything. > > > Jim -- *Colin Blower* /Software Engineer/ Barracuda Networks Inc. +1 408-342-5576 (o)