Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-8150

Poor search near performance if a lot of data are invisible

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Gone away
    • None
    • None
    • None
    • None
    • 0
    • Storage - Ra 2021-11-15, Storage - Ra 2021-11-29, Storage - Ra 2022-01-24

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              backlog-server-storage-engines Backlog - Storage Engines Team
              chenhao.qu@mongodb.com Chenhao Qu
              Votes:
              0 Vote for this issue
              Watchers:
              20 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: