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

TTL deletes are much slower on descending indexes than ascending indexes

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • None
    • 4.4.0
    • None
    • None
    • Storage Engines
    • 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

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: