MySQL :: MySQL 8.0 Reference Manual :: 25.31 The INFORMATION

version 8.0

5.7
5.6
5.5

5.6 Japanese

MySQL 8.0 Reference Manual / INFORMATION_SCHEMA Tables / The INFORMATION_SCHEMA TABLESPACES Table

25.31 The INFORMATION_SCHEMA TABLESPACES Table

The TABLESPACES table provides information about active MySQL Cluster tablespaces.

The TABLESPACES table has these columns:

TABLESPACE_NAME
The name of the tablespace.
ENGINE
The name of the storage engine that uses the tablespace.
TABLESPACE_TYPE
The tablespace type.
LOGFILE_GROUP_NAME
The name of the logfile group assigned to the tablespace.
EXTENT_SIZE
The size in bytes of the extents used by files that belong to the tablespace.
AUTOEXTEND_SIZE
Unused.
MAXIMUM_SIZE
Unused.
NODEGROUP_ID
Unused.
TABLESPACE_COMMENT
Unused.

The TABLESPACES table is a nonstandard INFORMATION_SCHEMA table.
The TABLESPACES table does not provide information about InnoDB tablespaces. For InnoDB tablespace metadata, see the INFORMATION_SCHEMA INNODB_TABLESPACES and INNODB_DATAFILES tables. The FILES table also provides metadata for InnoDB tablespaces.

PREV HOME UP NEXT