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

Re-enable caching of single solution plans

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 6.0.0-rc5, 6.1.0-rc0
    • None
    • None
    • Fully Compatible
    • v6.0
    • QE 2022-04-04, QE 2022-03-21, QE 2022-04-18, QE 2022-05-02, QE 2022-05-16
    • 148

    Description

      The classic plan cache did not create a cache entry for queries that only have a single solution. (Improving this is tracked by SERVER-13341.) The SBE plan cache, on the other hand, will cache single solution plans. This allows us to skip the cost of recompiling the SBE plan, even if there is no need to skip multi-planning.

      The work for this improvement was originally implemented under SERVER-61083 but then subsequently disabled by SERVER-64314 since we observed some subtle correctness issues that were tricky to diagnose. The work for this ticket is to re-enable caching of single solution plans in the SBE plan cache. This will involve investigating and fixing the relevant build failures in addition to reverting the patch from SERVER-64314 that temporarily disabled single-solution SBE plan caching.

      Attachments

        Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. SERVER-66015 Auto-parameterization works incorrectly for indexed regular expression predicates

          • Critical - P2 - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. SERVER-65083 Thread seeing different set of indices can incorrectly re-use an SBE plan cache entry

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-65085 SBE plan cache entries can be incorrectly reused after a refineCollectionShardKey operation

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

          Task - A task that needs to be done. SERVER-13341 Cache single solution query plans

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

          Task - A task that needs to be done. SERVER-61083 Start caching plans that only have a single QuerySolution

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

          Task - A task that needs to be done. SERVER-64314 Temporary disable caching of single solution plans

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

          Activity

            People

              david.storch@mongodb.com David Storch
              anton.korshunov@mongodb.com Anton Korshunov
              Votes:
              0 Vote for this issue
              Watchers:
              17 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: