information_schema.innodb_locks.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
innodb_locks |
||||||||
lock_data |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_id |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_index |
VARCHAR NULL:
5.7
| VARCHAR NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_mode |
VARCHAR NOT NULL:
5.7
| ENUM NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_page |
BIGINT NULL:
5.7
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_rec |
BIGINT NULL:
5.7
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_space |
BIGINT NULL:
5.7
| BIGINT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_table |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_trx_id |
VARCHAR NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
lock_type |
VARCHAR NOT NULL:
5.7
| ENUM NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||