Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 44.5Mb
PDF (A4) - 44.6Mb
PDF (RPM) - 40.3Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.5Mb
HTML Download (RPM) - 9.1Mb
Man Pages (TGZ) - 204.6Kb
Man Pages (Zip) - 311.6Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual

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

25.30 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_TABLESPACES and INNODB_DATAFILES tables. The FILES table also provides metadata for InnoDB tablespaces.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.