incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DuyHai Doan <doanduy...@gmail.com>
Subject Re: Tune cache MB settings per table.
Date Sun, 01 Jun 2014 19:55:25 GMT
Hello Kevin

 You'll be probably interested by this :
http://www.datastax.com/dev/blog/row-caching-in-cassandra-2-1


On Sun, Jun 1, 2014 at 9: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
> <https://plus.google.com/102718274791889610666/posts>
> <http://spinn3r.com>
> War is peace. Freedom is slavery. Ignorance is strength. Corporations are
> people.
>
>

Mime
View raw message