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

Lower performance of out-of-order inserts can contribute to replication lag

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      SERVER-19122 and SERVER-18983 describe two separate cases where table inserts on a MongoDB primary are done in-order on the primary but are done out-of-order on the secondary, and the result is that the secondary may not be able to keep up with the primary, apparently due to the performance difference between these cases in WT. It may be difficult to address the issue in mongod, so this ticket is to track whether the performance difference can be addressed in WT.

      Stack traces seem to indicate that the primary difference is that inserts in the disordered case are delayed by evictions due to page splits, but not in the ordered case. Will attach data.

        Attachments

        1. comparison-fast.html
          14.28 MB
        2. comparison-fast.png
          comparison-fast.png
          199 kB
        3. comparison-slow.html
          14.18 MB
        4. comparison-slow.png
          comparison-slow.png
          382 kB

          Issue Links

            Activity

              People

              Assignee:
              backlog-server-storage-engines Backlog - Storage Engines Team
              Reporter:
              bruce.lucas Bruce Lucas
              Votes:
              0 Vote for this issue
              Watchers:
              13 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: