top of page
CerebroSQL

MySQL: 

SHOW MASTER LOGS

Syntax:
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 [HELP PURGE BINARY LOGS], that shows
how to determine which logs can be purged. SHOW BINARY LOGS requires
the REPLICATION CLIENT privilege (or the deprecated SUPER privilege).

Encrypted binary log files have a 512-byte file header that stores
information required for encryption and decryption of the file. This is
included in the file size displayed by SHOW BINARY LOGS. The Encrypted
column shows whether or not the binary log file is encrypted. Binary
log encryption is active if binlog_encryption=ON is set for the server.
Existing binary log files are not encrypted or decrypted if binary log
encryption is activated or deactivated while the server is running.

mysql> SHOW BINARY LOGS;
+---------------+-----------+-----------+
| Log_name | File_size | Encrypted |
+---------------+-----------+-----------+
| binlog.000015 | 724935 | Yes |
| binlog.000016 | 733481 | Yes |
+---------------+-----------+-----------+

URL: https://dev.mysql.com/doc/refman/8.0/en/show-binary-logs.html

Example

bottom of page