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 ·

Cassandra slow read operation

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

cassandra read
1 comment
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 · ·

1 Answer

chintan.mehta_171756 avatar image
chintan.mehta_171756 answered ·

Hello Alex please check below 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)

AND bloom_filter_fp_chance = 0.01

AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}

AND comment = ''

AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}

AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}

AND crc_check_chance = 1.0

AND dclocal_read_repair_chance = 0.1

AND default_time_to_live = 0

AND gc_grace_seconds = 0

AND max_index_interval = 2048

AND memtable_flush_period_in_ms = 0

AND min_index_interval = 128

AND read_repair_chance = 0.0

AND speculative_retry = '99PERCENTILE';


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.