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

Add graph for InnoDB Spin waits ratio to Spin rounds

    Details

    • Type: Improvement
    • Status: Confirmation
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Grafana Dashboards
    • Labels:

      Description

      Hi, we should have a graph that relates InnoDB Spin Waits to Spin Rounds.  Currently we have the actual count of OS Waits, Spin Rounds but we are missing a way to relate the two values together.  For example if I did  1000 rounds for 1000 waits, then I waited very little, but if I did 1000 rounds for 10 waits then I have some mild contention worth exploring.

      Here is the general idea:

      rate(mysql_global_status_innodb_mutex_spin_waits{instance="ps56"}[5m]) / rate(mysql_global_status_innodb_mutex_spin_rounds{instance="ps56"}[5m]) * 100

      /cc Marcos Albe - props for the idea!

        Smart Checklist

          Attachments

            Activity

              People

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

                Dates

                • Created:
                  Updated: