information_schema.innodb_sys_indexes.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
innodb_sys_indexes |
||||||||
index_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
merge_threshold |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
n_fields |
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_no |
INT NOT NULL:
5.7
| INT NOT 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 | ||
table_id |
BIGINT NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
type |
INT NOT NULL:
5.7
| INT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||