question

rajib76 avatar image
rajib76 asked Erick Ramirez edited

Why are we not seeing key cache hits in our DSE cluster?

We are running our read workload on DSE cassandra but not seeing any key cache hit...

I was thinking that we will see some key cache hit, but it is zero

dse
1 comment
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

steve.lacerda avatar image steve.lacerda ♦ commented ·
Can you provide the output of nodetool info in your question?
0 Likes 0 ·

1 Answer

yukim avatar image
yukim answered

DSE 6.0 and above started to use the new index format for SSTable files:

  • Partition Index (Partition.db file)
  • Row Index (Row.db file)

https://docs.datastax.com/en/dse/6.8/dse-arch/datastax_enterprise/dbInternals/dbIntHowDataWritten.html#StoringdataondiskinSSTables

Using these index files, DSE can look up the records inside SSTable files, so DSE does not need to use key cache at all.

DSE 5.1 and open source Apache Cassandra use Index.db file which just records partition key and its position in the data file, and use key cache to look it up faster.

So if you are using DSE 5.1, then you should see key cache hit, but if you are using DSE 6.0 or above then key cache hit is always 0.

DSE 6.0 and above still show key cache metrics since those can still be used when you are upgrading from DSE 5.1 or open source Apache Cassandra and SStable files are not upgraded yet, but other than that, you should see 0s for ke y cache metrics.

Share
10 |1000
Toggle Comment visibility. Current Visibility: Viewable by all users

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