Mongodb的基本性能统计工具简单记录
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 }
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Bitcoin price today
Apr 28, 2025 pm 07:39 PM
Bitcoin’s price fluctuations today are affected by many factors such as macroeconomics, policies, and market sentiment. Investors need to pay attention to technical and fundamental analysis to make informed decisions.
Free coins trading market software recommendations The top ten easy-to-use coins trading apps
Apr 28, 2025 pm 04:33 PM
The top ten recommended cryptocurrency trading software are: 1. OKX, 2. Binance, 3. Coinbase, 4. KuCoin, 5. Huobi, 6. Crypto.com, 7. Kraken, 8. Bitfinex, 9. Bybit, 10. Gate.io. These apps all provide real-time market data and trading tools, suitable for users at different levels.
Download the official website of Ouyi Exchange app for Apple mobile phone
Apr 28, 2025 pm 06:57 PM
The Ouyi Exchange app supports downloading of Apple mobile phones, visit the official website, click the "Apple Mobile" option, obtain and install it in the App Store, register or log in to conduct cryptocurrency trading.
Recommended reliable digital currency trading platforms. Top 10 digital currency exchanges in the world. 2025
Apr 28, 2025 pm 04:30 PM
Recommended reliable digital currency trading platforms: 1. OKX, 2. Binance, 3. Coinbase, 4. Kraken, 5. Huobi, 6. KuCoin, 7. Bitfinex, 8. Gemini, 9. Bitstamp, 10. Poloniex, these platforms are known for their security, user experience and diverse functions, suitable for users at different levels of digital currency transactions
How much is Bitcoin worth
Apr 28, 2025 pm 07:42 PM
Bitcoin’s price ranges from $20,000 to $30,000. 1. Bitcoin’s price has fluctuated dramatically since 2009, reaching nearly $20,000 in 2017 and nearly $60,000 in 2021. 2. Prices are affected by factors such as market demand, supply, and macroeconomic environment. 3. Get real-time prices through exchanges, mobile apps and websites. 4. Bitcoin price is highly volatile, driven by market sentiment and external factors. 5. It has a certain relationship with traditional financial markets and is affected by global stock markets, the strength of the US dollar, etc. 6. The long-term trend is bullish, but risks need to be assessed with caution.
Spot King Transformation Note: How to layout the next generation of on-chain ecosystem with Gate.io MeMebox 2.0?
Apr 28, 2025 pm 03:36 PM
Gate.io has achieved the transformation from spot trading to on-chain ecosystem through MeMebox 2.0. 1) Build a cross-chain infrastructure and support the interoperability of 12 main chains; 2) Create a DeFi application ecosystem and provide one-stop services; 3) Implement incentive mechanisms and reconstruct value allocation.
How to choose a compliant and secure Bitcoin trading platform
Apr 28, 2025 pm 05:42 PM
When choosing a compliant and secure Bitcoin trading platform, you need to evaluate its regulatory license, KYC/AML policies and security measures, and recommend three major platforms: Binance, OKX and gate.io.
How to use the chrono library in C?
Apr 28, 2025 pm 10:18 PM
Using the chrono library in C can allow you to control time and time intervals more accurately. Let's explore the charm of this library. C's chrono library is part of the standard library, which provides a modern way to deal with time and time intervals. For programmers who have suffered from time.h and ctime, chrono is undoubtedly a boon. It not only improves the readability and maintainability of the code, but also provides higher accuracy and flexibility. Let's start with the basics. The chrono library mainly includes the following key components: std::chrono::system_clock: represents the system clock, used to obtain the current time. std::chron
