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

Docs for SERVER-23332: Expose query plan cache key in system.profile entry and query log lines

    XMLWordPrintable

    Details

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

      Description

      ----------------------------

      Original Description

      Description:

      The "queryHash" is now present in slow query log lines and in system.profile output. We may wish to document this in pages about these debug mechanisms. All queries with the same hash are considered the same "shape", and use the same plan cache entry. This may be useful for diagnosing issues around query performance. Please ask Storch for more details, and to review any proposed documentation changes.

      Note that https://jira.mongodb.org/browse/SERVER-35981 added this same 'queryHash' to the plan cache introspection commands output, and https://jira.mongodb.org/browse/SERVER-36527 added it to explain output.

      Engineering Ticket Description:

      It would be nice if we included a hash of all queries (without their binds) so we can get a sense for unique types of queries being run on a system and to be able to get a better performance profile for "bad" queries. If we could add that hash into the mongod.log we can easily "group" queries for prioritization when telling the customer what to "tweak".

      ----------------------------

      Description

      Scope of changes (files that need work and how much)

       

      • 4.2
      • tutorial/manage-the-database-profiler
      • /reference/database-profiler¬†
      • source/tutorial/evaluate-operation-performance.txt
      • administration/analyzing-mongodb-performance
      • source/includes/fact-log-slow-queries.rst
      • source/includes/options-mongod.yaml
      • source/reference/log-messages.txt

      Impact to other docs outside of this product

      MVP (work and date?)

      Resources (e.g. Scope Docs, Invision)

        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, 38 weeks, 1 day ago
                Date of 1st Reply: