13.7.5.24. SHOW MASTER STATUS Syntax

SHOW MASTER STATUS

This statement provides status information about the binary log files of the master. It requires either the SUPER or REPLICATION CLIENT privilege.

Example:

mysql> SHOW MASTER STATUS\G*************************** 1. row ***************************             File: master-bin.000002         Position: 1307     Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysqlExecuted_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-51 row in set (0.00 sec)

The Executed_Gtid_Set column was added in MySQL 5.6.5. When global transaction IDs are in use, this column shows the set of GTIDs for transactions that have been executed on the master. This is the same as the master's value for the global gtid_executed system variable (named gtid_done prior to MySQL 5.6.9).