MongoDB TTL Collections vs. Application-Layer Expiry: Mechanics, Index Contention, and the Data Lifecycle Trap

TTL indexes seem free until they collide with your write path. Here's the full mechanics, contention surface, and when to route around them.