How to reduce elasticsearch high load average/cpu usage?

Elastic Stack Elasticsearch
3

Thanks for your advice.:slight_smile:

I use a quite complex query like that, which includes function score:

"script_score": {
"script":
"((doc['updatetime'].value>1411574400000?1411574400000:doc['updatetime'].value)/1000)+(_score43200>43200?43200:_score43200)+(doc['column1'].value==1?14400:0)

  • (doc['column2'].value==3?7200:0) +
    (doc['column2'].value==7?3600:0)+((doc['updatetime'].value>1411574400000?1411574400000-doc['updatetime'].value:doc['updatetime'].value-1411574400000)/60000)",
    "lang": "groovy"
    },

The plugin used is an analyzer for chinese.

在 2014年9月24日星期三UTC+8下午2时21分56秒，David Pilato写道：

Sounds like you are using a plugin, right?
Also you seem to run function score queries. How your queries look like?

Then, it's better to use GIST to attach long logs/files instead of pasting
them here.

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 sept. 2014 à 08:13, 林 <lamho...@gmail.com <javascript:>> a écrit :

I am a developer from CHINA, i was suffering from load average
recently,which range is 2-5 .I have 5 clustered nodes and each nodes have 1
replica,the cluster total document size is 2G and 2,000,000 docs.

Here are some relevant information:

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/905e539a-ffa4-46a3-b348-a4b388871b66%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.