incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kevin Burton <bur...@spinn3r.com>
Subject Tune cache MB settings per table.
Date Sun, 01 Jun 2014 19:49:01 GMT
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