# Additional INFORMATION_SCHEMA tables

This page lists the `INFORMATION_SCHEMA` tables added to standard *MySQL* by *Percona Server for MySQL* that don't exist elsewhere in the documentation.

## Temporary tables

!!! note

    **This feature implementation is considered tech preview quality.**

Only the temporary tables that were explicitly created with CREATE TEMPORARY TABLE or ALTER TABLE are shown, and not the ones created to process complex queries.

These tables were added in Percona Server for MySQL 8.0.12-1.

### `INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES`

The GLOBAL_TEMPORARY_TABLES table has these columns:

* `SESSION_ID`  
  MySQL connection id.

* `TABLE_SCHEMA`  
  Schema in which the temporary table is created.

* `TABLE_NAME`  
  Name of the temporary table.

* `ENGINE`  
  Engine of the temporary table.

* `NAME`  
  Internal name of the temporary table.

* `TABLE_ROWS`  
  Number of rows of the temporary table.

* `AVG_ROW_LENGTH`  
  Average row length of the temporary table.

* `DATA_LENGTH`  
  Size of the data (Bytes).

* `INDEX_LENGTH`  
  Size of the indexes (Bytes).

* `CREATE_TIME`  
  Date and time of creation of the temporary table.

* `UPDATE_TIME`  
  Date and time of the latest update of the temporary table.

This table holds information on the temporary tables that exist for all connections. You don't need the `SUPER` privilege to query this table.

### `INFORMATION_SCHEMA.TEMPORARY_TABLES`

The TEMPORARY_TABLES table has these columns:

* `SESSION_ID`  
  MySQL connection id.

* `TABLE_SCHEMA`  
  Schema in which the temporary table is created.

* `TABLE_NAME`  
  Name of the temporary table.

* `ENGINE`  
  Engine of the temporary table.

* `NAME`  
  Internal name of the temporary table.

* `TABLE_ROWS`  
  Number of rows of the temporary table.

* `AVG_ROW_LENGTH`  
  Average row length of the temporary table.

* `DATA_LENGTH`  
  Size of the data (Bytes).

* `INDEX_LENGTH`  
  Size of the indexes (Bytes).

* `CREATE_TIME`  
  Date and time of creation of the temporary table.

* `UPDATE_TIME`  
  Date and time of the latest update of the temporary table.

This table holds information on the temporary tables existing for the running connection.