Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-4960

Optimize shard selection on $in queries

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: Querying, Sharding
    • Labels:
    • Case:

      Description

      Selecting the appropriate shard to send a query to takes a long time on $in queries. SERVER-4745 mitigates the affect of this, but this code could use rewriting and further optimization.

        Attachments

          Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-9205 MongoS does not re-write $in queries which results in all terms in $in array being sent to all shards

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-50299 Shard Targeting for $in statements

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-4745 Figuring out which shard to send a query to takes a long time when doing large $in queries on the shard key

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-4555 check and clean sharding utilization of queryutil code

          • Major - P3 - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-9332 Mongos should re-write $in queries on the shard key before sending them to the shards so that the shards only receive the relevant portion of the $in

          • Major - P3 - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              backlog-server-sharding Backlog - Sharding Team
              Reporter:
              spencer Spencer Brody (Inactive)
              Participants:
              Votes:
              5 Vote for this issue
              Watchers:
              25 Start watching this issue

                Dates

                Created:
                Updated: