incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Colin <co...@clark.ws>
Subject Re: Tune cache MB settings per table.
Date Sun, 01 Jun 2014 19:53:22 GMT
The OS should handle this really well as long as your on v3 linux kernel....  

--
Colin Clark 
+1-320-221-9531
 

> On Jun 1, 2014, at 2:49 PM, Kevin Burton <burton@spinn3r.com> wrote:
> 
> It's possible to set caching to:
> 
> all, keys_only, rows_only, or none
> 
> .. for a given table.
> 
> But we have one table which is MASSIVE and we only need the most recent 4-8 hours in
memory.  
> 
> Anything older than that can go to disk as the queries there are very rare.
> 
> … but I don't think cassandra can do this (which is a shame).
> 
> Another option is to partition our tables per hour… then tell the older tables to cache
'none'… 
> 
> I hate this option though.  A smarter mechanism would be to have a compaction strategy
that created an SSTable for every hour and then had custom caching settings for that table.
> 
> The additional upside for this is that TTLs would just drop the older data in the compactor..

> 
> -- 
> Founder/CEO Spinn3r.com
> Location: San Francisco, CA
> Skype: burtonator
> blog: http://burtonator.wordpress.com
> … or check out my Google+ profile
> 
> War is peace. Freedom is slavery. Ignorance is strength. Corporations are people.

Mime
View raw message