Re: High read rate on hard-disk

2018-01-18 Thread Octavian Rinciog
Hy Alain, Thank you for your response. > - Other than the 'lock', Counters perform an implicit read before the write > operation. >From what I know there is one counter cache[1], that is used to read the old values of the counters. According to [2], it is used only for UPDATE requests > I woul

Re: High read rate on hard-disk

2018-01-18 Thread Alain RODRIGUEZ
Hello Octavian, > I have a counter table(RF=1) SELECT vs UPDATE requests ratio is 0.001. ( Read Count: 3771000, Write Count: > 3401236000, in one month) SELECT vs UPDATE requests ratio is 0.001. ( Read Count: 3771000, Write > Count: 3401236000, in one month) The problem is that our read rat

High read rate on hard-disk

2018-01-17 Thread Octavian Rinciog
Hello! I am using Cassandra 3.10, on Ubuntu 14.04 and I have a counter table(RF=1), with the following schema: CREATE TABLE edges ( src_id text, src_type text, source text weight counter, PRIMARY KEY ((src_id, src_type), source) ) WITH compaction = {'class': 'org.apache.cas