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.

        Smart Checklist

          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