To add onto this message:
Queries are all on the partition key (select
origvalue,ingestdate,mediatype from doc.origdoc where uuid=?). Queries
were very fast when the table was <10 million rows.
Table description:
describe doc.origdoc;
CREATE TABLE doc.origdoc (
uuid text,
I have an 11 node cluster and am experiencing high read latency on one
table. This table has ~112 million rows:
nodetool tablehistograms doc.origdoc
doc/origdoc histograms
Percentile Read Latency Write Latency SSTables Partition
Size Cell Count
Thanks Bowen!
Sushanta
On Fri, Nov 19, 2021 at 4:01 PM Bowen Song wrote:
> This could be two questions with different answers:
>
>
> 1. Is there anyone / who is connected to the Cassandra server right now?
>
> Use the netstat or ss command and check the active TCP connections on
> native