Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-13251

Create a reproducer for the reconcilliation latency in MongoDB 4.4

    • Type: Icon: Bug Bug
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Reconciliation
    • None
    • Storage Engines
    • 8
    • 2024-07-23 - Mining crypto

      Recently we have had a lot of help tickets about the latency spikes from customers upgrading from 4.2 to 4.4.

      We believe the root cause is the following sequence:

      • checkpoint starts and eviction on a table is blocked.
      • more writes on the table happen and the pages continuously to grow.
      • the pages have grown to a point that is much larger than the configured maximum page size.
      • checkpoint finishes and forced eviction kicks in to evict these big pages. Because they are very big, it takes longer to evict them and the reads and writes on these pages are blocked for a longer time causing the spikes.
      • However, the same logic applies to 4.2 as well. There must be something in 4.4 that exacerbates this. e.g., Reconciliation now takes more time in 4.4 because of the history store, IO overhead of the time points we store to disk, or checkpoint cleanup overhead.

      This ticket deals with creating a reproducer that shows this reconciliation between MongoDB 4.2 and 4.4. The ticket will be timeboxed to one week worth of time, and if its not possible to close the ticket as Can't Reproduce.

            Assignee:
            chenhao.qu@mongodb.com Chenhao Qu
            Reporter:
            jie.chen@mongodb.com Jie Chen
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: