Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-61185

Use prefix_search for unique index lookup

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • None
    • 5.3.0, 4.4.18, 5.0.14
    • None
    • None
    • Fully Compatible
    • v5.0, v4.4
    • Execution Team 2021-12-27, Execution Team 2022-01-10, Execution Team 2022-01-24
    • 15

    Description

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

      Attachments

        Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. WT-7912 Fix prefix search near optimisation to handle scenarios where the key range is split across pages.

          • Major - P3 - Major loss of function.
          • Closed
          is depended on by

          Bug - A problem which impairs or prevents the functions of the product. WT-8150 Poor search near performance if a lot of data are invisible

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. SERVER-50749 Re-loading is slow with py-tpcc

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-67350 stalling during concurrent insertMany operations when unique index exists

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-56509 Wrap unique index insertion _keyExists call in a WT cursor reconfigure.

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              louis.williams@mongodb.com Louis Williams
              louis.williams@mongodb.com Louis Williams
              Votes:
              0 Vote for this issue
              Watchers:
              16 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: