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



chintan.mehta_171756 avatar image
chintan.mehta_171756 asked Erick Ramirez answered

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)
10 |1000

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]

10 |1000

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