1392
Comment:
|
1825
|
Deletions are marked like this. | Additions are marked like this. |
Line 36: | Line 36: |
}} | }}} |
Line 46: | Line 49: |
* DB locks * > db.serverStatus().globalLock * > db.serverStatus().locks |
|
Line 47: | Line 54: |
* DB version , want > 3.2 wiretiger document level locking * > db.version() * DB memory usage should be less than ram * > db.serverStatus().mem * > db.serverStatus().wiredTiger.cache * Check number of connections * db.serverStatus().connections * Check indexs on a collection * db.<collection>.getIndexes() |
MongoDB nosql notes
Login
- $ mongo 10.32.2.4 --authenticationDatabase admin --username test --password mypass
> db
- test
> show dbs
> use 9spokes
> db.getCollection("")
> show collections
- db.getCollection("config_data").find()
Replicaset
- View members
mongo admin --host $ip -u root -p $pass -eval "rs.status()"
- Check if current server is the write
mongo admin --host $ip -u root -p $pass --quiet --eval "db.isMaster()['ismaster']"
Recover password
- stop the mongod service
- edit /etc/mongod.conf
:PRIMARY> use admin :PRIMARY> db.createUser({user:"root",pwd:"mongopwd",roles:[{role:"root",db:"admin"}]}); :PRIMARY> db.changeUserPassword("root","mongopwd")
mongo admin --host 192.168.70.13 -u root -p mongopassword --eval 'rs.initiate({_id: "local_sandbox-MongoDB", members: [{_id: 0, host: "192.168.70.11:27017"},{_id: 1, host: "192.168.70.12:27017"},{_id: 2, host: "192.168.70.13:27017"}]})'
- * $ mongo 10.32.2.4 --authenticationDatabase admin --username test --password mypass
> db.currentOp()
> db.currentOp({"secs_running": {$gte: 3}})
Count documents in <db> <collection>
use <db>;
db.<collection>.count()
- DB locks
> db.serverStatus().globalLock
> db.serverStatus().locks
DB version , want > 3.2 wiretiger document level locking
> db.version()
- DB memory usage should be less than ram
> db.serverStatus().mem
> db.serverStatus().wiredTiger.cache
- Check number of connections
- db.serverStatus().connections
- Check indexs on a collection
db.<collection>.getIndexes()
...