Hello, The queries that we run seem to be very CPU Intensive and cause the Servers to max out within a short amount of time. On debugging, it looks like standard queries take too long to respond too.
We are currently running version 1.0.2 of Elasticsearch and have about 67.3G of data on Production. There are currently 5 Shards running on 2 Nodes (1 Replica). There is a total of 252gb RAM with Heap Size set to 109.9gb. <https://lh5.googleusercontent.com/-4bLBVeQuIHY/U4YnR7KX__I/AAAAAAAAAAM/XA8B0kff_u8/s1600/Elasticsearch+Setup.png> The Indexing rate is high since we are migrating data: >From Bigdesk: <https://lh4.googleusercontent.com/-gwJ_8GUT5nc/U4ZplswvYYI/AAAAAAAAAA0/6UhKvCpCF6c/s1600/Indexing+Rate.png> The Refresh Activity report from ElasticHQ: <https://lh6.googleusercontent.com/-DHO2pXXflME/U4ZqLxawJKI/AAAAAAAAABA/7pqxXnKbLn0/s1600/ElasticHQ+-+Index+Activity.png> The Match All Query takes a whopping 520 - 680ms to run. { "query": { "match_all": {} } } However, on a similar Test Environment Setup (with 8G of data), the same query takes about 80-120ms to execute. Which feels more like the average. <https://lh5.googleusercontent.com/-LTtjBlbcHR0/U4YqUTlNt_I/AAAAAAAAAAc/P1h6okpdm4w/s1600/Elasticsearch+Test+Setup.png> What are some of the recommendations that can improve this bottleneck? Will adding more Nodes help alleviate this issue or will it worsen it. Thanks, Sairam -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/66c26a89-b3f8-4a8c-96dc-45babc1e012d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
