information_schema.innodb_sys_tablespaces.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
innodb_sys_tablespaces |
||||||||
allocated_size |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
file_format |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2
| unsupported | unsupported | unsupported | unsupported | ||
file_size |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
filename |
unsupported | VARCHAR NOT NULL:
10.6-10.7
| unsupported | unsupported | unsupported | unsupported | ||
flag |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
fs_block_size |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
name |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
page_size |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
row_format |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
space_type |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.4
| unsupported | unsupported | unsupported | unsupported | ||
zip_page_size |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.5
| unsupported | unsupported | unsupported | unsupported | ||