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

Reduce volume of metrics retrieved on MySQL Command/Handler Compare dashboard

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.2.0
    • Component/s: Grafana Dashboards
    • Labels:
      None
    • Story Points:
      2
    • Sprint:
      Platform Sprint 6
    • Needs Review:
      Yes
    • Needs QA:
      Yes
    • Needs Doc:
      Yes

      Description

      The default of All creates a lot of queries and load on PMM Server, and likely not many of the graphs get looked at.  Here is a pattern that should return non zero values to print interesting lines:

      var-command=alter_table&var-command=delete&var-command=insert&var-command=replace&var-command=select&var-command=update&var-handler=commit&var-handler=delete&var-handler=update&var-handler=write

      https://pmmdemo.percona.com/graph/d/000000170/mysql-command-handler-counters-compare?orgId=1&var-interval=$__auto_interval_interval&var-host=mdb102&var-command=alter_table&var-command=delete&var-command=insert&var-command=replace&var-command=select&var-command=update&var-handler=commit&var-handler=delete&var-handler=update&var-handler=write

      TODO: We should specify Default values to Variables in Dashboard to use this ^^ set of values

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              michael.coburn@percona.com Michael Coburn
              Votes:
              0 Vote for this issue
              Watchers:
              3 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 - 4 hours, 50 minutes
                  4h 50m

                    Smart Checklist