I have a setup of 3 Graylog Nodes and 5 ES nodes. The search queries in my setup take about 400ms- 500ms to execute. Can you help with speeding up the execution time?
For legibility, could you please go back and edit your post? Select the copy/pasted CURL-stuff and hit that </> button. This makes for much nicer formatting.
I have a setup of 3 Graylog Nodes and 5 ES nodes. The search queries in my setup take about 400ms- 500ms to execute. Can you help with speeding up the execution time?
The amount of nodes you have is only one fraction of the whole puzzle
How big is your whole data set?
How many indexes do you have?
What is your sharding/replication strategy in Elastic?
Are you querying against the full data set or one index?
There are so many factors that we need to know If I’m querying a few TB of data for a complicated pattern with many ANDs and ORs, I’d be happy with 400-500ms
You may want to add a few data nodes to your Elastic cluster
I’ll have you know most of our queries complete in <200ms … super long time range ones still come in under 500ms so I’m with @macko003 there, 500ms isn’t bad
On 5 ES nodes, even searching across that entire index set should complete way faster, in a few dozen ms even. Looks like your ES nodes are either all on the same server, or hilariously underpowered. Got specs?
None of this will make any difference to be honest, you need to tune Elasticsearch, not Graylog - so bigger CPU on Elastic, bigger memory as well. Otherwise everything else isn’t worth it