[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. |