Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-1169

Add InnoDB Buffer Pool Reads to InnoDB BUffer Pool Requests graph on MySQL InnoDB Metrics

    Details

    • Type: New Feature
    • Status: New
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Grafana Dashboards
    • Labels:

      Description

      We currently plot the InnoDB BP read/write requests so we can see activity within BP, but we are missing how many InnoDB reads from disk occur, and what ratio of misses exist.  Consider adding two new Query elements to graph InnoDB Buffer Pool Requests:

      1. Read requests from disk
        rate(mysql_global_status_innodb_buffer_pool_reads{instance="$host"}[$interval])
      1. Buffer Pool cache misses
        rate(mysql_global_status_innodb_buffer_pool_reads{instance="$host"}[$interval]) / rate(mysql_global_status_innodb_buffer_pool_read_requests{instance="$instance"}[$interval])  * 100

      If you implement #2, then also set "use 2nd Y-Axis" via an override and set Right Y Axis Unit = percent 0-100.  Also you might need to use the or irate() notation to smooth over any missed data points.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  michael.coburn@percona.com Michael Coburn
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated: