[SERVER-10149] Add new mongos "--broadcastWarn" option to warn on scatter/gather queries Created: 09/Jul/13  Updated: 10/Dec/14  Resolved: 10/Jul/13

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

Type: New Feature Priority: Minor - P4
Reporter: Jason Zucchetto Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

Non-targeted (or scatter/gather) queries can severely hurt the performance of a sharded cluster. Furthermore, scatter/gather queries can be hard to find and debug: enable profiling on a shard's primary (and potentially secondaries), profile every query, runs queries against the system.profile collection to find queries without the shard key.

This becomes more complex when there are tens of sharded collections across multiple databases.

A simple warning message in the mongos logs would help incredibly:

"warning: broadcast query

{...}

"



 Comments   
Comment by Eliot Horowitz (Inactive) [ 10/Jul/13 ]

Don't think is any different than any other cause of a slow query.
So I think SERVER-2926 is the thing we'll do, and then maybe we'll see.

Generated at Thu Feb 08 03:22:24 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.