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
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
DSE 6.0 and above started to use the new index format for SSTable files:
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.
8 People are following this question.