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

MySQL Overview dashboard has an invalid value for connections on graph MySQL Connections

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: 1.1.3
    • Fix Version/s: 1.1.4
    • Component/s: Grafana Dashboards
    • Labels:
      None

      Description

      In the dashboard "MySQL Overview" the value for "Connections" (i.e. currently active) is calculated as the rate of change ie.

      rate(mysql_global_status_connections{instance="$host"}[$interval]) or irate(mysql_global_status_connections{instance="$host"}[5m])
      

      This yields wildly incorrect values, the correct formula is:

      mysql_global_status_threads_connected{instance="$host"}
      

      This bug affects all Managed Services MySQL Clients.

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  nailya.kutlubaeva Nailya Kutlubaeva
                  Reporter:
                  nikolaos.vyzas Nik Vyzas (Inactive)
                • Votes:
                  1 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: