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

          backported by

          Task - A task that needs to be done. DOCS-15047 [Server] [v5.0] Performance regression from dbstats due to occupied disk space calculation

          • Major - P3 - Major loss of function.
          • Closed
          depends on

          Bug - A problem which impairs or prevents the functions of the product. MONGOSH-1108 db.stats() returns MongoServerError: scale has to be a number

          • Minor - P4 - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          documents

          Bug - A problem which impairs or prevents the functions of the product. SERVER-62277 Performance regression from dbstats due to occupied disk space calculation

          • Critical - P2 - Crashes, loss of data, severe memory leak.
          • Closed
          is depended on by

          Task - A task that needs to be done. DOCS-15053 [Server] [Backport v5.2] Performance regression from dbstats due to occupied disk space calculation

          • Major - P3 - Major loss of function.
          • Closed

          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