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

Track bytes read into cache per query

    • Type: Icon: Improvement Improvement
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Diagnostics, WiredTiger
    • Labels:
    • Storage Engines 2019-01-14
    • 0

      When slow queries are logged we include information about documents and index entries scanned to help diagnose performance issues. However that information doesn't tell us whether the documents or index entries scanned were in cache or not, and if they are not in cache they can have a much more significant performance impact. Reporting bytes read into cache for each query logged would help diagnose the cause of performance issues related to cache pressure.

      This might be accomplished by tracking bytes read into cache per cursor or per session in WT, and computing the difference between the value of this counter before and after each query. Query performance impact would need to be evaluated.

            bruce.lucas@mongodb.com Bruce Lucas (Inactive)
            bruce.lucas@mongodb.com Bruce Lucas (Inactive)
            33 Vote for this issue
            26 Start watching this issue