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

MySQL InnoDB Details dashboard: Add "sync flushing" to "Innodb Flushing by Type"

    XMLWordPrintable

    Details

    • Story Points:
      1
    • Sprint:
      Platform Sprint 26
    • Needs Review:
      Yes
    • Needs QA:
      Yes

      Description

      Dashboard: "MySQL InnoDB Details"
      Row: "InnoDB Checkpointing and Flushing"
      The panel "Innodb Flushing by Type" does not show one important type of flushing: sync flushing.

       

      Please add the following to this panel:

      {
      "calculatedInterval": "2m",
      "datasourceErrors": {},
      "errors": {},
      "expr": "avg by (service_name) ((rate(mysql_info_schema_innodb_metrics_buffer_buffer_flush_sync_total_pages

      {service_name=~\"$service_name\"}[$interval]) or irate(mysql_info_schema_innodb_metrics_buffer_buffer_flush_sync_total_pages{service_name=~"$service_name"}

      [5m])))",
      "format": "time_series",
      "interval": "$interval",
      "intervalFactor": 1,
      "legendFormat": "Sync Flushing",
      "metric": "",
      "refId": "A",
      "step": 300
      },

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            vadimtk Vadim Tkachenko
            Votes:
            0 Vote for this issue
            Watchers:
            5 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 - 2 hours, 55 minutes
                2h 55m

                  Smart Checklist