I am making this query with request_cache=true { "query": { "bool": { "should": [ { "term": { "status": "online" } }, { "term": { "status": "available" } }, { "term": { …

can you share your full query? Keep in mind that such queries are only cached if size: 0 is specified. See https://www.elastic.co/guide/en/elasticsearch/reference/7.5/shard-request-cache.html

@spinscale Do I need to specify size:0 explicitly ?

yes, otherwise you will retrieve 10 hits by default

@spinscale Thanks for your reply. Can you please guide me. How to get the hits also with caching enabled. I have checked that we have to specify size: 0 but I need hits as a primary objective of this query. Can we change the query a little bit to get hits and also enable caching.

the shard query cache will not help you then. However there is a second cache named the node query cache, that can speed up queries and does not need to be activated, as it has some heuristics to figure out when it should be used. See https://www.elastic.co/guide/en/elasticsearch/reference/7.5/quer…

@spinscale I also think shard query cache cannot be used. I need caching to make queries faster. Since i have a lot of queries which are same so I thought of enabling the cache. I do have refresh interval: 1m Can you help with any resource to optimize queries and datamodels. I actually don't need…

[image] royal_man: { "query": { "bool": { "should": [ { "term": { "status": "online" } }, { "term": { "status": "available" } }, { "term": { "status": "admin" } } ] } } } @royal_man to ur use case talking above, only file-system-cache can help. Just change or append the index setting, with e…

Thanks @DeeeFOX I will try the idea and reply here about the performance

Ahhh, sorry for forgetting to remind u, one more thing u should set to enable the preload settings: the index store type , by default is "hybridfs", and to our tsdb-use-case : { "settings": { "index": { ... "store": { "type": "mmapfs", "preload": [ "doc", …

Query cache gets invalidated

Elastic Stack Elasticsearch

royal_man January 24, 2020, 1:00pm 10

@DeeeFOX
I have tried the filesystem preload and monitored the RAM cache and but there is no change in it.
I have ES data node in k8s node (60Gi RAM). Below is the RAM usage graph. I have actually allocated 50Gi to ES node. I think RAM free includes the 10Gi RAM that is not allocated.
What do you think ?

Topic		Replies	Views
Shard query cache size Elasticsearch	6	649	July 6, 2017
Very few shard query cache hits Elasticsearch	4	3199	July 5, 2017
Better control over the request cache Elasticsearch	4	1529	July 5, 2017
Query cache Elasticsearch	1	461	July 5, 2017
Caching query results Elasticsearch	1	295	April 12, 2021

Query cache gets invalidated

Related topics