[SERVER-72440] Deprioritize collection scans under load Created: 29/Dec/22  Updated: 29/Oct/23  Resolved: 28/Mar/23

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

Type: Improvement Priority: Major - P3
Reporter: Louis Williams Assignee: Gregory Noma
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
depends on SERVER-74544 Move SetAdmissionPriorityForLock from... Closed
Problem/Incident
Related
is related to SERVER-74594 Deprioritize unbounded user index sca... Closed
is related to SERVER-77792 [CQF] Mark full collscans as low prio... Closed
is related to SERVER-77931 Server parameter to disable depriorit... Closed
is related to SERVER-75378 Test that deprioritized collection sc... Open
is related to SERVER-75376 Handle edge cases for deprioritizing ... Backlog
is related to SERVER-75377 Deprioritize unbounded user collectio... Closed
Assigned Teams:
Storage Execution
Backwards Compatibility: Fully Compatible
Backport Requested:
v7.0
Sprint: Execution Team 2023-03-06, Execution Team 2023-03-20, Execution Team 2023-04-03
Participants:
Linked BF Score: 131

 Description   

Under load, user collection scans should be given the lowest scheduling priority over all queries



 Comments   
Comment by Githook User [ 28/Mar/23 ]

Author:

{'name': 'Gregory Noma', 'email': 'gregory.noma@gmail.com', 'username': 'gregorynoma'}

Message: SERVER-72440 Deprioritize unbounded user collection scans
Branch: master
https://github.com/mongodb/mongo/commit/b609fe88cabcbd8e83142707d5f5697904b8beaf

Comment by Gregory Noma [ 03/Mar/23 ]

I split out index scans to SERVER-74594

Comment by Haley Connelly [ 01/Mar/23 ]

Agreed. I think unbounded here is key.

Comment by Daniel Gomez Ferro [ 06/Feb/23 ]

I think this should deprioritize all unbounded scans on collections (both clustered and non-clustered) and indexes.

Comment by Haley Connelly [ 06/Feb/23 ]

This ticket should make sure that collection scans on clustered indexes are not penalised the same as non-clustered collection scans. 

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