IO_BEFORE_GTIDS

MySQL

Example:

SHOW BINARY LOGS;
PURGE BINARY LOGS BEFORE 'mysql-bin.00003' IO_BEFORE_GTIDS;

Output:

Query OK, 0 rows affected (0.02 sec)

Explanation:

In the example code, the binary logs before ‘mysql-bin.00003’ are purged. IO_BEFORE_GTIDS ensures that any transactions, present in the purged binary logs and not committed yet by any replication slave, will not be removed. The output indicates the successful execution of the query with 0 rows affected.