Mongodb的基本性能统计工具简单记录 1.Mongostat 查看某组运行中的MongoDB实例的统计信息; [root@Mongodb ~]# /Apps/mongo/bin/mongostat connected to: 127.0.0.1 insert query update delete getmore command flushes mapped vsize res faults locked % id
Mongodb的基本性能统计工具简单记录
1.Mongostat
查看某组运行中的MongoDB实例的统计信息;
[root@Mongodb ~]# /Apps/mongo/bin/mongostat
connected to: 127.0.0.1
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:41
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:42
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:43
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:44
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:45
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:46
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:47
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:48
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:49
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:50
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:51
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:52
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:53
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:54
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:55
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:56
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:57
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:58
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:11:59
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:00
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:01
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:02
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:03
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:04
0 1 0 0 0 2 0 32m 126m 21m 0 0 0 0|0 0|0 187b 1k 2 00:12:05
0 1 0 0 0 2 0 32m 126m 21m 0 0 0 0|0 0|0 187b 1k 2 00:12:06
0 2 0 0 0 3 0 32m 126m 21m 0 0 0 0|0 0|0 312b 1k 2 00:12:07
0 2 0 0 0 3 0 32m 126m 21m 0 0 0 0|0 0|0 312b 1k 2 00:12:08
0 2 0 0 0 3 0 32m 126m 21m 0 0 0 0|0 0|0 312b 1k 2 00:12:09
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:10
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn time
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:11
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:12
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:13
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:14
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:15
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:16
0 0 0 0 0 1 0 32m 126m 21m 0 0 0 0|0 0|0 62b 1k 2 00:12:17
[root@Mongodb ~]#
2.db.serverStatus
这个命令是最常用也是最基础的查看实例运行状态的命令之一;
> db.serverStatus()
{
"host" : "Mongodb",
"version" : "1.8.1",
"process" : "mongod",
"uptime" : 23835,
"uptimeEstimate" : 19085,
"localTime" : ISODate("2013-06-04T16:13:54.759Z"),
"globalLock" : {
"totalTime" : 23835266950,
"lockTime" : 1406729,
"ratio" : 0.000059018806164451204,
"currentQueue" : {
"total" : 0,
"readers" : 0,
"writers" : 0
},
"activeClients" : {
"total" : 0,
"readers" : 0,
"writers" : 0
}
},
"mem" : {
"bits" : 32,
"resident" : 21,
"virtual" : 126,
"supported" : true,
"mapped" : 32
},
"connections" : {
"current" : 1,
"available" : 818
},
"extra_info" : {
"note" : "fields vary by platform",
"heap_usage_bytes" : 291432,
"page_faults" : 88
},
"indexCounters" : {
"btree" : {
"accesses" : 1,
"hits" : 1,
"misses" : 0,
"resets" : 0,
"missRatio" : 0
}
},
"backgroundFlushing" : {
"flushes" : 397,
"total_ms" : 75,
"average_ms" : 0.1889168765743073,
"last_ms" : 0,
"last_finished" : ISODate("2013-06-04T16:13:40.114Z")
},
"cursors" : {
"totalOpen" : 13,
"clientCursors_size" : 13,
"timedOut" : 5
},
"network" : {
"bytesIn" : 13775,
"bytesOut" : 61049,
"numRequests" : 203
},
"opcounters" : {
"insert" : 21,
"query" : 55,
"update" : 1,
"delete" : 0,
"getmore" : 0,
"command" : 127
},
"asserts" : {
"regular" : 0,
"warning" : 0,
"msg" : 0,
"user" : 1,
"rollovers" : 0
},
"writeBacksQueued" : false,
"ok" : 1
}
>
3.db.stats()
db.stats 查看数据库状态信息;
> db.stats()
{
"db" : "test",
"collections" : 4,
"objects" : 28,
"avgObjSize" : 43.142857142857146,
"dataSize" : 1208,
"storageSize" : 10496,
"numExtents" : 4,
"indexes" : 2,
"indexSize" : 16384,
"fileSize" : 50331648,
"ok" : 1
}
>
4.mongosniff
此工具可以从底层监控到底有哪些命令发送给了MongoDB去执行，从中就可以进行分析;
[root@Mongodb ~]# /Apps/mongo/bin/mongosniff --source NET lo
sniffing... 27017
127.0.0.1:42168 -->> 127.0.0.1:27017 test.things 45 bytes id:8cee6609 2364433929
query: {} ntoreturn: 3 ntoskip: 2
127.0.0.1:27017
reply n:3 cursorId: 2553044974605072461
{ _id: ObjectId('51adf11685702b41681359ae'), x: 4.0, j: 1.0 }
127.0.0.1:42168 -->> 127.0.0.1:27017 admin.$cmd 80 bytes id:8cee660a 2364433930
query: { replSetGetStatus: 1, forShell: 1 } ntoreturn: 1 ntoskip: 0
127.0.0.1:27017
reply n:1 cursorId: 0
{ errmsg: "not running with --replSet", ok: 0.0 }
^[[A127.0.0.1:42168 -->> 127.0.0.1:27017 test.things 45 bytes id:8cee660b 2364433931
query: {} ntoreturn: 3 ntoskip: 2
127.0.0.1:27017
reply n:3 cursorId: 6216195059213048439
{ _id: ObjectId('51adf11685702b41681359ae'), x: 4.0, j: 1.0 }
127.0.0.1:42168 -->> 127.0.0.1:27017 admin.$cmd 80 bytes id:8cee660c 2364433932
query: { replSetGetStatus: 1, forShell: 1 } ntoreturn: 1 ntoskip: 0
127.0.0.1:27017
reply n:1 cursorId: 0
{ errmsg: "not running with --replSet", ok: 0.0 }
^[[?1;2c127.0.0.1:42168 -->> 127.0.0.1:27017 test.$cmd 82 bytes id:8cee660d 2364433933
query: { count: "c1", query: {}, fields: {} } ntoreturn: -1 ntoskip: 0
127.0.0.1:27017
reply n:1 cursorId: 0
{ n: 1.0, ok: 1.0 }
Analisis statistik
Perbezaan antara mongodb dan mysql
arahan permulaan mongodb
Bagaimana untuk memadam data dalam MongoDB
Perisian pangkalan data yang biasa digunakan
Bagaimanakah prestasi php8?
Apakah kawasan aplikasi mongodb?
Yang manakah mempunyai kelajuan bacaan yang lebih pantas, mongodb atau redis?
![[Web front-end] Permulaan pantas Node.js](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
