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.
|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.|
This table is primarily useful for expert level monitoring.
INFORMATION_SCHEMA is a
general-purpose way to monitor the MySQL server, use this
table rather than the corresponding
system table for any new monitoring application you develop.
You must have the
PROCESS privilege to
query this table.