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

TTL Index is having more Latency

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 3.0.4
    • Component/s: TTL
    • Labels:
      None
    • ALL

      Hi Team,
      We are using mongodb V 3.0.4 and storage engine of "WiredTiger". In one of our collections', we are storing the security/auth tokens with TTL index on token expiry time. We are aware that, as per our mongo documentation, we will have a latency of around 1 min. But in our system we are seeing a latency of around 15 - 20 mins. As we are planning to implement authentication based on the same, it would be a major security concern.
      Another interesting fact we found here is, even after 15 mins, the TTL logic is only deleting the oldest record and not all the expired records. Say for example, if TTL indexed column is having timestamps, 10:25am, 10:26am, 10:28 am etc... and while we check at around 10:40am only record with 10:25am is getting deleted and not all the expired data, similarly say at 10:45 am it is deleting only record with 10:26am and not all the expired data.
      We checked if any option to reduce the sync time, but as per mongo documentation, we couldn't find a one.
      Kindly guide us on the same.

      Regards,
      Kingsly J

            Assignee:
            ramon.fernandez@mongodb.com Ramon Fernandez Marina
            Reporter:
            jebas Kingsly J
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved: