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

Details

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • 3.4.13, 3.4.14
    • 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.

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: