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

High query response time for find operation in mongo 4.0.27 with mmap storage engine with random intervals (5/7/12/20 hours)

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 4.0.27
    • Component/s: None
    • None
    • ALL

      Scenario - We have application which is doing CRUD operations on database. From past 2 years we are using mongo 3.6.9 and system is working fine without any issues but when we upgraded the database from 3.6.9 to 4.0.27 and then we started getting high query response time for find operation but it is not consistent in nature ,sometimes we are getting high query response in 5 hours or 7 hours or even 11 hours.

        1. mogostat.txt
          45 kB
        2. rs.status.txt
          9 kB
        3. Screen Shot 2022-02-22 at 3.12.10 PM.png
          Screen Shot 2022-02-22 at 3.12.10 PM.png
          153 kB
        4. Screen Shot 2022-02-23 at 11.39.56 AM.png
          Screen Shot 2022-02-23 at 11.39.56 AM.png
          248 kB

            Assignee:
            edwin.zhou@mongodb.com Edwin Zhou
            Reporter:
            kg3634@gmail.com KAPIL GUPTA
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: