時間:2024-02-08 11:17作者:下載吧人氣:23
下載 tools
mongodb-database-tools-rhel70-x86_64-100.6.0.tgz
解壓到 mongodb/bin目錄下
[root@5e7b4039fa6f bin]# pwd
/data/mongodb/bin
[root@5e7b4039fa6f bin]#
[root@5e7b4039fa6f bin]# ll
total 366500
-rwxr-xr-x. 1 root root 14006152 Aug 18 21:04 bsondump
-rwxr-xr-x. 1 root root 15205 Sep 29 11:18 install_compass
-rwxr-xr-x. 1 root root 58599688 Sep 29 12:05 mongo
-rwxr-xr-x. 1 root root 110063096 Sep 29 12:04 mongod
-rwxr-xr-x. 1 root root 16681384 Aug 18 21:04 mongodump
-rwxr-xr-x. 1 root root 16342896 Aug 18 21:04 mongoexport
-rwxr-xr-x. 1 root root 17288152 Aug 18 21:04 mongofiles
-rwxr-xr-x. 1 root root 16615512 Aug 18 21:04 mongoimport
-rwxr-xr-x. 1 root root 17062464 Aug 18 21:04 mongorestore
-rwxr-xr-x. 1 root root 76724856 Sep 29 12:05 mongos
-rwxr-xr-x. 1 root root 16173064 Aug 18 21:04 mongostat
-rwxr-xr-x. 1 root root 15705384 Aug 18 21:04 mongotop
mongodb實時監控之mongostat
mongostat可以實時監控mongodb的狀態,一直刷新輸出
測試腳本
for(i=1; i<=50000;i++){
db.myuser.insert( {name:’mytest’+i, age:i} )
}
mongostat –help
mongostat -h 127.0.0.1:27017
root@5e7b4039fa6f bin]# mongostat
insert query update delete getmore command dirty used flushes vsize res qrw arw net_in net_out conn time
418 *0 *0 *0 0 0|0 0.3% 0.3% 0 1.66G 194M 0|0 0|1 76.3k 164k 4 Nov 2 11:13:27.970
320 *0 *0 *0 0 1|0 0.3% 0.3% 0 1.66G 194M 0|0 0|0 58.5k 139k 4 Nov 2 11:13:28.967
381 *0 *0 *0 0 0|0 0.3% 0.3% 0 1.66G 194M 0|1 0|0 69.6k 154k 4 Nov 2 11:13:29.970
365 *0 *0 *0 0 1|0 0.3% 0.4% 0 1.66G 194M 0|0 0|0 66.7k 151k 4 Nov 2 11:13:30.968
371 *0 *0 *0 0 1|0 0.4% 0.4% 0 1.66G 194M 0|0 0|1 67.7k 152k 4 Nov 2 11:13:31.967
346 *0 *0 *0 0 0|0 0.4% 0.4% 0 1.66G 194M 0|0 0|1 63.2k 146k 4 Nov 2 11:13:32.967
352 *0 *0 *0 0 0|0 0.4% 0.4% 0 1.66G 194M 0|0 0|1 64.3k 147k 4 Nov 2 11:13:33.967
299 *0 *0 *0 0 0|0 0.4% 0.4% 0 1.66G 194M 0|0 0|1 54.7k 134k 4 Nov 2 11:13:34.968
328 *0 *0 *0 0 1|0 0.4% 0.4% 0 1.66G 194M 0|0 0|1 59.8k 141k 4 Nov 2 11:13:35.967
307 *0 *0 *0 0 3|0 0.4% 0.4% 0 1.66G 194M 0|0 0|1 56.2k 136k 4 Nov 2 11:13:36.967
dirty: 臟數據
flushes 刷新后dirty會清零
mongodb監控之serverStatus
serverStatus可用來獲取mongodb的狀態信息
db.serverStatus()#查看所有的監控信息
db.serverStatus().network#單獨查看網絡流量信息
db.serverStatus().network
{
“bytesIn” : NumberLong(98285080),
“bytesOut” : NumberLong(51318350),
“physicalBytesIn” : NumberLong(98280936),
“physicalBytesOut” : NumberLong(51318350),
“numSlowDNSOperations” : NumberLong(0),
“numSlowSSLOperations” : NumberLong(0),
“numRequests” : NumberLong(538374),
“tcpFastOpen” : {
“kernelSetting” : NumberLong(0),
“serverSupported” : true,
“clientSupported” : false,
“accepted” : NumberLong(0)
},
“compression” : {
“snappy” : {
“compressor” : {
db.serverStatus().mem #內存
db.serverStatus().mem
{ “bits” : 64, “resident” : 194, “virtual” : 1701, “supported” : true }
db.serverStatus().opcounters#統計增、刪、改、查的次數
db.serverStatus().opcounters
{
“insert” : NumberLong(537487),
“query” : NumberLong(69),
“update” : NumberLong(26),
“delete” : NumberLong(9),
“getmore” : NumberLong(0),
“command” : NumberLong(1069)
}
db.serverStatus().connections#連接
db.serverStatus().connections
{
“current” : 4,
“available” : 838856,
“totalCreated” : 20,
“active” : 2,
“threaded” : 4,
“exhaustIsMaster” : 0,
“exhaustHello” : 1,
“awaitingTopologyChanges” : 1
}
使用非交互式shell進行獲取
echo ‘db.serverStatus()’ | mongo
echo ‘db.serverStatus().opcounters’ | mongo
[root@5e7b4039fa6f ~]# echo ‘db.serverStatus().opcounters’ | mongo
MongoDB shell version v5.0.13
connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb
Implicit session: session { “id” : UUID(“627d44f9-7102-441a-8a8a-547da8d9e672”) }
MongoDB server version: 5.0.13
Warning: the “mongo” shell has been superseded by “mongosh”,
which delivers improved usability and compatibility.The “mongo” shell has been deprecated and will be removed in
an upcoming release.
For installation instructions, see
https://docs.mongodb.com/mongodb-shell/install/
{
“insert” : NumberLong(537487),
“query” : NumberLong(70),
“update” : NumberLong(28),
“delete” : NumberLong(14),
“getmore” : NumberLong(0),
“command” : NumberLong(1434)
}
bye
echo ‘db.serverStatus().opcounters.insert’ |mongo
[root@5e7b4039fa6f ~]# echo ‘db.serverStatus().opcounters.insert’ |mongo
MongoDB shell version v5.0.13
connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb
Implicit session: session { “id” : UUID(“15a87edc-5902-4a0b-97c2-3c9be5ff320f”) }
MongoDB server version: 5.0.13
Warning: the “mongo” shell has been superseded by “mongosh”,
which delivers improved usability and compatibility.The “mongo” shell has been deprecated and will be removed in
an upcoming release.
For installation instructions, see
https://docs.mongodb.com/mongodb-shell/install/
NumberLong(537487)
網友評論