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

Mongo Query Taking Lot of Time Selecting Index

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Works as Designed
    • 3.0.4
    • None
    • Querying
    • None
    • ALL

    Description

      There are two issues happening :
      First Issue : Query taking lot of time in deciding which index to use.
      Eg: If we run an query X , then it takes a lot of time (more than 5 minutes) )and on checking the log it was using a index Y.
      Now if I run the query X with index hint Y, it runs in couple of seconds.
      That means the time it was taking is not in query execution but before that. Very strange

      Second Issue : In some cases it is not selecting the right index also. If my query is on fields A,B,C and I have indexes A and A_B_C created, then it is choosing the index A instead if A_B_C

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. DRIVERS-303 Mongo Query Taking Lot of Time Selecting Index

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-13211 Optimal index not chosen for query plan when many indexes match same prefix

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-24396 Progressive elimination of candidate plans during plan ranking trial period

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

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-31078 Query planning is very slow during multiplanning when result set is empty

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

          Activity

            People

              david.storch@mongodb.com David Storch
              arpit@limeroad.com arpit wanchoo
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: