MySQL 5.6 Reference Manual :: 19 INFORMATION_SCHEMA Tables :: 19.30 INFORMATION_SCHEMA Tables for
InnoDB :: 19.30.6 The INFORMATION_SCHEMA INNODB_SYS_TABLES Table
Section Navigation [Toggle]
- 19.30 INFORMATION_SCHEMA Tables for InnoDB
- 19.30.1 The INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET Tables
- 19.30.2 The INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET Tables
- 19.30.3 The INFORMATION_SCHEMA INNODB_TRX Table
- 19.30.4 The INFORMATION_SCHEMA INNODB_LOCKS Table
- 19.30.5 The INFORMATION_SCHEMA INNODB_LOCK_WAITS Table
- 19.30.6 The INFORMATION_SCHEMA INNODB_SYS_TABLES Table
- 19.30.7 The INFORMATION_SCHEMA INNODB_SYS_INDEXES Table
- 19.30.8 The INFORMATION_SCHEMA INNODB_SYS_COLUMNS Table
- 19.30.9 The INFORMATION_SCHEMA INNODB_SYS_FIELDS Table
- 19.30.10 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN Table
- 19.30.11 The INFORMATION_SCHEMA INNODB_SYS_FOREIGN_COLS Table
- 19.30.12 The INFORMATION_SCHEMA INNODB_SYS_TABLESTATS View
- 19.30.13 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE Table
- 19.30.14 The INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU Table
- 19.30.15 The INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS Table
- 19.30.16 The INFORMATION_SCHEMA INNODB_METRICS Table
- 19.30.17 The INFORMATION_SCHEMA INNODB_FT_CONFIG Table
- 19.30.18 The INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD Table
- 19.30.19 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE Table
- 19.30.20 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE Table
- 19.30.21 The INFORMATION_SCHEMA INNODB_FT_INSERTED Table
- 19.30.22 The INFORMATION_SCHEMA INNODB_FT_DELETED Table
- 19.30.23 The INFORMATION_SCHEMA INNODB_FT_BEING_DELETED Table
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 19.6. 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 for
tables across all the databases in the instance. |
Notes:
Since the
INFORMATION_SCHEMAis a general-purpose way to monitor the MySQL server, use this table rather than the correspondingInnoDBsystem table for any new monitoring application you develop.You must have the
PROCESSprivilege to query this table.
Copyright © 1997, 2012, Oracle and/or its affiliates. All
rights reserved.
Legal Notices
User Comments
Add your own comment.