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

Allow $planCacheStats to target a specific node in a sharded cluster

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major - P3
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Backlog
    • Component/s: None
    • Labels:

      Description

      When investigating plan execution behavior, we sometimes need to review the information in the plan cache for a specific host regardless of topology.  To gather this information in a sharded cluster presently requires the user to connect directly to the member of interest to execute the relevant commands, which goes against much of our guidance to always connect to and query a sharded cluster via mongos.

      Perhaps along with allowing $planCacheStats to target every shardsvr node (SERVER-45032), we could also allow the command to accept a hostname parameter when submitted via mongos.  This would allow us to collect the diagnostic information that we need without needing the users to connect to the shardsvr directly.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              backlog-query-execution Backlog - Query Execution
              Reporter:
              christopher.harris Christopher Harris
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: