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

Figuring out which shard to send a query to takes a long time when doing large $in queries on the shard key

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • 1.8.4, 2.0.2
    • 2.0.3, 2.1.1
    • Sharding
    • None
    • ALL

    Description

      The problem seems to be in ChunkManager::getShardsForQuery in chunk.cpp. Seems to do n^2 comparisons to figure out where to send the queries.

      Attachments

        Issue Links

          is depended on by

          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
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-4960 Optimize shard selection on $in queries

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

          Activity

            People

              spencer@mongodb.com Spencer Brody (Inactive)
              spencer@mongodb.com Spencer Brody (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: