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

        Smart Checklist

          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