| 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 ;// |