content_image/730412.jpg
## • SIZE 

The size of the tablespace, in bytes. 

## • STATE 

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. 

## • PURPOSE 

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 

mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_SESSION_TEMP_TABLESPACES; 

<img src='content_image/730412.jpg'>

## Notes 

•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. 

## 26.4.25 The INFORMATION_SCHEMA INNODB_TABLES Table 

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: 

## • TABLE_ID 

An identifier for the InnoDB  table. This value is unique across all databases in the instance. 

## • NAME 

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. 

## • FLAG 

