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

Mongodb write performance issue in v7.0 Timeseries Collection

    • Type: Icon: Bug Bug
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Environment:
      Mongodb 7.0 version
    • Server Triage

      we are finding slowness/inconsistency in write speed on mongodb 7.0 timeseries collection.
      On 7.0.4 installation with 6.0 feature set and we are able to injest 250mn events an hour (batch size 100 events) with avg latency of 100microsecs per event. Once we switch to 7.0.4 feature set, the avg latency turns out to 500 microseconds per event and eventually increases more than 1000 microseconds. Sometimes it increases and decreases and shows inconsistency in write speed. After writing few milion events, if we switch again to 6.0 feature set, the write avg latency switch back to 100 microseconds per event and it stays consistent even after billions of events injestion. We observed the same with 6.0 installation too not just with 7.0.4 installation with 6.0 feature set.

      Create collection query:
      db.createCollection("weather",{timeseries:{timeField:"time", metaField:"meta",granularity:"hours"}})

      we do insert many query

      mongo is installed with 7.0.4 version
      command used for switching feature set:
      db.adminCommand( { setFeatureCompatibilityVersion: "7.0", confirm: true } )
      db.adminCommand( { setFeatureCompatibilityVersion: "6.0", confirm: true } )

      command used for checking feature set:
      db.adminCommand( { getParameter: 1, featureCompatibilityVersion: 1 } )

        1. image (10).png
          image (10).png
          188 kB
        2. image (8).png
          image (8).png
          200 kB
        3. image (9).png
          image (9).png
          204 kB

            Assignee:
            chris.kelly@mongodb.com Chris Kelly
            Reporter:
            santhoshms511@gmail.com santhosha MS
            Votes:
            3 Vote for this issue
            Watchers:
            15 Start watching this issue

              Created:
              Updated: