SHOW PROFILES SHOW RELAYLOG EVENTS [IN ’ log_name ’] [FROM pos ] [LIMIT [ offset ,] row_count ] SHOW {REPLICAS | SLAVE HOSTS} SHOW {REPLICA | SLAVE} STATUS [FOR CHANNEL channel ] SHOW [GLOBAL | SESSION] STATUS [ like_or_where ] SHOW TABLE STATUS [FROM db_name ] [ like_or_where ] SHOW [FULL] TABLES [FROM db_name ] [ like_or_where ] SHOW TRIGGERS [FROM db_name ] [ like_or_where ] SHOW [GLOBAL | SESSION] VARIABLES [ like_or_where ] SHOW WARNINGS [LIMIT [ offset ,] row_count ] like_or_where : { LIKE ’ pattern ’ | WHERE expr } 

If the syntax for a given SHOW  statement includes a LIKE ’ pattern ’  part, ’ pattern ’  is a string that can contain the SQL %  and _  wildcard characters. The pattern is useful for restricting statement output to matching values. 

Several SHOW  statements also accept a WHERE  clause that provides more flexibility in specifying which rows to display. See Section 26.8, “Extensions to SHOW Statements” . 

Many MySQL APIs (such as PHP) enable you to treat the result returned from a SHOW  statement as you would a result set from a SELECT ; see Chapter 29, Connectors and APIs , or your API documentation for more information. In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA  database, which you cannot easily do with results from SHOW  statements. See Chapter 26, INFORMATION_SCHEMA Tables . 

## 13.7.7.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. 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. 

## 13.7.7.2 SHOW BINLOG EVENTS Statement 

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

SHOW MASTER LOGS  is equivalent to SHOW BINARY LOGS . 

SHOW BINLOG EVENTS [IN ’ log_name ’] [FROM pos ] 

