15.7.7.2 SHOW BINARY LOGS Statement (original) (raw)

The world's most popular open source database

15.7.7.2 SHOW BINARY LOGS Statement

SHOW BINARY LOGS

Lists the binary log files on the server. This statement is used as part of the procedure described inSection 15.4.1.1, “PURGE BINARY LOGS Statement”, that shows how to determine which logs can be purged. SHOW BINARY LOGS requires the REPLICATION CLIENT privilege (or the deprecatedSUPER 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 bySHOW BINARY LOGS. TheEncrypted column shows whether or not the binary log file is encrypted. Binary log encryption is active ifbinlog_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 |
+---------------+-----------+-----------+