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

TTL deletes are much slower on descending indexes than ascending indexes

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Fixed
    • 4.4.0
    • 6.2.0-rc0
    • None
    • None
    • Fully Compatible
    • ALL
    • Execution Team 2021-06-28, Execution Team 2021-07-12, Execution Team 2021-08-23, Execution Team 2021-09-06

    Description

      For unknown reasons, TTL deletes that use a descending index (e.g. {lastUse: -1}) take at least an order of magnitude more time than deletes on an equivalent, ascending index (e.g.{lastUse: 1}).

      Investigate and attempt to fix this problem.

      Attachments

        1. Screen Shot 2021-06-01 at 1.56.28 PM.png
          Screen Shot 2021-06-01 at 1.56.28 PM.png
          125 kB
        2. Screen Shot 2021-06-01 at 1.56.35 PM.png
          Screen Shot 2021-06-01 at 1.56.35 PM.png
          138 kB
        3. ttl_delete_repro.js
          2 kB

        Issue Links

          Activity

            People

              backlog-server-storage-engines Backlog - Storage Engines Team
              louis.williams@mongodb.com Louis Williams
              Votes:
              0 Vote for this issue
              Watchers:
              27 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: