Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

13.7.5.1 SHOW BINARY LOGS Statement

SHOW BINARY LOGSSHOW MASTER LOGS

Lists the binary log files on the server. This statement is used as part of the procedure described inSection 13.4.1.1, “PURGE BINARY LOGS Statement”, that shows how to determine which logs can be purged. A user with theSUPER orREPLICATION 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 toSHOW BINARY LOGS.