START TRANSACTION WITH CONSISTENT SNAPSHOT

FB/MySQL has added new syntax:

START TRANSACTION WITH CONSISTENT ROCKSDB|INNODB SNAPSHOT;

The statement returns the binlog coordinates pointing at the snapshot.

MariaDB (and Percona Server) support extension to the regular

START TRANSACTION WITH CONSISTENT SNAPSHOT;

syntax as documented in Enhancements for START TRANSACTION WITH CONSISTENT SNAPSHOT.

After issuing the statement, one can examine the binlog_snapshot_file and binlog_snapshot_position status variables to see the binlog position that corresponds to the snapshot.

See Also

• START TRANSACTION

• Enhancements for START TRANSACTION WITH CONSISTENT SNAPSHOT

_{This page is licensed: CC BY-SA / Gnu FDL}