Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-12387

Docs for SERVER-33303: Modifying indexes impacts application of index filters

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.1.5
    • Component/s: manual, Server
    • Labels:

      Description

      Description

       

      Description:

      This introduces the "planCacheKey" field to explain/logger/debug output.

      To summarize the difference between planCacheKey and queryHash:

      queryHash is "stable" across catalog changes. That is, the "query shape" (and thus, the hash of theh query shape) is derived from the query the user wrote down, and does not depend on any state inside the server. It will not change if you add/drop/change indexes.

      planCacheKey is "unstable" across catalog changes. It depends both on the query shape and which indexes are available.

      This is slightly confusing even for us so if you have questions definitely slack/email me!(ian.boros/ianb)

      Engineering Ticket Description:

      According to the documentation:

      Index filters exist for the duration of the server process and do not persist after shutdown. MongoDB also provides a command to manually remove filters.

       

      While a given index filter does persist across index creation and drops, its application towards queries does seem to be influenced by such actions.

      Scope of changes

      • source/reference/explain-results
      • profiler
      • log messages
      • 4.2
      • possibly regarding:
        • plan cache filter
        • analyzing mongodb perf
        • core/query-plans
        • core/query-optimization
        • tutorial/evaluate-operation-performance
        • tutorial/manage-indexes

      Impact to Other Docs

      MVP (Work and Date)

      Resources (Scope or Design Docs, Invision, etc.)

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              kay.kim Kay Kim (Inactive)
              Reporter:
              kay.kim Kay Kim (Inactive)
              Participants:
              Last commenter:
              Kay Kim Kay Kim (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since reply:
                2 years, 34 weeks, 3 days ago
                Date of 1st Reply: