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: concurrent sstable read

2022-10-25 Thread Jeff Jirsa
Sequentially, and yes - for some definition of "directly" - but not just because it's sequential, but also because each sstable has cost in reading (e.g. JVM garbage created when you open/seek that has to be collected after the read) On Tue, Oct 25, 2022 at 8:27 AM Grzegorz Pietrusza wrote: > HI

Re: Denylisting with a composite partition key

2022-10-25 Thread Aaron Ploetz
Works! So I was running on my *local*, and all of my attempts to add to the denylist were failing because the denylist_consistency_level was set to QUORUM: WARN [main] 2022-10-25 11:57:27,238 NoSpamLogger.java:108 - Attempting to load denylist and not enough nodes are available for a QUORUM refr

Re: Denylisting with a composite partition key

2022-10-25 Thread Cheng Wang via user
Awesome! That's great to hear! Pls feel free to let me know if you have any questions! Thanks, Cheng On Tue, Oct 25, 2022 at 10:36 AM Aaron Ploetz wrote: > Works! > > So I was running on my *local*, and all of my attempts to add to the > denylist were failing because the denylist_consistency_le

Re: Denylisting with a composite partition key

2022-10-25 Thread Cheng Wang via user
and yes, you need to set the consistency level to ONE in the cassandra.yaml if it's running in your local machine denylist_consistency_level: ONE On Tue, Oct 25, 2022 at 10:41 AM Cheng Wang wrote: > Awesome! That's great to hear! > Pls feel free to let me know if you have any questions! > > Th