Re: Some nodes show high query latency

2023-10-03 Thread rajani m
Thank you all for the great pointers. It was monitoring dashboard graph that mislead to thinking that nodes were problematic. It is not nodes but high frequency terms queries. Queries that match 50% docs in the index have high latency of 1-2 seconds. On Sat, Sep 30, 2023 at 7:13 AM Deepak Goel

Re: Some nodes show high query latency

2023-09-30 Thread Deepak Goel
What are the kind of queries you have? Are they the same 80% of the time? If yes, they will hit a few nodes all the time. On Sat, 30 Sept 2023, 15:07 Vincenzo D'Amore, wrote: > Hi Rajani, > > how many documents do you have in your collection? > The nodes that consistently display high latency, d

Re: Some nodes show high query latency

2023-09-30 Thread Vincenzo D'Amore
Hi Rajani, how many documents do you have in your collection? The nodes that consistently display high latency, do they have the same replicas? I mean, are they the only nodes where such high latency queries can be executed? On Fri, Sep 29, 2023 at 9:29 PM rajani m wrote: > Hi Solr Users, > >

Re: Some nodes show high query latency

2023-09-29 Thread Walter Underwood
Turn on some system monitoring. For that large a difference, look at IO waits or IO reads from disk, whatever your monitoring system provides. Also look at CPU, the CPU utilization should be the same on all the nodes. If some nodes are lower in CPU, then they are blocked by something else. Mak

Re: Some nodes show high query latency

2023-09-29 Thread Shawn Heisey
On 9/29/23 13:28, rajani m wrote: What could cause some nodes in a cluster to have high query latency when compared to the rest? It is possible that some of the nodes have either handled zero queries since the last reboot, or that they have handled fewer queries than the others, and as