Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #1519108: pt-heartbeat should include GTIDs in the heartbeat table

Description

**Reported in Launchpad by monty solomon last update 23-11-2015 21:41:07

To make it easier to monitor and find errant transactions it would be useful to include the Executed Gtid Set in another column in the heartbeat table.

The GTID_SUBSET() and GTID_SUBTRACT() functions could then be executed on the slave(s) to determine the presence of errant transactions.

The GTID information could also be used to determine how far the slave is behind in terms of statements.

Thanks.

Environment

None

Smart Checklist

Activity

Lalit Choudhary March 1, 2019 at 2:13 PM

Hello Monty,

Thank you for the feature request. 

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 8:52 PM
Updated March 4, 2024 at 4:43 PM