Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1041

LP #1073747: pt-table-checksum: First TIME includes time waited for slave to catch up

Details

    Description

      **Reported in Launchpad by Mrten last update 01-11-2012 19:43:56

      2.1.5. This is cosmetic.

      I had a broken slave when I fired up pt-table-checksum:

      Replica lag is 20401 seconds on piro.ii.nl. Waiting.
      Replica lag is 19223 seconds on piro.ii.nl. Waiting.
      Replica lag is 17271 seconds on piro.ii.nl. Waiting.
      Replica lag is 16169 seconds on piro.ii.nl. Waiting.
      Replica lag is 10468 seconds on piro.ii.nl. Waiting.
      Replica lag is 6983 seconds on piro.ii.nl. Waiting.
      TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
      10-31T23:35:34 0 0 0 1 0 6583.534 aal.a_files

      It seems that the first value in the TIME column includes the time waiting for the slave to start up, the next run didn't have it.

      TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
      10-31T23:43:52 0 0 0 1 0 0.069 aal.a_files

      Ahyup, stopping/starting the slave triggered it again:

      Replica piro.ii.nl is stopped. Waiting.
      TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
      10-31T23:55:56 0 0 0 1 0 13.137 aalborg.a_files

      Attachments

        Activity

          People

            Unassigned Unassigned
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Smart Checklist