concurrent sstable read

2022-10-25 Thread Grzegorz Pietrusza
HI all I can't find any information about how cassandra handles reads involving multiple sstables. Are sstables read concurrently or sequentially? Is read latency directly connected to the number of opened sstables? Regards Grzegorz

Re: TWCS recommendation on number of windows

2022-09-28 Thread Grzegorz Pietrusza
timestamps and bloom filter will avoid touching > most of them on the read path anyway. If your data model doesnt have a > timestamp component to it and you're touching lots of sstables on read, > even 30 sstables is probably going to hurt you, and 210 would be really, > really bad. >

TWCS recommendation on number of windows

2022-09-28 Thread Grzegorz Pietrusza
Hi All! According to TWCS documentation ( https://cassandra.apache.org/doc/latest/cassandra/operating/compaction/twcs.html) the operator should choose compaction window parameters to select a compaction_window_unit and compaction_window_size pair that produces approximately 20-30 windows. I'm

estimated number of keys vs ttl

2018-05-23 Thread Grzegorz Pietrusza
Hi I'm using tablestats to get estimated number of partitioning keys. In my case all writes are done with TTL of a few days. Is the key count decreased when TTL hits? Regards Grzegorz

Re: Grafana data stored in a Cassandra database

2018-05-09 Thread Grzegorz Pietrusza
https://kairosdb.github.io 2018-05-09 19:43 GMT+02:00 Peter Sanford : > This project implements the graphite api on top of Cassandra and can be > used from grafana: > > https://github.com/pyr/cyanite > > On Wed, May 9, 2018 at 10:39 AM dba newsql

Re: read repair with consistency one

2018-04-25 Thread Grzegorz Pietrusza
. > I expect this mechanism would still apply for CL=ONE. > > > Cheers > Ben > > On Sat, 21 Apr 2018 at 22:20 Grzegorz Pietrusza <gpietru...@gmail.com> > wrote: > >> I haven't asked about "regular" repairs. I just wanted to know how read >> repair

Re: read repair with consistency one

2018-04-21 Thread Grzegorz Pietrusza
s another. > If you do repairs via Reaper or your own method it will resolve your > discrepencies. > > On Apr 21, 2018, 3:16 AM -0400, Grzegorz Pietrusza <gpietru...@gmail.com>, > wrote: > > Hi all > > I'm a bit confused with how read repair wo

read repair with consistency one

2018-04-21 Thread Grzegorz Pietrusza
Hi all I'm a bit confused with how read repair works in my case, which is: - multiple DCs with RF 1 (NetworkTopologyStrategy) - reads with consistency ONE The article #1 says that read repair in fact runs RF reads for some percent of the requests. Let's say I have read_repair_chance = 0.1. Does

tablestats and gossip

2018-04-06 Thread Grzegorz Pietrusza
Hi all Does local write count provided by tablestats include writes from gossip?