Re: tablehistogram shows high sstables
17ms read latency for the 50th percentile is actually a pretty high latency in my experience, I prefer to see the 75th percentile read latency to be around 1-2ms. Of course it depends on your use case and what your performance objectives are. On Thu, Apr 29, 2021 at 7:05 AM Kane Wilson wrote: > It does imply the SSTables are being read - how big is your data size and > how much memory on the nodes? It's certainly possible to get low latencies > despite many SSTables, but I'd expect small read sizes paired with a lot of > memory. > > > raft.so - Cassandra consulting, support, managed services > > On Thu., 29 Apr. 2021, 08:44 Ayub M, wrote: > >> The table has 24 sstables with size tiered compaction, when I run >> nodetool tablehistograms I see 99% percentile of the queries are showing up >> 24 as the number of sstables. But the read latency is very low, my >> understanding from the tableshistograms's sstable column is - it shows how >> many sstables were read to complete the query. If so reading 24 sstables >> should take sometime, at least maybe couple of seconds. Am I missing >> something here? Does checking against index/bloom filters count towards >> sstable counter as well? >> >> Percentile SSTables Write Latency Read LatencyPartition Size >> Cell Count >> (micros) (micros) (bytes) >> 50%24.00 17.08 17436.92 310 >> 6 >> 75%24.00 24.60 20924.30 446 >> 6 >> 95%24.00 42.51 62479.63 770 >> 10 >> 98%24.00 51.01 74975.55 1597 >> 17 >> 99%24.00 61.21 74975.55 3311 >> 24 >> Min18.00 2.30 4866.3287 >> 0 >> Max24.00943.13 89970.66545791 >> 17084 >> >>
RE: Cassandra 3.11 cqlsh doesn't work with latest JDK
Try adding this into the SSL section of your cqlshrc file: version = SSLv23 Sean Durity From: Maxim Parkachov Sent: Friday, April 30, 2021 8:57 AM To: user@cassandra.apache.org; d...@cassandra.apache.org Subject: [EXTERNAL] Cassandra 3.11 cqlsh doesn't work with latest JDK Hi everyone, I have Apache Cassandra 3.11.6 with SSL encryption, CentOS Linux release 7.9, python 2.7.5. JDK and python are coming from operating system. I have updated today operating system and with that I've got new JDK $ java -version openjdk version "1.8.0_292" OpenJDK Runtime Environment (build 1.8.0_292-b10) OpenJDK 64-Bit Server VM (build 25.292-b10, mixed mode) Now when I try to connect to my local instance of Cassandra with cqlsh I'm getting error: $ cqlsh --ssl -u cassandra -p cassandra Connection error: ('Unable to connect to any servers', {'127.0.0.1': error(1, u"Tried connecting to [('127.0.0.1', 9142)]. Last error: [SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:618)")}) Apparently, latest release of JDK *_292 disabled TLS1.0 and TLS1.1. Is this known issue ? Is there is something I could do to quickly remedy the situation ? Thanks in advance, Maxim. The information in this Internet Email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Email are subject to the terms and conditions expressed in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot disclaims all responsibility and liability for the accuracy and content of this attachment and for any damages or losses arising from any inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other items of a destructive nature, which may be contained in this attachment and shall not be liable for direct, indirect, consequential or special damages in connection with this e-mail message or its attachment.
Cassandra 3.11 cqlsh doesn't work with latest JDK
Hi everyone, I have Apache Cassandra 3.11.6 with SSL encryption, CentOS Linux release 7.9, python 2.7.5. JDK and python are coming from operating system. I have updated today operating system and with that I've got new JDK $ java -version openjdk version "1.8.0_292" OpenJDK Runtime Environment (build 1.8.0_292-b10) OpenJDK 64-Bit Server VM (build 25.292-b10, mixed mode) Now when I try to connect to my local instance of Cassandra with cqlsh I'm getting error: $ cqlsh --ssl -u cassandra -p cassandra Connection error: ('Unable to connect to any servers', {'127.0.0.1': error(1, u"Tried connecting to [('127.0.0.1', 9142)]. Last error: [SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:618)")}) Apparently, latest release of JDK *_292 disabled TLS1.0 and TLS1.1. Is this known issue ? Is there is something I could do to quickly remedy the situation ? Thanks in advance, Maxim.