MySQL 8.0 参考手册 / 第 4 章 MySQL 程序 / 4.5 客户端程序 / 4.5.7 mysqlshow——显示数据库、表和列信息 /
13.7.5.1 SHOW BINARY LOGS Statement
SHOW BINARY LOGS
SHOW MASTER LOGS
Lists the binary log files on the server. This statement is used
as part of the procedure described in
Section 13.4.1.1, “PURGE BINARY LOGS Statement”, that shows how to determine
which logs can be purged. A user with the
SUPER
or
REPLICATION CLIENT
privilege may
execute this statement.
mysql> SHOW BINARY LOGS;
+---------------+-----------+
| Log_name | File_size |
+---------------+-----------+
| binlog.000015 | 724935 |
| binlog.000016 | 733481 |
+---------------+-----------+
SHOW MASTER
LOGS
is equivalent to SHOW BINARY
LOGS
.