Monitoring MySQL

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> SHOW MASTER STATUS;

References

MySQL 5.1 Reference Manual – SHOW MASTER STATUS Syntax

Notes

Example

mysql> SHOW MASTER STATUS;
+---------------+----------+--------------+------------------+
| File          | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| mysql-bin.003 | 73       | test         | manual,mysql     |
+---------------+----------+--------------+------------------+