Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-15046

[SERVER] Investigate changes in SERVER-62277: Performance regression from dbstats due to occupied disk space calculation

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 5.0.6, 5.3.0, 5.2.1
    • manual, Server
    • None

    Description

      Downstream Change Summary

      These fields are not being returned by default anymore by the dbStats command:

      • freeStorageSize
      • indexFreeStorageSize
      • totalFreeStorageSize

      In order to show them, the user needs to explicitly request them with the freeStorage option in the command or the mongo shell wrapper:

      db.runCommand({dbStats: 1, freeStorage: 1});
      db.stats({freeStorage: 1});
      

      The mongo shell wrapper now accepts either a number (the scale, as it used to) or a document with options:

      • scale: number, optional
      • freeStorage: 0 or 1, optional

      This ticket addresses a performance regression caused by accessing the information needed to populate those fields.

      Description of Linked Ticket

      After SERVER-50756, by default, the dbStats command now returns how much unoccupied storage space is being used for collections,
      indexes, and in total: freeStorageSize, indexFreeStorageSize, and totalFreeStorageSize.

      For customers with many tables, this feature adds a performance regression.

      Attachments

        Issue Links

          Activity

            People

              dave.cuthbert@mongodb.com Dave Cuthbert (Inactive)
              backlog-server-pm Backlog - Core Eng Program Management Team
              Jess Mokrzecki Jess Mokrzecki
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                1 year, 30 weeks, 2 days ago