INNODB_SYS_INDEXES table provides status
InnoDB indexes, equivalent to
the information from the
SYS_INDEXES table in
InnoDB data dictionary.
|An identifier for each index that is unique across all the databases in an instance.|
|The name of the index. User-created indexes have names in all lowercase.
Indexes created implicitly by |
|An identifier representing the table associated with the index; the same
value from |
|A numeric identifier signifying the kind of index. 0 = Secondary Index, 1 = Clustered Index, 2 = Unique Index, 3 = Primary Index, 32 = Full-text Index.|
|The number of columns in the index key. For the
|The root page number of the index B-tree. For full-text indexes, the
|An identifier for the tablespace where the index resides. 0 means the
INFORMATION_SCHEMA is a
general-purpose way to monitor the MySQL server, use this
table rather than the corresponding
system table for any new monitoring application you develop.
You must have the
PROCESS privilege to
query this table.