技术干货 | MongoDB 如何设置时间序列集合的自动删除（TTL）？

db.createCollection(
    "weather24h",
    {
       timeseries: {
          timeField: "timestamp",
          metaField: "metadata",
          granularity: "hours"
       },
       expireAfterSeconds: 86400
    }
)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.

{
   "metadata": {"sensorId": 5578, "type": "temperature"},
   "timestamp": ISODate("2021-05-18T10:00:00.000Z"),
   "temp": 12
}
1.
2.
3.
4.
5.

db.runCommand({
   collMod: "weather24h",
   expireAfterSeconds: 604801
})
1.
2.
3.
4.

db.runCommand({
   collMod: "weather24h",
   expireAfterSeconds: 604801
})
1.
2.
3.
4.

db.runCommand( { listCollections: 1 } )
1.

{
    cursor: {
       id: <number>,
       ns: 'test.$cmd.listCollections',
       firstBatch: [
         {
            name: <string>,
            type: 'timeseries',
            options: {
               expireAfterSeconds: <number>,
               timeseries: { ... }
            },
            ...
         },
         ...
       ]
    }
 }
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.

db.runCommand({
    collMod: "weather24h",
    expireAfterSeconds: "off"
})
1.
2.
3.
4.