Details
-
Improvement
-
Resolution: Done
-
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.