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

TTL Deletes the record, but doesn't clear the indexs for the collection

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 3.4.13, 3.4.14
    • Component/s: TTL, WiredTiger
    • None
    • ALL
    • Hide
      • Disable TTL monitor so it doesn't delete the records.
      • Create a sample collection with TTL index.
      • import data
      • Get the collection size stats.
      • Enable TTL monitor
      • After TTL deletes are finished, get the collection stats.
      • The collection storage size is reduced, but the index size stays the same.
      Show
      Disable TTL monitor so it doesn't delete the records. Create a sample collection with TTL index. import data Get the collection size stats. Enable TTL monitor After TTL deletes are finished, get the collection stats. The collection storage size is reduced, but the index size stays the same.

      We have a collection with 200 milliion document which has an TTL index for 1 year.
      The data in the collection is inserted daily around 5 gb a day. The past years data is getting deleted when the TTL deletes run.

      But the index size on the collection is not getting reduce after TTL index deletion.

            Assignee:
            kelsey.schubert@mongodb.com Kelsey Schubert
            Reporter:
            cyberwalk3r Cyberwalker
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: