cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Octavian Rinciog <octavian.rinc...@gmail.com>
Subject Best compaction strategy for counters tables
Date Wed, 17 Jan 2018 16:14:44 GMT
Hello!
I am using Cassandra 3.10.
I have a counter table, with the following schema and RF=1

CREATE TABLE edges (
    src_id text,
    src_type text,
    source text
    weight counter,
    PRIMARY KEY ((src_id, src_type), source)
);

SELECT vs UPDATE requests ratio for this table is 0.1
READ vs WRITE rate, given by iostat is 100:1.
Counter cache hit rate is 80%, so only for 20% UPDATE requests, the
hard-disk is touched.

I want to ask you which compation strategy is best for this table
(SizeTieredCompactionStrategy or
LeveledCompactionStrategy).

Thank you,
-- 
Octavian Rinciog

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org


Mime
View raw message