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

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

    • Type: Icon: New Feature New Feature
    • Resolution: Won't Fix
    • Priority: Icon: Minor - P4 Minor - P4
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      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 Unassigned
            Reporter:
            jason.zucchetto Jason Zucchetto
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: