'Throttle TTL in Mongo 3.5.4

We have a large collection with 142 million documents and the ttl index set to 19 years. We want to lower to 3 years buying lowering the ttl.

We started slow roll with 3 million and we saw huge spike in the timeouts when the ttl started selling the data. Delete was running at 10k ops.

The questions are

  1. Are there more than 1 ttl thread running? The documentation says it runs every 60 seconds. What happens when the first ttl runs longer than 1 min? Does new threads start out the previous thread keeps running?
  2. What’s the best way to throttle the ttl and make it run at the predefined ops like 1000 deletes per seconds?
mongodbttl


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions