MySQueaL Resources

resources for mysql admins and developers who are squealing for help

More Resources

Main Doc Pages
Comments
MySQL columns: everywhere I look are tables and columns; life is filled with databases of information to be ordered and grouped. (Ca'Grande, Milan, Italy)

SHOW MASTER STATUS Statement

This MySQL statement displays information on the status of the binary log file that is being used currently on the master MySQL server.

hits past month: 14 ;  last updated: may 4, 2009 - 2:34am ;  parent: MySQL Replication

Syntax

SHOW MASTER STATUS

Explanation

This MySQL statement displays information on the status of the binary log file that is being used currently on the master MySQL server running replication.

Examples

Below is an example of this MySQL statement and the results:

SHOW MASTER STATUS;

+----------------+----------+--------------+------------------+
| File           | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+----------------+----------+--------------+------------------+
| log-bin.000141 |     1123 |              |                  |
+----------------+----------+--------------+------------------+
Return to MySQL Replication page of our MySQL Documentation