-
Type: Task
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: Sharding
-
Fully Compatible
-
v5.0
-
Sharding EMEA 2021-05-31
-
0
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-57311is addressing the problem for DDL coordinators).
- is related to
-
SERVER-57308 Further investigate slow deletion of chunks
- Closed
- related to
-
SERVER-57221 Inconsistent delete performance on collections with multiple secondary indexes on same key
- Closed