[Moving to users list]
The most important thing will be to reduce your JVM heap size. Cassandra
will automatically reduce pool sizes as you do that. Disabling key cache
and row cache will help you get that even smaller.
On Tue, Jun 21, 2016 at 5:21 AM, Sumit Anvekar <sumit.anve...@gmail.com>
wrote:
> Hello,
> We are using Cassandra 3.0.7 version and off late we see that 90% of
> memory is occupied even though hard-drive is hardly used. We have a cluster
> of 5 nodes with 15 GB memory, 4 cores, 200 GB SSD.
>
> We tried all kind of configurations through both YAML as well as table
> based properties but none seem to help. Memory usage constantly increases
> almost in direct ratio of data.
>
> What we are trying to do is, utilize as less memory as possible and we are
> okay with reduced read performance. Application is write intensive. To do
> this, our idea was to disable all caches possible, to avoid keeping
> anything not-necessary in memory.
>
> ​Find attached our yaml and table configuration.
>
> CREATE KEYSPACE if not exists test_ks WITH replication = {'class':
> 'SimpleStrategy', 'replication_factor': '1'};
> CREATE TABLE if not exists test_ks.test_cf (id bigint PRIMARY KEY,key_str
> text,value1 int,value2 int,update_ts bigint) WITH bloom_filter_fp_chance =
> 1 AND comment = '' AND compaction = {'class':
> 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
> 'max_threshold': '32', 'min_threshold': '4'} AND compression =
> {'chunk_length_in_kb': '64', 'class':
> 'org.apache.cassandra.io.compress.LZ4Compressor'} AND crc_check_chance =
> 1.0 AND dclocal_read_repair_chance = 0.1 AND default_time_to_live = 0 AND
> gc_grace_seconds = 864000 AND max_index_interval = 10240 AND
> memtable_flush_period_in_ms = 3600000 AND min_index_interval = 10240 AND
> read_repair_chance = 0.0 AND speculative_retry = '99PERCENTILE' AND caching
> = {'keys': 'NONE', 'rows_per_partition': 'NONE'};
>
> Has anyone tried such configuration before? Please let us know if
> disabling cache would help us in this situation. And if yes, how we can
> disable cache completely.
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder, http://www.datastax.com
@spyced
