Skip to content

Latest commit

 

History

History
36 lines (26 loc) · 1.29 KB

sql-statement-show-master-status.md

File metadata and controls

36 lines (26 loc) · 1.29 KB
title summary
SHOW MASTER STATUS
An overview of the usage of SHOW MASTER STATUS for the TiDB database.

SHOW MASTER STATUS

The SHOW MASTER STATUS statement displays the latest TSO in the cluster.

Examples

{{< copyable "sql" >}}

SHOW MASTER STATUS;
+-------------+--------------------+--------------+------------------+-------------------+
| File        | Position           | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+-------------+--------------------+--------------+------------------+-------------------+
| tidb-binlog | 416916363252072450 |              |                  |                   |
+-------------+--------------------+--------------+------------------+-------------------+
1 row in set (0.00 sec)

MySQL compatibility

The output of SHOW MASTER STATUS is designed to match MySQL. However, the execution results are different in that the MySQL result is the binlog location information and the TiDB result is the latest TSO information.

See also