I have a case with very narrow rows. As such I have a large row cache that does nicely handles > 50% of requests. I think it's likely that the current tradeoff between page cache and row cache is reasonable. Using a key cache doesn't make sense in this instance. However, a third option is to adjust the IndexInterval [1] [2].
It would theoretically be reasonable to: - Increase the IndexInterval to make more memory available for row or page cache. - Decrease the IndexInterval for more effective sampling. When the knob could be turned either direction it's hard to know which way to start. Does anyone have any experince succesfully adjusting the IndexInterval for improved performance with narrow rows? [1] https://issues.apache.org/jira/browse/CASSANDRA-1488 [2] http://www.datastax.com/dev/blog/whats-new-cassandra-066
