[SERVER-75754] Consider moving query.planCacheTotalSizeEstimateBytes and query.planCacheTotalQueryShapes into query.planCache sub-document. Created: 06/Apr/23 Updated: 29/Oct/23 Resolved: 19/Sep/23 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 7.2.0-rc0 |
| Type: | Improvement | Priority: | Minor - P4 |
| Reporter: | Anton Korshunov | Assignee: | James Harrison |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | query-product-scope-1, query-product-urgency-3, query-product-value-3 | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||
| Assigned Teams: |
Query Optimization
|
||||||||||||||||
| Backwards Compatibility: | Minor Change | ||||||||||||||||
| Participants: | |||||||||||||||||
| Description |
|
In We should consider moving all plan cache related counters into the query.planCache sub-document to group them logically together. The two which are currently housed in the query document are:
|
| Comments |
| Comment by Githook User [ 18/Sep/23 ] |
|
Author: {'name': 'James Harrison', 'email': '00jamesh@gmail.com', 'username': 'jameseh96'}Message: |
| Comment by Githook User [ 14/Sep/23 ] |
|
Author: {'name': 'James Harrison', 'email': '00jamesh@gmail.com', 'username': 'jameseh96'}Message: The counters: are both planCache specific; for consistency with other planCache query.planCache.totalSizeEstimateBytes This leaves the planCache subdocument appearing as follows: "planCache" : { , }, These counters are not specific to classic/sbe. |
| Comment by Ana Meza [ 18/Apr/23 ] |
|
Passing to Product-Triage, we are looking for a second opinion about doing this work or not? |