Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
The INNODB_SYS_TABLESPACES table stores information about InnoDB tablespaces,
allowing it to be queried through INFORMATION_SCHEMA.
Table 20.15. INNODB_SYS_TABLESPACES Columns
| Column name | Description |
|---|---|
SPACE |
Tablespace Space ID. |
NAME |
The database and table name (for example, world_innodb\city) |
FLAG |
The table was created with the CREATE
TABLE ... DATA DIRECTORY (0 = false, 1 = true)
|
FILE_FORMAT |
The tablespace file format (for example, Antelope or Barracuda).
The data in this field is interpreted from the tablespace flags information that resides in the
.ibd file. For more
information about InnoDBfile formats, see Section
5.4.7, "InnoDB File-Format Management".
|
ROW_FORMAT |
The tablespace row format (for example, Compact or Redundant). The data in this field is interpreted from the tablespace flags information that resides in the .ibd file. |
PAGE_SIZE |
The tablespace page size. The data in this field is interpreted from the tablespace flags information that resides in the .ibd file. |
ZIP_PAGE_SIZE |
The tablespace zip page size. The data in this field is interpreted from the tablespace flags information that resides in the .ibdfile. |
Notes:
You must have the PROCESS privilege to query this
table.
Because tablespace flags are always zero for all Antelope file formats (unlike
table flags), there is no way to determine from this flag integer if the tablespace row format is
Redundant or Compact. As a result, the possible values for the ROW_FORMAT
field are "Compact or Redundant", "Compressed", or "Dynamic."