[SERVER-45658] Allow $planCacheStats to target a specific node in a sharded cluster Created: 21/Jan/20  Updated: 06/Dec/22

Status: Backlog
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Improvement Priority: Major - P3
Reporter: Chris Harris Assignee: Backlog - Query Execution
Resolution: Unresolved Votes: 0
Labels: qexec-team
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-45032 Allow $planCacheStats to target every... Closed
Assigned Teams:
Query Execution
Participants:

 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.


Generated at Thu Feb 08 05:09:23 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.