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

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

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • Query Execution

    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

        Activity

          People

            backlog-query-execution Backlog - Query Execution
            christopher.harris@mongodb.com Chris Harris
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: