Debian Codegraph @

mysql-test/suite/innodb/include/prepare_show_locks.inc

raw
1 CREATE TABLE connections (
2 trx_mysql_thread_id BIGINT PRIMARY KEY,
3 name VARCHAR(200)
4 ) ENGINE=InnoDB;
5
6 DELIMITER //;
7 CREATE PROCEDURE show_locks ()
8 BEGIN
9 # this is needed because INFORMATION_SCHEMA.INNODB_TRX is refreshed with debounce 100ms
10 SELECT SLEEP(1);
11 SELECT
12 connections.name, object_name, index_name, lock_type, lock_mode, lock_status, lock_data
13 FROM connections
14 JOIN INFORMATION_SCHEMA.INNODB_TRX USING (trx_mysql_thread_id)
15 JOIN performance_schema.data_locks ON (trx_id=engine_transaction_id)
16 ORDER BY 1,2,3,4,5,6,7;
17 END //
18
19 CREATE PROCEDURE register_connection (name VARCHAR(200))
20 BEGIN
21 INSERT INTO connections VALUES (CONNECTION_ID(), name);
22 END //
23
24 DELIMITER ;//