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.

Details

    • New Feature
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 5.6.x, 5.7.x, 8.0.x
    • 8.0.19-10, 5.7.30-33
    • None
    • None
    • 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

              kamil.holubicki Kamil Holubicki
              george.lorch George Lorch (Inactive)
              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