Loading...

XML

Word

Printable

JSON

Backwards Compatibility:
Fully Compatible
Backport Requested:

v5.0, v4.4
Sprint:
Execution Team 2021-12-27, Execution Team 2022-01-10, Execution Team 2022-01-24
Case:
Linked BF Score:
15
Confidence Status:
None
Work Order:
3

Re-implement ~~SERVER-56509~~. This improves the performance of inserts into uniques indexes.

depends on

WT-7912 Fix prefix search near optimisation to handle scenarios where the key range is split across pages.

is depended on by

WT-8150 Poor search near performance if a lot of data are invisible

is duplicated by

SERVER-50749 Re-loading is slow with py-tpcc

is related to

SERVER-67350 stalling during concurrent insertMany operations when unique index exists

SERVER-65527 Use range bounded cursors in place of prefix search_near on unique indexes

SERVER-85371 [4.4] Enable wiredTigerPrefixSearchForUniqueIndexes by default

related to

SERVER-56509 Wrap unique index insertion _keyExists call in a WT cursor reconfigure.

SERVER-65054 Avoid slow insert batches blocking replication

(1 is related to, 2 related to)

Participants:: Alex Podelko, Chenhao Qu, Etienne Petrel, Githook User, Louis Williams, Monica Ng