Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
The INNODB_TEMP_TABLE_INFO contains metadata about active temporary tables and is
created when the first select statement is run against it. The table reports on all user and system-created
temporary tables that are active within a given InnoDB instance. This table is not persisted to disk.
As of MySQL 5.7.1, InnoDB temporary table metadata is no longer stored to InnoDB system tables. Instead, the new
INNODB_TEMP_TABLE_INFO provides users with a snapshot of active temporary tables.
Table 19.25. INNODB_TEMP_TABLE_INFO Columns
| Column name | Description |
|---|---|
TABLE_ID |
The table ID of the active temporary table. |
NAME |
The name of the active temporary table. |
N_COLS |
The number of columns in the temporary table. |
SPACE |
The tablespace identifier where the temporary table resides. As of MySQL 5.7.1, all non-compressed InnoDB temporary tables reside in a shared temporary table tablespace. Compressed temporary tables reside in separate dedicated tablespaces. The temporary table tablespace space-id (also know as tablespace identifier) is always non-zero, and because it is dynamically generated, it can vary on server restart. |
PER_TABLE_SPACE |
Whether this table resides in the shared temporary tablespace or in a dedicated single tablespace. A value of true indicates a dedicated single tablespace. A value of false indicates that the temporary table resides in the shared temporarytablespace. |
IS_COMPRESSED |
Whether this temporary table is compressed. |
Notes:
This table is primarily useful for expert level monitoring.
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.