incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Burroughs <chris.burrou...@gmail.com>
Subject IndexInterval Tuning
Date Tue, 05 Apr 2011 01:38:25 GMT
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

Mime
View raw message