Movatterモバイル変換

SHOW BINARY LOG STATUS

This statement provides status information about binary log files on the source server, and requires theREPLICATION CLIENT privilege (or the deprecatedSUPER privilege).

Example:

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

When global transaction IDs are in use,Executed_Gtid_Set shows the set of GTIDs for transactions that have been executed on the source. This is the same as the value for thegtid_executed system variable on this server, as well as the value forExecuted_Gtid_Set in the output ofSHOW REPLICA STATUS on this server.