top of page
CerebroSQL

SHOW MASTER LOGS

База данных: MySQL

68747470733a2f2f7374796c65732e7265646469746d656469612e636f6d2f74355f32716d366b2f7374796c65

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