Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
The INNODB_SYS_TABLES table provides status information about InnoDB tables, equivalent to the information from the SYS_TABLES
table in the InnoDB data dictionary.
Table 20.7. INNODB_SYS_TABLES Columns
| Column name | Description |
|---|---|
TABLE_ID |
An identifier for each InnoDB table that is unique across all
databases in the instance.
|
NAME |
The name of the table. Preceded by the database name where appropriate, for example test/t1. InnoDB system table names are
in all uppercase. Names of databases and user tables are in the same case as they were
originally defined, possibly influenced by the lower_case_table_names setting.
|
FLAG |
0 = InnoDB system table, 1 = user table. |
N_COLS |
The number of columns in the table. |
SPACE |
An identifier for the tablespace where the table 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. Other than the zero value, this identifier is unique fortables
across all the databases in the instance.
|
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.