This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Information Schema for MariaDB Enterprise Server
Topics on this page:
InnoDB which lock is blocking which
See also: Information Schema for MariaDB Enterprise Server 10.6, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS
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 )
Additional information on this topic may be found in the MariaDB Public Knowledge Base.