db.dumpCapped.drop()
db.createCollection( "dumpCapped", { capped: true, size: 50000 } )
for(x=0;x<=10000;x++){
db.dumpCapped.insert({"x":x})
}
opsmanager:PRIMARY> db.dumpCapped.find().limit(1).sort({$natural:1})
{ "_id" : ObjectId("5f1de6c78e567968a23bd09c"), "x" : 8481 }
opsmanager:PRIMARY> db.dumpCapped.find().limit(1).sort({$natural:-1})
{ "_id" : ObjectId("5f1de6c88e567968a23bd68b"), "x" : 10000 }
opsmanager:PRIMARY>
Verify count and min/max:
opsmanager:PRIMARY> db.dumpCapped.count()
1520
opsmanager:PRIMARY> db.dumpCapped.aggregate(
... [
... {
... $group:
... {
... _id: null,
... minX: { $min: "$x" }
... }
... }
... ]
... )
{ "_id" : null, "minX" : 8481 }
opsmanager:PRIMARY> db.dumpCapped.aggregate(
... [
... {
... $group:
... {
... _id: null,
... maxX: { $max: "$x" }
... }
... }
... ]
... )
{ "_id" : null, "maxX" : 10000 }
opsmanager:PRIMARY>
Dump:
mongodump -h localhost:27017 -d ipc -c dumpCapped -u ${USER} -p ${PW} --authenticationDatabase admin --out /data/backup/
2020-07-26T22:28:38.012+0200 writing ipc.dumpCapped to
2020-07-26T22:28:38.030+0200 done dumping ipc.dumpCapped (1520 documents)
db.dumpCapped.drop()
db.createCollection( "dumpCapped", { capped: true, size: 50000 } )
mongorestore -h localhost:27017 -d ipc -c dumpCapped -u ${USER} -p ${PW} --authenticationDatabase admin /data/backup/ipc/dumpCapped.bson
2020-07-26T22:30:32.071+0200 checking for collection data in /data/backup/ipc/dumpCapped.bson
2020-07-26T22:30:32.080+0200 reading metadata for ipc.dumpCapped from /data/backup/ipc/dumpCapped.metadata.json
2020-07-26T22:30:32.081+0200 restoring ipc.dumpCapped from /data/backup/ipc/dumpCapped.bson
2020-07-26T22:30:32.202+0200 no indexes to restore
2020-07-26T22:30:32.202+0200 finished restoring ipc.dumpCapped (1520 documents)
2020-07-26T22:30:32.202+0200 done
opsmanager:PRIMARY> db.dumpCapped.find().limit(1).sort({$natural:1})
{ "_id" : ObjectId("5f1de8936b4a00b5fc18dd5e"), "x" : 8481 }
opsmanager:PRIMARY> db.dumpCapped.find().limit(1).sort({$natural:-1})
{ "_id" : ObjectId("5f1de8936b4a00b5fc18e150"), "x" : 9491 }
opsmanager:PRIMARY> db.dumpCapped.count()
1520
opsmanager:PRIMARY> db.dumpCapped.aggregate(
... ... ... [
... ... ... {
... ... ... $group:
... ... ... {
... ... ... _id: null,
... ... ... minX: { $min: "$x" }
... ... ... }
... ... ... }
... ... ... ]
... ... ... )
{ "_id" : null, "minX" : 8481 }
opsmanager:PRIMARY> db.dumpCapped.aggregate(
... ... ... [
... ... ... {
... ... ... $group:
... ... ... {
... ... ... _id: null,
... ... ... maxX: { $max: "$x" }
... ... ... }
... ... ... }
... ... ... ]
... ... ... )
{ "_id" : null, "maxX" : 10000 }
Major - P3 SERVER-49916 use storageSize instead of size when creating capped collections
