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 20.26 INNODB_TEMP_TABLE_INFO Columns
|The table ID of the active temporary table.|
|The name of the active temporary table.|
|The number of columns in the temporary table.|
|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.|
|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 temporary tablespace.|
|Whether this temporary table is compressed.|