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

Can't use system.profile on a sharded cluster

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Sharding
    • Labels:
      None
    • Operating System:
      ALL

      Description

      It is unclear from the documentation how to use the query profiler in a sharded cluster, and the results are confusing.

      I can't use setProfilingLevel on a mongos server, so I have to set it individually on each shard. This leads to a 'system.profile' collection appearing when connecting to the mongos, but it claims to contain only 92 documents whereas each shard contains much more than that.

      I expected the system.profile collection on the mongos to act like any other sharded collection, and represent the combined contents of the system.profile collection on each shard. This is not happening, so either it's a bug, or the usage/docs are misleading.

      In short, I'm missing a reliable and clearly-documented way to get system.profile data from the entire cluster.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              avish Avishay Lavie
              Participants:
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: