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

Create TTL index for config.sampledQueries and config.sampledQueriesDiff on stepup

    • Type: Icon: Task Task
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 6.3.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • None
    • Fully Compatible
    • Sharding NYC 2022-11-28, Sharding 2022-12-12, Sharding NYC 2022-12-26, Sharding NYC 2023-01-09, Sharding NYC 2023-01-23, Sharding NYC 2023-02-06
    • 22
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      • Add mongod server parameter "sampledQueriesExpirationSeconds" (defaults to 7 days).
      • Make config.sampledQueries and config.sampledQueriesDiff documents have an "expireAt" field set to "sampledQueriesExpirationSeconds" after the insert time.
      • Create a [\{key: \{expireAt: 1\},  \{expireAfterSeconds: 0\}] index for these collections upon stepup or setFCV upgrade if it doesn't already exist.

            Assignee:
            israel.hsu@mongodb.com Israel Hsu (Inactive)
            Reporter:
            cheahuychou.mao@mongodb.com Cheahuychou Mao
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: