-
Type: Improvement
-
Resolution: Done
-
Priority: 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