The INNODB_SYS_INDEXES table provides status
information about InnoDB indexes, equivalent to
the information from the SYS_INDEXES table in
the InnoDB data dictionary.
Table 20.8. INNODB_SYS_INDEXES Columns
| Column name | Description |
|---|---|
INDEX_ID | An identifier for each index that is unique across all the databases in an instance. |
NAME | The name of the index. User-created indexes have names in all lowercase.
Indexes created implicitly by InnoDB
have names in all lowercase. The index names are not
necessarily unique. Indexes created implicitly by
InnoDB have consistent names:
PRIMARY for a primary key index,
GEN_CLUST_INDEX for the index
representing a primary key when one is not specified,
ID_IND, FOR_IND for
validating a foreign key constraint, and
REF_IND.
|
TABLE_ID | An identifier representing the table associated with the index; the same
value from INNODB_SYS_TABLES.TABLE_ID. |
TYPE | A numeric identifier signifying the kind of index, in the range 0..3. |
N_FIELDS | The number of columns in the index key. For the
GEN_CLUST_INDEX indexes, this value is
0 because the index is created using an artificial value
rather than a real table column. |
PAGE_NO | |
SPACE | An identifier for the tablespace where the index resides. 0 means the
InnoDB
system
tablespace. Any other number represents a table
created in
file-per-table
mode with a separate .ibd file. This
identifier stays the same after a
TRUNCATE TABLE statement.
Because all indexes for a table reside in the same
tablespace as the table, this value is not necessarily
unique. |
Notes:
Since the INFORMATION_SCHEMA is a
general-purpose way to monitor the MySQL server, use this
table rather than the corresponding InnoDB
system table for any new monitoring application you develop.
You must have the PROCESS privilege to
query this table.