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

Mixed10KThreads read throughput is surprisingly dependent on write throughput

    • Type: Icon: Improvement Improvement
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Product Performance
    • Fully Compatible
    • v8.0
    • 135

      The Mixed10KThread template for a few perf workloads has a very subtle but important nuance that makes it hard to interpret performance results: the read queries match on an increasing set of documents over time because we insert more data that matches the query predicate over time. Read throughput is directly influenced by write throughput, because because the more data we insert, the slower the queries get.

      We should consider imposing a limit of 1 on these queries to isolate these effects, as interpreting results can be incredibly misleading.

        1. Screenshot 2024-04-09 at 15.05.48.png
          Screenshot 2024-04-09 at 15.05.48.png
          62 kB
        2. Screenshot 2024-04-09 at 15.06.16.png
          Screenshot 2024-04-09 at 15.06.16.png
          56 kB
        3. Screenshot 2024-04-09 at 16.32.28.png
          Screenshot 2024-04-09 at 16.32.28.png
          77 kB
        4. Screenshot 2024-04-11 at 12.38.13.png
          Screenshot 2024-04-11 at 12.38.13.png
          74 kB
        5. Screenshot 2024-04-11 at 12.38.41.png
          Screenshot 2024-04-11 at 12.38.41.png
          65 kB
        6. Screenshot 2024-04-11 at 12.39.16.png
          Screenshot 2024-04-11 at 12.39.16.png
          66 kB

            Assignee:
            miguel.nieto@mongodb.com Miguel Angel Nieto
            Reporter:
            louis.williams@mongodb.com Louis Williams
            Votes:
            0 Vote for this issue
            Watchers:
            14 Start watching this issue

              Created:
              Updated:
              Resolved: