[SERVER-63208] Make allowDiskUse opt-out rather than opt-in Created: 02/Feb/22  Updated: 29/Oct/23  Resolved: 12/Apr/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 6.0.0-rc0

Type: New Feature Priority: Blocker - P1
Reporter: Ian Boros Assignee: Romans Kasperovics
Resolution: Fixed Votes: 1
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Documented
is documented by DOCS-15236 [Server] Investigate changes in SERVE... Closed
Problem/Incident
causes SERVER-65888 Failing multiversion tests after the ... Closed
causes SERVER-66830 Allow views_aggregation.js to run in ... Closed
Related
related to SERVER-65467 Change lookup_pushdown.js to allow di... Closed
related to SERVER-77866 clean up sortb.js Closed
Backwards Compatibility: Minor Change
Sprint: QE 2022-04-04, QE 2022-04-18
Participants:
Linked BF Score: 146

 Description   

Currently, mongodb queries run with 'allowDiskUse' set to false by default. This causes queries to fail when a blocking operator exceeds a certain memory limit, rather than spilling to disk.

It would make more sense to have 'allowDiskUse' be opt-out (default=true) rather than opt-in. This would require a number of changes, not just in the server, but also in atlas (for example, on the free tier we'd probably want to continue to disable spilling altogether).

This ticket is meant to track the discussion around switching the default of allowDiskUse.



 Comments   
Comment by Githook User [ 12/Apr/22 ]

Author:

{'name': 'Romans Kasperovics', 'email': 'romans.kasperovics@mongodb.com', 'username': 'romanskas'}

Message: SERVER-63208 Make allowDiskUse opt-out rather than opt-in
Branch: master
https://github.com/mongodb/mongo/commit/f285f0af3d8d1448db1abafcaf4506a96af9e511

Comment by Githook User [ 07/Apr/22 ]

Author:

{'name': 'Mindaugas Malinauskas', 'email': 'mindaugas.malinauskas@mongodb.com'}

Message: SERVER-63208 Make allowDiskUse opt-out rather than opt-in

Co-authored-by: David Storch <dstorch@users.noreply.github.com>
Branch: master
https://github.com/10gen/mongo-enterprise-modules/commit/2a3f0fef833e6db6792e7b0cfadfdc0b3b64d2f4

Comment by David Storch [ 03/Feb/22 ]

The other related idea that came up while we were discussion this was to add the ability to set a cluster-wide default for allowDiskUse, which could then be overridden by specifying allowDiskUse on a per-query basis. This would allow users to get allowDiskUse=true by default without changing the behavior of pre-existing applications.

Generated at Thu Feb 08 05:57:10 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.