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

Hiding an index should only evict plan cache entries which use that index

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Optimization
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      Currently, the query system will clear the entire collection plan cache when any given index is hidden. This causes every subsequent query to go through planning which can be expensive and, depending on the workload, create a "multiplan storm" situation. This ticket proposes an approach that looks at the indexes used for each cached plan and only clears the entries which use the hidden index.

      Note that this is particularly impactful for performance advisor, since users are first advised to hide an index before dropping altogether if it's no longer useful.

            Assignee:
            Unassigned Unassigned
            Reporter:
            nicholas.zolnierz@mongodb.com Nicholas Zolnierz
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              None
              None
              None
              None