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

MySQL Replication Summary: MySQL Replication Delay graph not factoring in value of intentionally set SQL_Delay thus inflating time displayed

    XMLWordPrintable

Details

    • 0
    • Platform Sprint 28, Platform Sprint 29 (2.12+a2)
    • Yes
    • Yes
    • Yes

    Description

      For delayed slaves, the MySQL Replication Delay graph is always showing lag (the value of the delay)

       

      The PromQL should be:

      avg by (service_name) (max_over_time(mysql_slave_status_seconds_behind_master{service_name=~"$service_name"}[5m])-max_over_time(mysql_slave_status_sql_delay{service_name=~"$service_name}[5m]))

      Attachments

        Activity

          People

            Unassigned Unassigned
            daniel.guzman.burgos Daniel Guzman Burgos (Inactive)
            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 - 7 hours, 30 minutes
                7h 30m

                Smart Checklist