The INFORMATION_SCHEMA INNODB_TABLES Table The size of the tablespace, in bytes. The state of the tablespace.  ACTIVE  indicates that the tablespace is currently used by a session. INACTIVE  indicates that the tablespace is in the pool of available session temporary tablespaces. The purpose of the tablespace.  INTRINSIC  indicates that the tablespace is used for optimized internal temporary tables use by the optimizer.  SLAVE  indicates that the tablespace is allocated for storing user- created temporary tables on a replication slave.  USER  indicates that the tablespace is used for user- created temporary tables.  NONE  indicates that the tablespace is not in use. Example Notes 26.4.25 The INFORMATION_SCHEMA INNODB_TABLES Table mysql>  SELECT * FROM INFORMATION_SCHEMA.INNODB_SESSION_TEMP_TABLESPACES; +----+------------+----------------------------+-------+----------+-----------+ | ID | SPACE | PATH | SIZE | STATE | PURPOSE | +----+------------+----------------------------+-------+----------+-----------+ | 8 | 4294566162 | ./#innodb_temp/temp_10.ibt | 81920 | ACTIVE | INTRINSIC | | 8 | 4294566161 | ./#innodb_temp/temp_9.ibt | 98304 | ACTIVE | USER | | 0 | 4294566153 | ./#innodb_temp/temp_1.ibt | 81920 | INACTIVE | NONE | | 0 | 4294566154 | ./#innodb_temp/temp_2.ibt | 81920 | INACTIVE | NONE | | 0 | 4294566155 | ./#innodb_temp/temp_3.ibt | 81920 | INACTIVE | NONE | | 0 | 4294566156 | ./#innodb_temp/temp_4.ibt | 81920 | INACTIVE | NONE | | 0 | 4294566157 | ./#innodb_temp/temp_5.ibt | 81920 | INACTIVE | NONE | | 0 | 4294566158 | ./#innodb_temp/temp_6.ibt | 81920 | INACTIVE | NONE | | 0 | 4294566159 | ./#innodb_temp/temp_7.ibt | 81920 | INACTIVE | NONE | | 0 | 4294566160 | ./#innodb_temp/temp_8.ibt | 81920 | INACTIVE | NONE | +----+------------+----------------------------+-------+----------+-----------+ •You must have the  PROCESS  privilege to query this table. •Use the  INFORMATION_SCHEMA COLUMNS  table or the  SHOW COLUMNS  statement to view additional information about the columns of this table, including data types and default values. The  INNODB_TABLES  table provides metadata about  InnoDB  tables. For related usage information and examples, see Section 15.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables” . The  INNODB_TABLES  table has these columns: An identifier for the  InnoDB  table. This value is unique across all databases in the instance. The name of the table, preceded by the schema (database) name where appropriate (for example, test/t1 ). 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. 4874 • STATE • SIZE • PURPOSE • TABLE_ID • NAME • FLAG