[SERVER-78199] btree index check, avoid create duplicate btree indexes, Avoid affecting performance and increases storage consts. Created: 18/Jun/23 Updated: 09/Jan/24 Resolved: 09/Jan/24 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | y yz | Assignee: | Daotang Yang |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | former-storex-namer | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Attachments: |
|
||||||||||||||||
| Issue Links: |
|
||||||||||||||||
| Assigned Teams: |
Storage Execution
|
||||||||||||||||
| Operating System: | ALL | ||||||||||||||||
| Sprint: | Execution Team 2023-12-11, Execution Team 2024-01-08, Execution Team 2024-01-22 | ||||||||||||||||
| Participants: | |||||||||||||||||
| Description |
|
btree index check, avoid create duplicate btree indexes, Avoid affecting performance btree index check, avoid create duplicate btree indexes, Avoid affecting performance by the deplicate index. In addition, They also affecting query performance because both are candidate indexes. This increases storage consts. |
| Comments |
| Comment by y yz [ 09/Jan/24 ] |
|
master branch PR: |
| Comment by Daotang Yang [ 08/Jan/24 ] |
|
1147952115@qq.com Please change the pull request against master instead of 5.0 |
| Comment by Louis Williams [ 13/Oct/23 ] |
|
Hi 1147952115@qq.com, thanks for the PR. We are looking for someone to evaluate your PR. |
| Comment by y yz [ 13/Oct/23 ] |
|
hi, Chris Kelly Do we have the conclusion of this PR? thanks. |
| Comment by Chris Kelly [ 20/Jun/23 ] |
|
Thanks for the pull request 1147952115@qq.com - I'll pass this to the relevant team to take a look. Your continued efforts here are appreciated! Christopher |
| Comment by y yz [ 18/Jun/23 ] |
|
the code address: https://github.com/mongodb/mongo/pull/1557 |
| Comment by y yz [ 18/Jun/23 ] |
|
befor:
after the PR push:
|
| Comment by y yz [ 18/Jun/23 ] |
|
switched to db test mongodb_5.0_shard2:PRIMARY> mongodb_5.0_shard2:PRIMARY> , , , |