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!

        Smart Checklist

          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 - 45 minutes
                    45m