Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 39.3Mb
PDF (A4) - 39.3Mb
PDF (RPM) - 38.4Mb
HTML Download (TGZ) - 10.9Mb
HTML Download (Zip) - 11.0Mb
HTML Download (RPM) - 9.6Mb
Man Pages (TGZ) - 217.9Kb
Man Pages (Zip) - 327.6Kb
Info (Gzip) - 3.6Mb
Info (Zip) - 3.6Mb
Excerpts from this Manual

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

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

Notes

  • 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_SYS_TABLESPACES and INNODB_SYS_DATAFILES tables. The FILES table also provides metadata for InnoDB tablespaces.