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

Eviction algorithm for bad cached plans needs to be more aggressive

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Duplicate
    • Affects Version/s: 2.6.4
    • Fix Version/s: None
    • Component/s: Querying
    • Labels:
      None
    • Operating System:
      ALL
    • Sprint:
      Query 2.7.8

      Description

      When we cache a plan, if subsequent queries produce significantly worse performance result than expected, the cached plan should be evicted.

      It's currently evicted but the eviction strategy is too conservative so if we happen to cache a plan that works well only on a small minority of values we take too long to replace it.

        Attachments

          Issue Links

          duplicates

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-15225 CachedPlanStage should execute for trial period and re-plan if query performs poorly

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

          Bug - A problem which impairs or prevents the functions of the product. SERVER-15924 planCacheListPlans command can report incorrect averageScore and stdDevScore in "feedback" section

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed

            Activity

              People

              Assignee:
              david.storch David Storch
              Reporter:
              asya Asya Kamsky
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: