[SERVER-57307] Improve deletion of config.chunks entries with hint and retries Created: 31/May/21  Updated: 29/Oct/23  Resolved: 31/May/21

Status: Closed
Project: Core Server
Component/s: Sharding
Affects Version/s: None
Fix Version/s: 5.0.0-rc1, 5.1.0-rc0

Type: Task Priority: Major - P3
Reporter: Pierlauro Sciarelli Assignee: Pierlauro Sciarelli
Resolution: Fixed Votes: 0
Labels: PM-1965-Cleanup
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Related
related to SERVER-57221 Inconsistent delete performance on co... Closed
is related to SERVER-57308 Further investigate slow deletion of ... Closed
Backwards Compatibility: Fully Compatible
Backport Requested:
v5.0
Sprint: Sharding EMEA 2021-05-31
Participants:
Linked BF Score: 0

 Description   

SERVER-57221 highlighted performance problems on deletes for collections with more than one secondary index, showing that using an index hint can lead to better performance.

As collections may have a lot of chunks:

  • Extend the catalog client in order to optionally accept an optional hint as argument for removing config documents.
  • Update the delete chunks call to pass a proper hint.
  • As NetworkInterfaceExceededTimeLimit can be hit in case of slow deletes, implement a retry logic for this specific case (just needed for legacy path, since SERVER-57311 is addressing the problem for DDL coordinators).


 Comments   
Comment by Vivian Ge (Inactive) [ 06/Oct/21 ]

Updating the fixversion since branching activities occurred yesterday. This ticket will be in rc0 when it’s been triggered. For more active release information, please keep an eye on #server-release. Thank you!

Comment by Githook User [ 03/Jun/21 ]

Author:

{'name': 'Pierlauro Sciarelli', 'email': 'pierlauro.sciarelli@mongodb.com', 'username': 'pierlauro'}

Message: SERVER-57307 Improve deletion of config.chunks entries with hint and retries (BACKPORT-9448)
Branch: v5.0
https://github.com/mongodb/mongo/commit/944e6e91b0be44bfe5d39e4a39ab81661003d2e1

Comment by Githook User [ 31/May/21 ]

Author:

{'name': 'Pierlauro Sciarelli', 'email': 'pierlauro.sciarelli@mongodb.com', 'username': 'pierlauro'}

Message: SERVER-57307 Improve deletion of config.chunks entries with hint and retries
Branch: master
https://github.com/mongodb/mongo/commit/fcc590c63c9c08fa0a895765071c5462b19f3160

Generated at Thu Feb 08 05:41:30 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.