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

    • Story Points:
      0
    • Sprint:
      Platform Sprint 28, Platform Sprint 29 (2.12+a2)
    • Needs Review:
      Yes
    • Needs QA:
      Yes
    • Needs Doc:
      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

            Assignee:
            Unassigned
            Reporter:
            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