13.6.1.6.SHOWMASTERSTATUS語法
13.6.1.6. SHOW
MASTER STATUS語法
SHOW MASTER STATUS
用于提供主服務器二進制日志文件的狀態信息。例如:
mysql > SHOW MASTER STATUS;
+---------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| mysql-bin.003 | 73 | test | manual,mysql |
+---------------+----------+--------------+------------------+