Why: Mongostat - lots of GetMores & Commands, but no queries ?

438 views
Skip to first unread message

Kevin Rice

unread,
Aug 3, 2012, 6:35:12 PM8/3/12
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.

Eliot Horowitz

unread,
Aug 3, 2012, 8:35:11 PM8/3/12
to mongod...@googlegroups.com
the getMore or from the secondaries pulling the oplog.
the commands could be a number of things: getLastError, counts,
monitoring, etc...
> --
> You received this message because you are subscribed to the Google
> Groups "mongodb-user" group.
> To post to this group, send email to mongod...@googlegroups.com
> To unsubscribe from this group, send email to
> mongodb-user...@googlegroups.com
> See also the IRC channel -- freenode.net#mongodb
Reply all
Reply to author
Forward
0 new messages