TIFLASH_INDEXES

The TIFLASH_INDEXES table provides statistics about index building on TiFlash replicas.

USE INFORMATION_SCHEMA;
DESC TIFLASH_INDEXES;

The output is as follows:

+-------------------------+---------------+------+------+---------+-------+
| Field                   | Type          | Null | Key  | Default | Extra |
+-------------------------+---------------+------+------+---------+-------+
| TIDB_DATABASE           | varchar(64)   | YES  |      | NULL    |       |
| TIDB_TABLE              | varchar(64)   | YES  |      | NULL    |       |
| TABLE_ID                | bigint        | YES  |      | NULL    |       |
| COLUMN_NAME             | varchar(64)   | YES  |      | NULL    |       |
| INDEX_NAME              | varchar(64)   | YES  |      | NULL    |       |
| COLUMN_ID               | bigint        | YES  |      | NULL    |       |
| INDEX_ID                | bigint        | YES  |      | NULL    |       |
| INDEX_KIND              | varchar(64)   | YES  |      | NULL    |       |
| ROWS_STABLE_INDEXED     | bigint        | YES  |      | NULL    |       |
| ROWS_STABLE_NOT_INDEXED | bigint        | YES  |      | NULL    |       |
| ROWS_DELTA_INDEXED      | bigint        | YES  |      | NULL    |       |
| ROWS_DELTA_NOT_INDEXED  | bigint        | YES  |      | NULL    |       |
| ERROR_MESSAGE           | varchar(1024) | YES  |      | NULL    |       |
| TIFLASH_INSTANCE        | varchar(64)   | YES  |      | NULL    |       |
+-------------------------+---------------+------+------+---------+-------+

Fields in the TIFLASH_INDEXES table are described as follows:

• TIDB_DATABASE: the name of the database to which the table belongs.
• TIDB_TABLE: the name of the table.
• TABLE_ID: the internal ID of the table, which is unique within a TiDB cluster.
• COLUMN_NAME: the name of the column on which the index is built.
• INDEX_NAME: the name of the index.
• COLUMN_ID: the ID of the column on which the index is built.
• INDEX_ID: the ID of the index.
• INDEX_KIND: the type of index.
• ROWS_STABLE_INDEXED: the number of rows in the TiFlash replica for which the Stable layer has completed index building.
• ROWS_STABLE_NOT_INDEXED: the number of rows in the TiFlash replica for which the Stable layer has not completed index building.
• ROWS_DELTA_INDEXED: the number of rows in the TiFlash replica for which the Delta layer has completed index building.
• ROWS_DELTA_NOT_INDEXED: the number of rows in the TiFlash replica for which the Delta layer has not completed index building.
• ERROR_MESSAGE: details about any unrecoverable errors encountered during index building.
• TIFLASH_INSTANCE: the address of the TiFlash instance that performs the index building task.