WAIT_FOR_EXECUTED_GTID_SET(gtid_set[, timeout])

WAIT_FOR_EXECUTED_GTID_SET(gtid_set[, timeout])

Syntax

MYSQL Copy

SELECT WAIT_FOR_EXECUTED_GTID_SET('3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5');
0

Examples

Example

Wait until the server has applied all of the transactions whose global transaction identifiers are contained in gtid_set; that is, until the condition GTID_SUBSET(gtid_subset, @@GLOBAL.gtid_executed) holds. See Section 19.1.3.1, “GTID Format and Storage” for a definition of GTID sets.

MYSQL Copy

SELECT WAIT_FOR_EXECUTED_GTID_SET('3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5');
0