Retrieve GTID position from a binary log file. This function returns the Global Transaction ID corresponding to a specific file and position in the binlog.
BINLOG_GTID_POS(binlog_filename,binlog_offset)The BINLOG_GTID_POS() function takes as input an old-style binary log position in the form of a file name and a file offset. It looks up the position in the current binlog, and returns a string representation of the corresponding position. If the position is not found in the current binlog, NULL is returned.
- Show events and their positions in the binary log
This page is licensed: CC BY-SA / Gnu FDL
SELECT BINLOG_GTID_POS("master-bin.000001", 600);