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

Add additional fields to output of dbStats command and collStats command

    • Type: Icon: Improvement Improvement
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Storage
    • None
    • Storage Execution

      The dbStats command only outputs a subset of the data that would be of interest to a DBA when diagnosing storage issues. The current fields output are:

      • fileSize: amount of disk space used
      • dataSize: amount of space used by data (Sum of datasize for all collections)
      • storageSize: sum of extents allocated for data for all collections
      • indexSize: amount of space used by indexes

      Additional fields of interest would be:

      • indexStorageSize: sum of extents allocated for indexes for all collections
      • freeExtentSize: sum of extents on the free list
      • freeRecordSize: sum of records on the record free list

      Both 'indexStorageSize' and 'freeRecordSize' could also be added to the output of collStats

      The net effect would be to much better determine the need to compact or repair a database or collection. It would also make the results of compact visible to users

            Assignee:
            backlog-server-execution [DO NOT USE] Backlog - Storage Execution Team
            Reporter:
            william.zola@10gen.com William Zola
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: