Create compound index

Ascending userId + descending createdAt index

db.orders.createIndex({userId: 1, createdAt: -1}, {background: true})
tool
mongodb20 commands
tags
mongodb

More mongodb commands

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

    Top 10 users by paid order amount

  • Check replication lag
    rs.printSecondaryReplicationInfo()

    Show secondary lag and oplog window

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

    List operations running longer than 5 seconds

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

    Dump all collections in a database to BSON files

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

    Per-member state and last applied optime; spot lagging or unhealthy secondaries

all 20 mongodb commands