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

Add hostname to $collStats output, and include shard name when run on a cluster

    XMLWordPrintableJSON

Details

    • Fully Compatible
    • Query 2017-07-10
    • 0

    Description

      $collStats has useful information when run on a mongod, but it's less useful when run on a mongos:

       shards:
              {  "_id" : "shard0000",  "host" : "celadon:20000",  "state" : 1 }
              {  "_id" : "shard0001",  "host" : "celadon:20001",  "state" : 1 }
        databases:
              {  "_id" : "test",  "primary" : "shard0000",  "partitioned" : true }
                      test.coll
                              shard key: { "_id" : "hashed" }
                              unique: false
                              balancing: true
                              chunks:
                                      shard0000       2
                                      shard0001       3
      

      mongos> db.coll.aggregate([{$collStats: {}}])
      { "ns" : "test.coll", "localTime" : ISODate("2017-04-26T14:18:29.066Z") }
      { "ns" : "test.coll", "localTime" : ISODate("2017-04-26T14:18:29.074Z") }
      

      It would be useful if the result could also include information that identifies which mongod or which shard is associated with each result (for example, hostname and port).

      Attachments

        Activity

          People

            bernard.gorman@mongodb.com Bernard Gorman
            kyle.suarez@mongodb.com Kyle Suarez
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: