[SERVER-71666] Reduce number of scanned index entries on chunk migration commit Created: 29/Nov/22 Updated: 29/Oct/23 Resolved: 30/Nov/22 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | 6.0.0, 6.1.0, 6.0.2, 6.0.3, 6.2.0-rc1 |
| Fix Version/s: | 6.0.4, 6.2.0-rc2, 6.3.0-rc0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Tommaso Tocci | Assignee: | Pierlauro Sciarelli |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||
| Operating System: | ALL | ||||||||||||||||
| Backport Requested: |
v6.2
|
||||||||||||||||
| Sprint: | Sharding EMEA 2022-12-12 | ||||||||||||||||
| Participants: | |||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||
| Description |
|
In In particular we changed the query to find the chunk being moved. Since the new query is not sorted and use a limit of 2 it will need to scan all the index entries with min value less than the minimum shard key of the range to migrate. |
| Comments |
| Comment by Githook User [ 30/Nov/22 ] |
|
Author: {'name': 'Pierlauro Sciarelli', 'email': 'pierlauro.sciarelli@mongodb.com', 'username': 'pierlauro'}Message: (cherry picked from commit 591bce59840c8f6e1926b2d5a324eeefbf750336) |
| Comment by Githook User [ 30/Nov/22 ] |
|
Author: {'name': 'Pierlauro Sciarelli', 'email': 'pierlauro.sciarelli@mongodb.com', 'username': 'pierlauro'}Message: (cherry picked from commit 591bce59840c8f6e1926b2d5a324eeefbf750336) |
| Comment by Githook User [ 30/Nov/22 ] |
|
Author: {'name': 'Pierlauro Sciarelli', 'email': 'pierlauro.sciarelli@mongodb.com', 'username': 'pierlauro'}Message: |