[DOCS-13096] Investigate changes in SERVER-43683: Make find command with allowDiskUse option work against a view Created: 11/Oct/19  Updated: 13/Nov/23  Due: 27/Mar/20  Resolved: 31/Mar/20

Status: Closed
Project: Documentation
Component/s: manual, Server
Affects Version/s: None
Fix Version/s: 4.3.1, Server_Docs_20231030, Server_Docs_20231106, Server_Docs_20231105, Server_Docs_20231113

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

Issue Links:
Documented
documents SERVER-43683 Make find command with allowDiskUse o... Closed
Participants:
Days since reply: 3 years, 45 weeks, 1 day ago
Epic Link: DOCS: 4.4 Server Release Work

 Description   

Description

Downstream Change Summary

Prior to this work, there was no way to specify 'allowDiskUse:true' when executing a find command against a view. This ticket (combined with work from SERVER-42077 and SERVER-7694) ensures that when a user adds the 'allowDiskUse:true' option to a find command executed against a view, any $sort or $group stages that would consume too much memory will spill to disk. Previously, users could only opt into this behavior by running an aggregate command against a view.

Description of Linked Ticket

Today, a find command can be executed against a view which contains blocking stages like $sort or $group that can consume a lot of memory. These stages will fail at runtime if the data size exceeds some memory threshold. If the user runs an aggregate command against the view, they can specify that disk use is allowed during execution of the query. The execution engine will relieve memory consumption by spilling to disk, allowing the query to succeed.

The same cannot currently be achieved with a find command. However, we recently added support for the allowDiskUse option in the find command: see related ticket SERVER-42077. This ticket tracks the work to make sure that the allowDiskUse option is respected when executing a find command against a view, and to add an integration test proving this works correctly.

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)



 Comments   
Comment by Githook User [ 31/Mar/20 ]

Author:

{'name': 'jeff-allen-mongo', 'email': 'jeffrey.allen@10gen.com', 'username': 'jeff-allen-mongo'}

Message: (DOCS-13096): allowDiskUse for find ops on views
Branch: master
https://github.com/mongodb/docs/commit/3e6bb3cbd192fa444ec7495c41c9f30edce2b747

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