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, mysql
Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5
1 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' value for
the global gtid_done system
variable.
"show slave status" on a master returns empty set, but "show master status" on a slave doesn't.
Seems odd to stash this node only under "SQL Statements for Controlling Master Servers." It means _something_ in the context of "SQL Statements for Controlling Slave Servers," but what?
© 2012, Oracle Corporation and/or its affiliates
User Comments
"show slave status" on a master returns empty set, but "show master status" on a slave doesn't.
Seems odd to stash this node only under "SQL Statements for Controlling Master Servers." It means _something_ in the context of "SQL Statements for Controlling Slave Servers," but what?
Add your own comment.