View the current status of the primary server's binary log. This statement returns the current log file name and position for replication synchronization.
SHOW [MASTER | BINLOG] STATUSSHOW MASTER STATUSProvides status information about the files of the primary.
This statement requires the privilege.
This statement requires the privilege and the privilege.
To see information about the current in the binary log, use the variable.
This page is licensed: GPLv2, originally from
SHOW BINLOG STATUS;
+--------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+--------------------+----------+--------------+------------------+
| mariadb-bin.000016 | 475 | | |
+--------------------+----------+--------------+------------------+
SELECT @@global.gtid_binlog_pos;
+--------------------------+
| @@global.gtid_binlog_pos |
+--------------------------+
| 0-1-2 |
+--------------------------+