As a workaround if your TWCS table is append-only (no updates or deletions) you could try enabling unsafe_aggressive_sstable_expiration (see https://cassandra.apache.org/doc/latest/operating/compaction/twcs.html) so inactive sstables will be expired faster and will not be included during reads.
Em qui., 3 de dez. de 2020 às 09:33, Paulo Motta <pauloricard...@gmail.com> escreveu: > I think this could've been caused by > https://issues.apache.org/jira/browse/CASSANDRA-15690 which was > introduced on 3.11.7 and removed an optimization that may cause a > correctness issue when there are partition deletions. I'd suggest you to > open an issue at https://issues.apache.org/jira/projects/CASSANDRA/issues > to call attention to this regression to see if there's anything that can be > done when the workload has no partition deletions. Make sure to include > details about your workload (schema, replication settings, CL, query, etc) > to facilitate investigation. > > Em qua., 2 de dez. de 2020 às 12:44, Nicolai Lune Vest < > nicolai.v...@lancom.de> escreveu: > >> Hi, >> >> we performed a test run with 3.11.9. Unfortunately we do not experience a >> difference regarding increased read latency at some of our tables. >> >> Do others experience the same or similar behavior and probably do have a >> solution? >> >> Kind regards, >> Nico >> >> -----"Nicolai Lune Vest" <nicolai.v...@lancom.de> schrieb: ----- >> An: user@cassandra.apache.org >> Von: "Nicolai Lune Vest" <nicolai.v...@lancom.de> >> Datum: 06.11.2020 09:14 >> Betreff: Antwort: Increased read latency with Cassandra >= 3.11.7 >> >> >> >> Hi, >> >> thanks for your interests! >> >> We use TWCS and LCS and see only TWCS effected by the update regarding >> higher latencies (as well as increased SSTable reads and bloom filter false >> positives). >> >> We did not update to 3.11.9 as of now but probably will give it a try >> within the next two or tree weeks. I'll let you know about the results. >> >> Cheers >> Nico >> >> -----"Jai Bheemsen Rao Dhanwada" <jaibheem...@gmail.com> schrieb: ----- >> An: "user@cassandra.apache.org" <user@cassandra.apache.org> >> Von: "Jai Bheemsen Rao Dhanwada" <jaibheem...@gmail.com> >> Datum: 05.11.2020 17:36 >> Betreff: Increased read latency with Cassandra >= 3.11.7 >> >> Hello Nicolai, >> >> >> I am also looking to upgrade to 3.11.8. Is the latency you noticed is >> only with TWCS? And others looks good? >> >> On Thursday, November 5, 2020, Ahmed Eljami <ahmed.elj...@gmail.com> >> wrote: >> >> +1 >> I would also be interested to know if the 3.11.9 provide any improvement >> for your case. >> Cheers. >> >> >> >> Le mer. 4 nov. 2020 à 14:53, Johannes Weißl <jar...@molb.org> a écrit : >> >> Hi Nico, >> >> On Mon, Sep 14, 2020 at 03:51PM +0200, Nicolai Lune Vest wrote: >> > after upgrading my Cassandra nodes from version 3.11.6 to either >> > 3.11.7 or 3.11.8 I experience a significant increase in read latency. >> >> Have you (or others) any update on that? Does the version 3.11.9 >> released today provide any improvement? >> >> Thanks, >> Johannes >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org >> For additional commands, e-mail: user-h...@cassandra.apache.org >> >> >> >> >> -- >> >> Cordialement; >> >> >> Ahmed ELJAMI >> >> >> >> >> >> >> >> LANCOM Systems GmbH >> Adenauerstr. 20 / B2 >> 52146 Würselen >> Deutschland >> >> Tel: +49 2405 49936-0 >> Fax: +49 2405 49936-99 >> >> Web: https://www.lancom-systems.de >> >> >> >> Geschäftsführer: Ralf Koenzen, Stefan Herrlich >> Sitz der Gesellschaft: Aachen, Amtsgericht Aachen, HRB 16976 >> >> >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org >> For additional commands, e-mail: user-h...@cassandra.apache.org >> >>
