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

SST Time Graph based on wrong formula

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: future
    • Fix Version/s: 1.17.0
    • Component/s: Grafana Dashboards
    • Labels:

      Description

      Hi,

      In this Graph:

      The formula is :

      mysql_galera_gcache_size_bytes

      {instance="$host"}/(rate(
      mysql_global_status_wsrep_replicated_bytes{instance="$ host"}[5m])+rate(mysql_global_status_wsrep_received_bytes{instance="$host"}

      [5m]))

      • 300

      There are 2 problems here

      1) The graph is wrong because rate() already normalizes data to per second
      so *300 is undue

      2) This graph design is different from others where we always show value
      per interval which can be selected on top while this one only shows instant
      value

      I have now enhanced the graph in this dashboard

      https://pmmstage.percona.com/dashboard/db/pz-pxc-galera-graphs?orgId=1&var-interval=$__auto_interval&var-instance=All&var-cluster=pxc56-cluster&var-host=pxc56-1

      Which is now helpful to both see variance with resolution needed as well as
      it uses more practical 1h range which is less volatile.


      Peter Zaitsev, CEO, Percona

      Percona Live 2018 Open Source Database Conference
      <https://www.percona.com/live/18/> April 23 - 25, 2018 Santa Clara,CA Get
      Your Ticket Now!, Inquire about Sponsorship!

        Attachments

        1. image.png
          image.png
          89 kB
        2. image.png
          image.png
          75 kB

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                pz Peter Zaitsev
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 hour, 45 minutes
                  1h 45m