es版本号6.8.1,一台物理机部署了五个节点,每个节点的jvm内存设置成了31G,物理机内存大小为512G,索引大小130G,12亿条数据,第一次查询时间几十秒,后面就是毫秒级了,做了些预加载的设置(index.store.preload: ["nvd", "dvd", "tim", "doc", "dim"]),但好像不起作用,DSL语句:{
"size": 0,
"query": {
"bool": {
"filter": []
}
},
"aggregations": {
"STATION_ID": {
"terms": {
"field": "STATION_ID",
"size": 1000,
"missing": -999
},
"aggregations": {
"STATION_NAME": {
"terms": {
"field": "STATION_NAME",
"size": 1000,
"missing": "#NULL"
},
"aggregations": {
"8ffa06de": {
"sum": {
"field": "STATION_ID"
}
}
}
}
}
}
}
}
本人刚接触es,原理还是不太懂,请大神帮忙解答一下该如何提高首次的查询速度。
"size": 0,
"query": {
"bool": {
"filter": []
}
},
"aggregations": {
"STATION_ID": {
"terms": {
"field": "STATION_ID",
"size": 1000,
"missing": -999
},
"aggregations": {
"STATION_NAME": {
"terms": {
"field": "STATION_NAME",
"size": 1000,
"missing": "#NULL"
},
"aggregations": {
"8ffa06de": {
"sum": {
"field": "STATION_ID"
}
}
}
}
}
}
}
}
本人刚接触es,原理还是不太懂,请大神帮忙解答一下该如何提高首次的查询速度。
3 个回复
JiangJibo - 喊我雷锋
赞同来自:
Kevin_Chow
赞同来自:
官网URL+/guide/en/elasticsearch/reference/current/shard-request-cache.html
RuiLiu
赞同来自: