> One thing I am noticing is that cache hit rate is very low even though my > cache key size is 1M and I have less than 1M rows. Not sure why so many > cache miss?
The key cache should be strictly LRU for read-only workloads. For write/read workloads it may not be strictly LRU because compaction causes key cache migration. In your case: > Key cache capacity: 1000000 > Key cache size: 256013 > Key cache hit rate: 0.33801452784503633 So you have only 256k in the cache. Have you run for long enough after enabling it for it to actually be fully populated? -- / Peter Schuller