the query cache statistics of my cluster contain following values:
"query_cache": {
"memory_size_in_bytes": 113744184,
"total_count": 394174905,
"hit_count": 17192100,
"miss_count": 376982805,
"cache_size": 6859,
"cache_count": 59078,
"evictions": 52219
}
I was wondering what these values really mean.
In other words, is this cache overused or rather underused.
And if it is underused what options do we have? Increasing indices.queries.cache.size?
Below are the current values. As you can see, after almost 18 hours the memory_size_in_bytes dropped 50% while miss_count increased significantly. Evictions increased but not much.
We have filter queries that take a long time to execute. As I understood such queries are using the cache, therefore I was wondering if the cache settings play a role here.
The queries are using range conditions on date fields, in some cases "lt" < "now"
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.