Check replication lag

Show secondary lag and oplog window

rs.printSecondaryReplicationInfo()
tool
mongodb20 commands
tags
mongodbmonitoring

More mongodb commands

  • 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

  • Kill long-running ops
    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)})'

    List queries running >5s with ns then killOp each; note: killOp is async, verify after

  • Query plan with stats
    mongosh --eval 'db.<name>.find({status:"active"}).explain("executionStats").executionStats'

    Show docs examined vs returned and index usage; COLLSCAN means missing index

all 20 mongodb commands