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 Re: IndexInterval Tuning
Date Tue, 05 Apr 2011 15:08:09 GMT
On 04/05/2011 09:57 AM, Jonathan Ellis wrote:
> On Tue, Apr 5, 2011 at 8:54 AM, Jonathan Ellis <jbellis@gmail.com> wrote:
>> Adjusting indexinterval is unlikely to be useful on very narrow rows.
>> (Its purpose is to make random access to _large_ rows doable.)
> 
> Whoops, that's column_index_size_in_kb.
> 
> I'd play w/ keycache before index_interval personally.  (If you can
> get 100% key cache hit rate it doesn't really matter what index
> interval is, as long as you can still build the cache effectively.)


I've already tried a key cache equal to and larger (up to what I have
heap space for) than my current row cache.  But for very narrow rows the
row cache is empirically and theoretically better.

I realise changing IndexInterval is an unusual proposed configuration,
but such is the burden of high cardinality narrow rows.

Mime
View raw message