Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-6985

Investigate changes in SERVER-77586: Consider allowing capped collections to have TTL indexes

    • Type: Icon: Investigation Investigation
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • No version
    • Affects Version/s: None
    • Component/s: None
    • None
    • Not Needed

      Original Downstream Change Summary

      TTL indexes can now be created on capped collections, previously this was not allowed.

      Description of Linked Ticket

      MongoDB doesn't currently allow capped collections to have TTL indexes. The reason dated back to when capped collections used to not replicate explicitly and so it wasn't possible to delete from them and get consistent results. In PM-1858, we want the collections for storing sampled queries (config.sampledQueries and config.sampledQueriesDiff) to be both capped and have a TTL index. These collections currently have TTL indexes but are not capped because of the aforementioned restriction.

            Assignee:
            Unassigned Unassigned
            Reporter:
            backlog-server-pm Backlog - Core Eng Program Management Team
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: