blob: 4d819025bb2a676802860d1e794c77237dc215f7 (
plain)
1
2
3
4
5
6
7
8
|
SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
Table Create Table
INNODB_LOCK_WAITS CREATE TEMPORARY TABLE `INNODB_LOCK_WAITS` (
`requesting_trx_id` bigint(21) unsigned NOT NULL,
`requested_lock_id` varchar(81) NOT NULL,
`blocking_trx_id` bigint(21) unsigned NOT NULL,
`blocking_lock_id` varchar(81) NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci
|