19.30.9. The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table
The INNODB_SYS_FIELDS table provides status
information about the key columns (fields) of
InnoDB indexes, equivalent to the information
from the SYS_FIELDS table in the
InnoDB data dictionary.
Table 19.9. INNODB_SYS_FIELDS Columns
Column name
Description
INDEX_ID
An identifier for the index associated with this key field, using the
same value as in
INNODB_SYS_INDEXES.INDEX_ID.
NAME
The name of the original column from the table, using the same value as
in INNODB_SYS_COLUMNS.NAME.
POS
The ordinal position of the key field within the index, starting from 0
and incrementing sequentially. When a column is dropped,
the remaining columns are reordered so that the sequence
has no gaps.
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.
© 2012, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.