information_schema.innodb_lock_waits.*| relation | column | mysql | mariadb | tidb | postgres | cockroachdb | mssql | |
|---|---|---|---|---|---|---|---|---|
innodb_lock_waits |
||||||||
blocking_lock_id |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
blocking_trx_id |
VARCHAR NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
requested_lock_id |
VARCHAR NOT NULL:
5.7
| VARCHAR NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||
requesting_trx_id |
VARCHAR NOT NULL:
5.7
| BIGINT NOT NULL:
10.2-10.7
| unsupported | unsupported | unsupported | unsupported | ||