Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.9Mb
PDF (A4) - 38.0Mb
PDF (RPM) - 36.5Mb
HTML Download (TGZ) - 9.9Mb
HTML Download (Zip) - 9.9Mb
HTML Download (RPM) - 8.7Mb
Man Pages (TGZ) - 210.0Kb
Man Pages (Zip) - 319.1Kb
Info (Gzip) - 3.5Mb
Info (Zip) - 3.5Mb
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.


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.