SHOW Statements • Index_type • Comment • Index_comment • Visible • Expression •For a nonfunctional key part,  Column_name  indicates the column indexed by the key part and Expression  is  NULL . •For a functional key part,  Column_name  column is  NULL  and  Expression  indicates the expression for the key part. The index method used ( BTREE ,  FULLTEXT ,  HASH ,  RTREE ). Information about the index not described in its own column, such as  disabled  if the index is disabled. Any comment provided for the index with a  COMMENT  attribute when the index was created. Whether the index is visible to the optimizer. See Section 8.3.12, “Invisible Indexes” . MySQL 8.0.13 and higher supports functional key parts (see Functional Key Parts), which affects both the  Column_name  and  Expression  columns: Information about table indexes is also available from the  INFORMATION_SCHEMA STATISTICS  table. See Section 26.3.34, “The INFORMATION_SCHEMA STATISTICS Table” . The extended information about hidden indexes is available only using  SHOW EXTENDED INDEX ; it cannot be obtained from the STATISTICS  table. You can list a table’s indexes with the  mysqlshow -k  db_name tbl_name  command. This statement provides status information about the binary log files of the source server. It requires the REPLICATION CLIENT  privilege (or the deprecated  SUPER  privilege). When global transaction IDs are in use,  Executed_Gtid_Set  shows the set of GTIDs for transactions that have been executed on the source. This is the same as the value for the  gtid_executed  system variable on this server, as well as the value for  Executed_Gtid_Set  in the output of  SHOW REPLICA | SLAVE STATUS  on this server. 13.7.7.23 SHOW MASTER STATUS Statement 13.7.7.24 SHOW OPEN TABLES Statement 2937 mysql>  SHOW MASTER STATUS\G *************************** 1. row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test  Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) SHOW MASTER STATUS Example: