Master Status
Description
The SHOW MASTER STATUS command provides details of the current Binary Log details from the MySQL server. If Binary Log (–log-bin) is not enabled, no information will be provided.
Syntax
MySQL/MariaDB
mysql> SHOW MASTER STATUS;
Drizzle
drizzle> SHOW MASTER STATUS;
Notes
Example
mysql> SHOW MASTER STATUS; +---------------+----------+--------------+------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +---------------+----------+--------------+------------------+ | mysql-bin.003 | 73 | test | manual,mysql | +---------------+----------+--------------+------------------+