Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

chintan.mehta_171756 avatar image
chintan.mehta_171756 asked ·

Why is my read operation very slow?

Hello, I have total 12 node cluster for 6 nodes and 6 nodes divided in two racs with two datacenter. my read and write consistancy level is one and my read operation is very slow so what would be best read and write consistancy level should i configure and what are the other parameters which i need to update in my cassandra.yaml. Let me know if anybody need further details

[UPDATE] Table schema:

CREATE TABLE hhahistory.history (
  tablename text,
  columnname text,
  dateyearpart bigint,
  tablekey bigint,
  updateddate timestamp,
  historyid bigint,
  appname text,
  audittype text,
  createddate timestamp,
  dbname text,
  dbsession uuid,
  firstname text,
  historybatch uuid,
  historycassandraid uuid,
  hostname text,
  isvlm boolean,
  lastname text,
  loginname text,
  newvalue text,
  notes text,
  oldvalue text,
  reason text,
  updatedby text,
  updatedutcdate timestamp,
  PRIMARY KEY ((tablename, columnname, dateyearpart), tablekey, updateddate, historyid)
) WITH CLUSTERING ORDER BY (tablekey ASC, updateddate ASC, historyid ASC)
performance
2 comments
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

please provide the schema for the table, what queries you're executing, etc.

0 Likes 0 ·

Hello Alex please check below schema

[Update posted in question body]

[Answer converted to comment]

0 Likes 0 ·

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

[Post closed since there is insufficient information provided to diagnose the problem]

Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.