I have a performance issue with TSVB dashboard with 70 millions records and more (TSVB | Kibana Guide [8.13] | Elastic)
I have applied rollover index in ILM, so caching can be used for normal query (request_cache = true), but for TSVB, I have not and found the way to set it
Do you know:
the way to set cache for TSVB
or the way to optimize the performance
here is one chart in TSVB
Dear @stephenb , thank you for your attention
we are doing "sum" on some field
We must scan all records, so no filter can be applied
Do you have any suggest about caching or any approach?
"lens" => I will try it
@stephenb , good morning, here are the detail information
What is the performance you are seeing?
=> My index has more than 400 fields, in one dashboard I need to load 10 TSVB charts which aggregate information from some fields
The time for loading 1 TSVB chart is short (~1s) but for 10 charts at time: error (more than 10s)
What is the total size of the index?
total size: 74 millions records ~ 70GB (cluster has 3 primary shard + 1 replica for each primary)
What are the specs and JVM heap for the cluster?
CPU: 14, RAM: 16G, SSD: 120G
=> this specs is good for total size = 40G (time for loading 10 charts is smaller than 10s)
but for more than 50G, there are errors
I would like to apply caching before thinking upgrade the specs (more CPU, RAM) because the cost is high
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.