欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

Mongodb的基本性能统计工具简单记录

程序员文章站 2024-02-20 13:47:04
...

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 }