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

TTL deletes are much slower on descending indexes than ascending indexes

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 4.4.0
    • Component/s: None
    • Labels:
      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

      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.

        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

            Assignee:
            backlog-server-storage-engines [DO NOT USE] Backlog - Storage Engines Team
            Reporter:
            louis.williams@mongodb.com Louis Williams
            Votes:
            0 Vote for this issue
            Watchers:
            33 Start watching this issue

              Created:
              Updated:
              Resolved: