Add new mongos "--broadcastWarn" option to warn on scatter/gather queries

XMLWordPrintableJSON

    • Type: New Feature
    • Resolution: Won't Fix
    • Priority: Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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

      {...}

      "

              Assignee:
              Unassigned
              Reporter:
              Jason Zucchetto (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: