Run an aggregation pipeline

Top 10 users by total amount of paid orders

db.orders.aggregate([{$match:{status:'paid'}},{$group:{_id:'$userId',total:{$sum:'$amount'}}},{$sort:{total:-1}},{$limit:10}])

tool
mongodb20 commands
tags
mongodb

More mongodb commands

  • rs.printSecondaryReplicationInfo()

    Show how far each secondary is behind the primary

  • db.currentOp({active:true, secs_running:{$gt:5}})

    List operations that run longer than 5 seconds

  • mongodump --uri='mongodb://localhost:27017' --db=mydb --out=/backup/$(date +%F)

    Dump all collections of a database to BSON files in a dated folder

  • mongosh --eval 'rs.status().members.forEach(m=>print(m.name,m.stateStr,m.optimeDate))'

    Show the state and last applied optime of each member to find lagging or unhealthy secondaries

  • mongosh --eval 'db.currentOp({secs_running:{$gt:5},op:{$ne:"none"}}).inprog.forEach(o=>{print(o.opid,o.secs_running,o.ns); db.killOp(o.opid)})'

    Find operations running longer than 5s and kill each with killOp. killOp is async, so check the result afterwards

all 20 mongodb commands