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     |
+---------------+----------+--------------+------------------+
  1. No comments yet.
  1. No trackbacks yet.