-
Type: Bug
-
Resolution: Gone away
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
(copied to CRM)
-
0
-
Storage - Ra 2021-11-15, Storage - Ra 2021-11-29, Storage - Ra 2022-01-24
In the last step of search near, wiredtiger walks the cursor back and forth to find a visible value. If there are a lot of invisible data to the reader, the search near performs poorly. As for each invisible key it inspects, it needs to do a history store search to check if there is a visible version in the history store or not. And most of the time, it will find nothing there.
Scope of the ticket:
Brainstorm optimisations to improve the search near performance in this case and create separate tickets.
- depends on
-
SERVER-61185 Use prefix_search for unique index lookup
- Closed
-
WT-8091 Create cpp test performing unique indexes insertions
- Closed
-
WT-8286 Create stress test for prefix search
- Closed