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

InnoDB Checkpoint Age does not show data for MySQL

    Details

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

      Description

      I would like to improve InnoDB Checkpoint Age chart from MySQL InnoDB Metrics Dashboard.
      It shows data only if Percona Server is running, but not if vanilla MySQL.
      However this information might be available from innodb_metrics (if enabled)

      I propose to modify the chart that it would take data from innodb_metrics (for vanilla MySQL).
      The variables to take data you can see on the screenshot

      and I will copy them there:

      mysql_info_schema_innodb_metrics_recovery_log_max_modified_age_async{instance="$host"}
      mysql_info_schema_innodb_metrics_recovery_log_lsn_checkpoint_age_total{instance="$host"}  
      
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  vadimtk Vadim Tkachenko
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

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