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

POC: Optimise available ticket count based on time spent in WiredTiger

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Done
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • None
    • Execution Team 2022-10-03, Execution Team 2022-10-17

    Description

      WiredTiger maintains several statistics that reflect on how long operations are taking inside the storage engine and if the application threads are waiting on page reads or write. We will experiment with adjusting the total available ticket count based on these statistics to optimize between the workload performance and the concurrency into the storage engine.

      The relevant statistics that I think could be helpful are the following:

      • Frequency distribution of the operation duration inside WiredTiger - available as a histogram
      • Frequency distribution of the disk latencies - available as a histogram
      • A count of threads waiting at any moment to read pages from the disk or write to the disk.

      Attachments

        1. Screen Shot 2022-10-11 at 10.40.55 am.png
          Screen Shot 2022-10-11 at 10.40.55 am.png
          32 kB
        2. Screen Shot 2022-10-11 at 10.41.05 am.png
          Screen Shot 2022-10-11 at 10.41.05 am.png
          51 kB
        3. Screen Shot 2022-10-11 at 11.26.31 am.png
          Screen Shot 2022-10-11 at 11.26.31 am.png
          45 kB
        4. Screen Shot 2022-10-11 at 11.26.45 am.png
          Screen Shot 2022-10-11 at 11.26.45 am.png
          38 kB
        5. Screen Shot 2022-10-13 at 10.03.19 am.png
          Screen Shot 2022-10-13 at 10.03.19 am.png
          187 kB
        6. Screen Shot 2022-10-13 at 10.08.54 am.png
          Screen Shot 2022-10-13 at 10.08.54 am.png
          96 kB
        7. Screen Shot 2022-10-13 at 10.29.06 am.png
          Screen Shot 2022-10-13 at 10.29.06 am.png
          105 kB

        Activity

          People

            sulabh.mahajan@mongodb.com Sulabh Mahajan
            sulabh.mahajan@mongodb.com Sulabh Mahajan
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: