TTL deletes are much slower on descending indexes than ascending indexes

XMLWordPrintableJSON

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

      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:
            [DO NOT USE] Backlog - Storage Engines Team
            Reporter:
            Louis Williams
            Votes:
            0 Vote for this issue
            Watchers:
            34 Start watching this issue

              Created:
              Updated:
              Resolved: