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

Insert is taking huge time in wiretiger storage engine

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Incomplete
    • Affects Version/s: 3.0.6
    • Fix Version/s: None
    • Component/s: WiredTiger
    • Labels:
      None

      Description

      Hi,
      Inserts are taking lots of time in wiretiger storage engine.
      We are having around 6000 collections in this database and are using mongo 3.0.6 shard cluster with only one shard and database is not sharded in this cluster.
      Is this the default behaviour or issue with wiretiger storage engine.

      Queries are like this:

      2015-12-16T10:32:13.146+0000 I COMMAND  [conn48] command abc.$cmd command: insert { ins: "56711241e4b0ac2aafd0114a_1450250822756", documents: [ { _id: ObjectId('56713dace4b007382af53e2e'), a: " XXXX", b: "XXX", c: XXX, d: "XXX", e: "123", f: "XXX@XXX.com" } ], g: XX, metadata: { shardName: "shard1", shardVersion: [ Timestamp 0|0, ObjectId('000000000000000000000000') ], session: 0 } } ntoreturn:1 keyUpdates:0 writeConflicts:0 numYields:0 reslen:140 locks:{ Global: { acquireCount: { r: 2, w: 2 } }, Database: { acquireCount: { w: 2 }, acquireWaitCount: { w: 1 }, timeAcquiringMicros: { w: 1138240 } }, Collection: { acquireCount: { w: 1 } }, oplog: { acquireCount: { w: 1 } } } 638ms
      

      Mongostat O/P:

      # mongostat --port 27012
      insert query update delete getmore command % dirty % used flushes vsize   res qr|qw ar|aw netIn netOut conn    set repl     time
        1309   659    657     *0     728   814|0     0.3   80.0       0 22.4G 16.2G   0|0   1|1    1m     2m  167 shard1  PRI 11:10:57
        1154   509    512     *0     727   796|0     0.3   80.0       0 22.4G 16.2G   0|0   1|0    1m     1m  167 shard1  PRI 11:10:58
        1377   731    730     *0     719   827|0     0.3   80.0       0 22.4G 16.2G   0|0   1|0    1m     2m  167 shard1  PRI 11:10:59
        1262   607    606     *0     723   810|0     0.3   80.0       0 22.4G 16.2G   0|0   1|0    1m     2m  167 shard1  PRI 11:11:00
      

      server : EC2 Instance Type: m4.xlarge

        Attachments

          Activity

            People

            Assignee:
            kelsey.schubert Kelsey T Schubert
            Reporter:
            rakesh.mib.j@gmail.com Rakesh Kumar
            Participants:
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: