Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-4464

Expose the last global transaction identifier (GTID) executed for a CONSISTENT SNAPSHOT.

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.6.x, 5.7.x, 8.0.x
    • Fix Version/s: 8.0.19-10, 5.7.30-33
    • Component/s: None
    • Labels:
      None
    • Needs Review:
      Yes

      Description

      STWCS stashes and provides to the session the binlog file and offset in variables snapshot_file and snapshot_position, but, it does not expose last_gtid_executed. This can be extracted manually from binlogs given the file name and pos, but is not terribly user friendly. So, this new feature discussion is about adding a new snapshot_last_gtid_executed that will capture the same at the beginning of the snapshot and allow users/scripts/tools to have easy access.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              kamil.holubicki Kamil Holubicki
              Reporter:
              george.lorch George Lorch
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 week, 7 hours, 20 minutes
                  1w 7h 20m

                    Smart Checklist