[SERVER-72518] Make 5% random-cursor $sample cutoff configurable Created: 04/Jan/23 Updated: 29/Oct/23 Resolved: 06/Feb/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 6.3.0-rc0 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Charlie Swanson | Assignee: | Naama Bareket |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | neweng | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Assigned Teams: |
Query Execution
|
||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||
| Sprint: | QE 2023-02-20 | ||||||||||||
| Participants: | |||||||||||||
| Description |
|
This is currently hard-coded, but could easily be exposed as a setParameter. Even better perhaps: as some sort of hint? |
| Comments |
| Comment by Githook User [ 06/Feb/23 ] |
|
Author: {'name': 'Naama Bareket', 'email': 'naama.bareket@mongodb.com', 'username': 'naama-bareket'}Message: |
| Comment by Eric Milkie [ 10/Jan/23 ] |
|
It is low priority for Serverless. |
| Comment by Steve Tarzia [ 10/Jan/23 ] |
|
milkie@mongodb.com how urgent is this functionality for serverless? |
| Comment by Eric Milkie [ 04/Jan/23 ] |
|
Yes, the setClusterParameter command is tenant-aware! And I think it does make sense to have the sample cutoff value be the same across all nodes, so a cluster param makes sense here. |
| Comment by Arun Banala [ 04/Jan/23 ] |
|
Should we consider using setClusterParameter operation instead, since it provides a durable option which also gets replicates to secondaries? milkie@mongodb.com Does setClusterParameter work on Serverless? |
| Comment by Eric Milkie [ 04/Jan/23 ] |
|
Note that a setParameter will only be useful to non-shared-tier customers (on-prem and Atlas Dedicated). I'd expect Serverless customers to possibly want to customize this in order to optimize their bills. |