[SERVER-83492] Remove limit and skip values from SBE plan cache key if possible Created: 21/Nov/23 Updated: 12/Jan/24 Resolved: 18/Dec/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.2.1, 7.3.0-rc0, 7.0.6 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Ivan Fefer | Assignee: | Ivan Fefer |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||||||
| Backport Requested: |
v7.2, v7.0
|
||||||||||||||||||||||||
| Sprint: | QE 2023-11-27, QE 2023-12-11, QE 2023-12-25 | ||||||||||||||||||||||||
| Participants: | |||||||||||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||||||||||
| Linked BF Score: | 135 | ||||||||||||||||||||||||
| Description |
|
We encode exact limit and skip values as part of cache key in SBE: While encodeClassic doesn't do it. This may cause plan cache bloat and excessive multi planning in SBE. |
| Comments |
| Comment by Githook User [ 12/Jan/24 ] |
|
Author: {'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}Message: GitOrigin-RevId: 557c0af4c179164e4809b46ea68550596d14a3e0 |
| Comment by Githook User [ 03/Jan/24 ] |
|
Author: {'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}Message: |
| Comment by Githook User [ 14/Dec/23 ] |
|
Author: {'name': 'Ivan Fefer', 'email': 'ivan.fefer@mongodb.com', 'username': 'Fefer-Ivan'}Message: GitOrigin-RevId: f7c5485517b5a459fc91af7b92b789426c625f30 |
| Comment by Ivan Fefer [ 21/Nov/23 ] |
|
We can't just remove them, as limit and skip values are "hard coded" in SBE plan. |