• Index_type 

The index method used ( BTREE , FULLTEXT , HASH , RTREE ). 

• Comment 

Information about the index not described in its own column, such as disabled  if the index is disabled. 

• Index_comment 

Any comment provided for the index with a COMMENT  attribute when the index was created. 

• Visible 

Whether the index is visible to the optimizer. See Section 8.3.12, “Invisible Indexes” . 

• Expression 

MySQL 8.0.13 and higher supports functional key parts (see Functional Key Parts), which affects both the Column_name  and Expression  columns: 

•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. 

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. 

## 13.7.7.23 SHOW MASTER STATUS Statement 

SHOW MASTER STATUS 

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). 

## Example: 

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) 

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.24 SHOW OPEN TABLES Statement 

