SHOW Statements 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 . 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. SHOW MASTER LOGS  is equivalent to  SHOW BINARY LOGS . 2912 13.7.7.2 SHOW BINLOG EVENTS Statement 13.7.7.1 SHOW BINARY LOGS Statement SHOW BINLOG EVENTS [IN ’ log_name ’] [FROM  pos ] mysql>  SHOW BINARY LOGS; +---------------+-----------+-----------+ | Log_name | File_size | Encrypted | +---------------+-----------+-----------+ | binlog.000015 | 724935 | Yes | | binlog.000016 | 733481 | Yes | +---------------+-----------+-----------+