MySQL tutorial: SHOW MASTER STATUS [EN]
top of page
CerebroSQL

MySQL: 

SHOW MASTER STATUS

Syntax:
SHOW MASTER STATUS

This statement provides status information about the binary log files
of the source server. It requires the REPLICATION CLIENT privilege (or
the deprecated SUPER privilege).

Example:

mysql> SHOW MASTER STATUS\G
*************************** 1. row ***************************
File: source-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)

Example

bottom of page