question

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)
performance
2 comments
10 |1000

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

alex.ott avatar image alex.ott commented ·

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

0 Likes 0 ·
chintan.mehta_171756 avatar image chintan.mehta_171756 commented ·

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

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