Information Schema INNODB_SYS_TABLESPACES Table
You are viewing an old version of this article. View
the current version here.
The Information Schema INNODB_SYS_TABLESPACES table contains information about InnoDB tablespaces.
The PROCESS privilege is required to view the table.
It has the following columns:
| Column | Description | Added |
|---|---|---|
| SPACE | Unique InnoDB tablespace identifier. | |
| NAME | Database and table name separated by a backslash, or the uppercase InnoDB system table name. | |
| FLAG | 1 if a DATA DIRECTORY option has been specified in CREATE TABLE, otherwise 0. | |
| FILE_FORMAT | InnoDB file format. | |
| ROW_FORMAT | InnoDB storage format used for this tablespace. If the Antelope file format is used, this value is always 'Compact or Redundant'. | |
| PAGE SIZE | Page size in bytes for this tablespace. | |
| ZIP_PAGE_SIZE | Zip page size for this tablespace. |
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
