Account Options

  1. Sign in
The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Google Groups Home
« Groups Home
How to improve query performance?
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  3 messages - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
jackiedong  
View profile  
 More options Jun 1 2012, 4:01 am
From: jackiedong <jackiedong...@gmail.com>
Date: Fri, 1 Jun 2012 01:01:33 -0700 (PDT)
Local: Fri, Jun 1 2012 4:01 am
Subject: How to improve query performance?

Hi,
   Currently, I use 2 servers(2 shards+1 replica) to query 0.46 billion
documents. The average query response time is 1.5s.
   I wish I can simply add a new server into the cluster to improve the
query performance. (still 2 shards + 1 replica)
   But after adding a new server into the cluster, I found the query
performance didn't improve much. The average query response time still is
1.5s.
   Did I miss anything??
   In addition, I'm wondering is there any difference of querying only one
server or query 3 servers roundly?

-Regards-
-Jackie-


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Ævar Arnfjörð Bjarmason  
View profile  
 More options Jun 1 2012, 6:55 am
From: Ævar Arnfjörð Bjarmason <ava...@gmail.com>
Date: Fri, 1 Jun 2012 12:55:32 +0200
Local: Fri, Jun 1 2012 6:55 am
Subject: Re: How to improve query performance?
This really doesn't tell us much of anything

* What's your HW setup like, is this data in RAM, on disk, what does
the CPU/disk use etc. look like when you do queries
* What does your data look like, do you have an example
* How does the mapping look like
* How do the queries that you've tried look like
* Have you tried increasing the number of shards, if you have 2 shards
in total with X number of replicas and 3 machines you'll only
distribute your queries to 2 shards, maybe that's your bottleneck, so
increasing replicas/boxes wouldn't help.


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
Otis Gospodnetic  
View profile  
 More options Jun 2 2012, 7:27 pm
From: Otis Gospodnetic <otis.gospodne...@gmail.com>
Date: Sat, 2 Jun 2012 16:27:17 -0700 (PDT)
Local: Sat, Jun 2 2012 7:27 pm
Subject: Re: How to improve query performance?

Jackie,

It doesn't help to add a new server if no shards/replicas are migrated to
it.  Check manually via the API or look at SPM.
Also, by adding more servers you are adding more CPUs, so resharding may
make sense.

Otis
--
Search Analytics - http://sematext.com/search-analytics/index.html
Scalable Performance Monitoring - http://sematext.com/spm/index.html


 
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »