Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 5.4 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
MySQL 5.0 Reference Manual :: 12 SQL Statement Syntax :: 12.5 Database Administration Statements :: 12.5.5 SHOW Syntax :: 12.5.5.21 SHOW MASTER STATUS Syntax
Section Navigation [Toggle]
- 12.5.5 SHOW Syntax
- 12.5.5.1 SHOW BINARY LOGS Syntax
- 12.5.5.2 SHOW BINLOG EVENTS Syntax
- 12.5.5.3 SHOW CHARACTER SET Syntax
- 12.5.5.4 SHOW COLLATION Syntax
- 12.5.5.5 SHOW COLUMNS Syntax
- 12.5.5.6 SHOW CREATE DATABASE Syntax
- 12.5.5.7 SHOW CREATE FUNCTION Syntax
- 12.5.5.8 SHOW CREATE PROCEDURE Syntax
- 12.5.5.9 SHOW CREATE TABLE Syntax
- 12.5.5.10 SHOW CREATE VIEW Syntax
- 12.5.5.11 SHOW DATABASES Syntax
- 12.5.5.12 SHOW ENGINE Syntax
- 12.5.5.13 SHOW ENGINES Syntax
- 12.5.5.14 SHOW ERRORS Syntax
- 12.5.5.15 SHOW FUNCTION CODE Syntax
- 12.5.5.16 SHOW FUNCTION STATUS Syntax
- 12.5.5.17 SHOW GRANTS Syntax
- 12.5.5.18 SHOW INDEX Syntax
- 12.5.5.19 SHOW INNODB STATUS Syntax
- 12.5.5.20 SHOW LOGS Syntax
- 12.5.5.21 SHOW MASTER STATUS Syntax
- 12.5.5.22 SHOW MUTEX STATUS Syntax
- 12.5.5.23 SHOW OPEN TABLES Syntax
- 12.5.5.24 SHOW PRIVILEGES Syntax
- 12.5.5.25 SHOW PROCEDURE CODE Syntax
- 12.5.5.26 SHOW PROCEDURE STATUS Syntax
- 12.5.5.27 SHOW PROCESSLIST Syntax
- 12.5.5.28 SHOW PROFILE Syntax
- 12.5.5.29 SHOW PROFILES Syntax
- 12.5.5.30 SHOW SLAVE HOSTS Syntax
- 12.5.5.31 SHOW SLAVE STATUS Syntax
- 12.5.5.32 SHOW STATUS Syntax
- 12.5.5.33 SHOW TABLE STATUS Syntax
- 12.5.5.34 SHOW TABLES Syntax
- 12.5.5.35 SHOW TRIGGERS Syntax
- 12.5.5.36 SHOW VARIABLES Syntax
- 12.5.5.37 SHOW WARNINGS Syntax
SHOW MASTER STATUS
This statement provides status information about the binary log
files of the master. It requires either the
SUPER or
REPLICATION CLIENT privilege.
Example:
mysql> SHOW MASTER STATUS;
+---------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+---------------+----------+--------------+------------------+
| mysql-bin.003 | 73 | test | manual,mysql |
+---------------+----------+--------------+------------------+
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
User Comments
"show slave status" on a master returns empty set, but "show master status" on a slave doesn't.
Seems odd to stash this node only under "SQL Statements for Controlling Master Servers." It means _something_ in the context of "SQL Statements for Controlling Slave Servers," but what?
Add your own comment.