Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-1776

mongos counting bulk insert as 1 op WAS: mongostat shows different insert data when connecting to mongos versus single primary in single rep set

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 1.7.0
    • Component/s: Admin, Sharding
    • Labels:
      None
    • Environment:
      ec2 / ubuntu 10.04
    • ALL

      Problem:
      I'm inserting a bunch of data and seeign different results from mongostat depending on what I connect to.

      Configuration is
      – single mongos
      – single replset, with a single mongod
      – single config

      If I connect to the mongos with mongostat I see the following reported

      vero:10gen$ ./software/mongodb-osx-x86_64-1.6.0/bin/mongostat --port 27500 --host ec2-67-202-19-63.compute-1.amazonaws.com
      connected to: ec2-67-202-19-63.compute-1.amazonaws.com:27500
      insert/s query/s update/s delete/s getmore/s command/s mapped vsize res faults/s locked % idx miss % conn time
      3 0 0 0 0 3 0 166 14 0 0 0 3 17:17:27
      2 0 0 0 0 1 0 166 14 0 0 0 3 17:17:28
      2 0 0 0 0 2 0 166 14 0 0 0 3 17:17:29

      However, if I connect to the single mongod I see the following

      insert/s query/s update/s delete/s getmore/s command/s flushes/s mapped vsize res faults/s locked % idx miss % q t|r|w conn time
      16327 0 0 0 0 3 0 8349 8633 5743 0 32.9 0 0|0|0 8 17:18:16
      16383 0 0 0 0 2 0 8349 8633 5747 0 29.5 0 0|0|0 8 17:18:17
      13617 0 0 0 0 3 0 8349 8633 5743 0 42 0 0|0|0 8 17:18:18
      10867 0 0 0 0 3 0 8349 8633 5747 0 28.2 0 0|0|0 8 17:18:19

      These latter figures match the I see from doing a db.collection.count()

      Reproduce:

      • Setup the following
        • one config server
        • one replset, with a single mongod
        • one config server
      • Start a bulk insert through the mongos
      • run mongostat on the mongos
      • run mongostat on the mongod
      • compair the results

      Business Case:

      • User Expereince

            Assignee:
            brandon Brandon Diamond
            Reporter:
            alvin Alvin Richards (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: