版本:5.1.1 , 一共4个节点,其中3个节点:master和data都为true,剩下的一个为false,每个节点分片了8G,3个分片,1个副本,总共文档也就3w多条,单线程访问很快,但是我开了1000个线程跑的情况下,开始会很快,后来就越来越慢达到5s多,甚至更慢。
具体DSL:
GET /shop_index/_search
{
"from" : 0,
"size" : 10,
"query" : {
"bool" : {
"filter" : [
{
"term" : {
"shopStatus" : {
"value" : 2,
"boost" : 1.0
}
}
},
{
"term" : {
"cityId" : {
"value" : "1930",
"boost" : 1.0
}
}
}
],
"must_not" : [
{
"term" : {
"id" : {
"value" : 10556,
"boost" : 1.0
}
}
}
],
"disable_coord" : false,
"adjust_pure_negative" : true,
"boost" : 1.0
}
},
"ext" : { }
}
请问下我该怎么优化查询
具体DSL:
GET /shop_index/_search
{
"from" : 0,
"size" : 10,
"query" : {
"bool" : {
"filter" : [
{
"term" : {
"shopStatus" : {
"value" : 2,
"boost" : 1.0
}
}
},
{
"term" : {
"cityId" : {
"value" : "1930",
"boost" : 1.0
}
}
}
],
"must_not" : [
{
"term" : {
"id" : {
"value" : 10556,
"boost" : 1.0
}
}
}
],
"disable_coord" : false,
"adjust_pure_negative" : true,
"boost" : 1.0
}
},
"ext" : { }
}
请问下我该怎么优化查询
5 个回复
Jea - 一只猿
赞同来自:
Ricky_Lau - 码农,,
赞同来自:
fredchen
赞同来自:
hahahaw - 90后IT男
赞同来自:
weizijun - elasticsearch fan
赞同来自: