[DOCS-15046] [SERVER] Investigate changes in SERVER-62277: Performance regression from dbstats due to occupied disk space calculation Created: 19/Jan/22  Updated: 20/Nov/23  Resolved: 08/Mar/22

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 5.0.6, 5.3.0, 5.2.1, Server_Docs_20231120

Type: Task Priority: Major - P3
Reporter: Backlog - Core Eng Program Management Team Assignee: Dave Cuthbert (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
backported by DOCS-15047 [Server] [v5.0] Performance regressio... Closed
Depends
depends on MONGOSH-1108 db.stats() returns MongoServerError: ... Closed
is depended on by DOCS-15053 [Server] [Backport v5.2] Performance ... Closed
Documented
documents SERVER-62277 Performance regression from dbstats d... Closed
Participants:
Days since reply: 1 year, 48 weeks, 2 days ago
Epic Link: DOCSP-19447

 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.



 Comments   
Comment by Githook User [ 07/Mar/22 ]

Author:

{'name': 'Dave', 'email': '69165704+davemungo@users.noreply.github.com', 'username': 'davemungo'}

Message: DOCS-15046 BACKPORT (#750)

  • Server versions
Comment by Githook User [ 07/Mar/22 ]

Author:

{'name': 'Dave', 'email': '69165704+davemungo@users.noreply.github.com', 'username': 'davemungo'}

Message: DOCS-15046 BACKPORT (#751)

  • Server versions
Comment by Githook User [ 07/Mar/22 ]

Author:

{'name': 'Dave', 'email': '69165704+davemungo@users.noreply.github.com', 'username': 'davemungo'}

Message: DOCS-15046 perf regression from dbstats v5.3 (#741)

  • Review updates
  • Review updates
  • Review updates
  • Review feedback
  • Review feedback
  • Review feedback
Comment by PM Bot [ 19/Jan/22 ]

Downstream changes updated for upstream SERVER-62277:
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.

Comment by PM Bot [ 19/Jan/22 ]

Downstream changes updated for upstream SERVER-62277:
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.

Generated at Thu Feb 08 08:11:51 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.