Thanks Paulo! I'll give it a try and let you know.
-----"Paulo Motta" <pauloricard...@gmail.com> schrieb: ----- An: user@cassandra.apache.org Von: "Paulo Motta" <pauloricard...@gmail.com> Datum: 03.12.2020 13:39 Betreff: Re: Increased read latency with Cassandra >= 3.11.7 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 --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org
