On Mon, 2015-11-02 at 12:00 +0530, Modassar Ather wrote: > I have a setup of 12 shard cluster started with 28gb memory each on a > single server. There are no replica. The size of index is around 90gb on > each shard. The Solr version is 5.2.1.
That is 12 machines, running a shard each? What is the total amount of physical memory on each machine? > When I query "network se*", the memory utilization goes upto 24-26 gb and > the query takes around 3+ minutes to execute. Also the CPU utilization goes > upto 400% in few of the nodes. Well, se* probably expands to a great deal of documents, but a huge bump in memory utilization and 3 minutes+ sounds strange. - What are your normal query times? - How many hits do you get from 'network se*'? - How many results do you return (the rows-parameter)? - If you issue a query without wildcards, but with approximately the same amount of hits as 'network se*', how long does it take? > Why the CPU utilization is so high and more than one core is used. > As far as I understand querying is single threaded. That is strange, yes. Have you checked the logs to see if something unexpected is going on while you test? > How can I disable replication(as it is implicitly enabled) permanently as > in our case we are not using it but can see warnings related to leader > election? If you are using spinning drives and only have 32GB of RAM in total in each machine, you are probably struggling just to keep things running. - Toke Eskildsen, State and University Library, Denmark