[SERVER-79088] Improve SBE multi-planner performance for query which returns zero results Created: 18/Jul/23 Updated: 13/Nov/23 Resolved: 06/Oct/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.2.0-rc0, 7.0.3 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Zixuan Zhuang | Assignee: | Rui Liu |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | auto-reverted, query-director-triage | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||||||||||||||||||
| Issue Links: |
|
||||||||||||||||||||||||
| Assigned Teams: |
Query Execution
|
||||||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||||||
| Backport Requested: |
v7.0
|
||||||||||||||||||||||||
| Sprint: | QE 2023-09-18, QE 2023-10-02, QE 2023-10-16 | ||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||||||||||
| Linked BF Score: | 170 | ||||||||||||||||||||||||
| Description |
|
A $in query with multiple index choice and empty result is much slower after 6.3 upgrade, from the explain output we can tell that the problem is from SBE multi-planner. One of the predicate is an empty $in predicate descriptionRef:{ $in: []}{}, we should think about whether there's anything we can do to improve the performance of the multi-planner in this scenario. |
| Comments |
| Comment by Johnny Shields [ 20/Oct/23 ] |
|
Please mark this ticket as a "bug", it is not merely an "improvement". It brought down our production cluster when we upgraded. |
| Comment by Githook User [ 05/Oct/23 ] |
|
Author: {'name': 'Rui Liu', 'email': 'lriuui0x0@gmail.com', 'username': 'lriuui0x0'}Message: (cherry picked from commit b28e5ba7904666a2360efcf418467a111b64d82a) |
| Comment by Githook User [ 05/Oct/23 ] |
|
Author: {'name': 'Liubov Molchanova', 'email': 'liubov.molchanova@mongodb.com', 'username': 'liubov-molchanova'}Message: Revert " This reverts commit 7fa8693d23384315fd40f24e8fb1b2c2f35c0a7f. |
| Comment by Githook User [ 05/Oct/23 ] |
|
Author: {'name': 'Rui Liu', 'email': 'lriuui0x0@gmail.com', 'username': 'lriuui0x0'}Message: (cherry picked from commit b28e5ba7904666a2360efcf418467a111b64d82a) |
| Comment by Githook User [ 03/Oct/23 ] |
|
Author: {'name': 'Rui Liu', 'email': 'lriuui0x0@gmail.com', 'username': 'lriuui0x0'}Message: |
| Comment by xgen-buildbaron-user [ 02/Oct/23 ] |
|
Ticket re-opened due to revert. crypt_create_lib began a consistent failure of crypt_create_lib |
| Comment by Githook User [ 02/Oct/23 ] |
|
Author: {'name': 'auto-revert-processor', 'email': 'dev-prod-dag@mongodb.com', 'username': ''}Message: Revert " This reverts commit 3d7452026a6a49e0f4b2c4f8dd92fc7658e51a93. |
| Comment by Githook User [ 02/Oct/23 ] |
|
Author: {'name': 'lriuui0x0@gmail.com', 'email': 'lriuui0x0@gmail.com', 'username': 'lriuui0x0'}Message: |