Kevin Rice
unread,Aug 3, 2012, 6:35:12 PM8/3/12Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to mongod...@googlegroups.com
We're running a 4-shard replica'd mongodb and a fairly simple application.
Our application is issuing lots of 'update' commands (pretty much only - every 100 updates, there's an insert).
No one is reading from it yet, we're just pumping in data.
In MongoStat, we see the following (mongostat on the mongos with --discover flag):
boxname:port inserts=10, query=0, update=200, 0=delete, getmore=192, command=157, flushes=0, locked percentages avg. 6% (range 2%-15%).
Actual lines are:
insert query update delete getmore command flushes mapped vsize res faults locked % idx miss % qr|qw ar|aw netIn netOut conn set repl time
b1:30000 1 0 370 0 267 196 0 26.1g 66.2g 8.9g 0 14.5 0 0|0 1|0 140k 254k 1720 shard-00 M
b1:30200 2 0 315 0 238 176 0 24.1g 62.2g 4.14g 0 11.9 0 0|0 1|0 128k 215k 1719 shard-02 M
b1:40000 0 0 0 0 0 1 2.01g 11m 0 62b 803b 6 RTR
b2:30100 0 0 319 0 227 192 0 26.1g 66.2g 3.74g 0 8.5 0 0|0 1|0 119k 226k 1721 shard-01 M
b2:30300 1 0 255 0 194 191 0 22.1g 58.2g 6.38g 0 6.5 0 0|0 1|0 101k 207k 1719 shard-03 M b3:30001 *1 *0 *357 *0 0 60|0 0 96.1g 201g 6.22g 0 8.4 0 0|0 0|0 3k 32k 866 shard-00 SEC
b3:30201 *1 *0 *309 *0 0 55|0 0 96.1g 201g 4.07g 0 7.5 0 0|0 0|0 3k 29k 864 shard-02 SEC
b4:30101 *0 *0 *310 *0 0 64|0 0 96.1g 201g 3.65g 0 6.7 0 0|0 0|0 4k 34k 864 shard-01 SEC
b4:30301 *1 *0 *242 *0 0 65|0 0 94.1g 197g 3.2g 0 5.7 0 0|0 0|0 4k 34k 864 shard-03 SEC
Why the getmore, with no queries? What is 'command' counting, and why are there 192 of them per second?
I'm already indexed-up. Is this a sign that I'm going slower than I could?
Most of my speed concerns are (1) updates and (2) reads (in that order).
BTW: Mongo 2.0.6, each box 192GB memory, SSD drives, 24 cores, low latency b/w boxes.