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

Allow TTLMonitor to use existing indexes starting with Date field

    XMLWordPrintableJSON

Details

    • Minor Change
    • v5.0
    • Execution Team 2021-03-08, Execution Team 2021-06-14, Execution Team 2021-06-28

    Description

      If the composite index starts with the Date field, the TTLMonitor's queries would be as fast and will not require an extra index.

      We have lots of time-series data with composite indexes starting with Date, we're forced to create the TTL index although it's used solely by the TTLMonitor.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. SERVER-60956 collMod command allows converting index on capped collection to TTL, leading to invariant failure

          • Major - P3 - Major loss of function.
          • Closed
          is documented by

          Task - A task that needs to be done. DOCS-14569 Investigate changes in SERVER-13938: Allow TTLMonitor to use existing indexes starting with Date field

          • Major - P3 - Major loss of function.
          • Closed
          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-9305 Enabling adding expireAfterSeconds to convert to a TTL index

          • Major - P3 - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-63876 [5.0] Secondary nodes crash when applying collMod with `index.expireAfterSeconds` option

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Improvement - An improvement or enhancement to an existing feature or task. SERVER-9305 Enabling adding expireAfterSeconds to convert to a TTL index

          • Major - P3 - Major loss of function.
          • Closed

          Activity

            People

              yuhong.zhang@mongodb.com Yuhong Zhang
              alonho Alon Horev
              Votes:
              1 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: