MySQL查看锁的实现代码

# 会显示加锁的信息等等
show engine innodb status;  

show full processlist;

show open tables where in_use > 0;
show open tables;

show status like '%lock%';

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; -- 5.7
SELECT * FROM performance_schema.data_locks; -- 8.0

SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS; -- 5.7
SELECT * FROM performance_schema.data_lock_waits; -- 8.0

show status like 'InnoDB_row_lock%';

show status like 'table%';

CREATE TABLE innodb_lock_monitor (a INT) ENGINE=INNODB;

DROP TABLE innodb_lock_monitor;

set GLOBAL innodb_status_output=ON;
set GLOBAL innodb_status_output_locks=ON;

set GLOBAL innodb_status_output=OFF;
set GLOBAL innodb_status_output_locks=OFF;

show engine innodb status \G;

# 方式一
CREATE TABLE innodb_monitor (a INT) ENGINE=INNODB;
DROP TABLE innodb_monitor;
# 方式二
set GLOBAL innodb_status_output=ON;
set GLOBAL innodb_status_output=OFF;

# 方式一
CREATE TABLE innodb_lock_monitor (a INT) ENGINE=INNODB;
DROP TABLE innodb_lock_monitor;
# 方式二
set GLOBAL innodb_status_output=ON;
set GLOBAL innodb_status_output_locks=ON;
set GLOBAL innodb_status_output=OFF;
set GLOBAL innodb_status_output_locks=OFF;

CREATE TABLE innodb_tablespace_monitor (a INT) ENGINE=INNODB;
DROP TABLE innodb_tablespace_monitor;

CREATE TABLE innodb_tablespace_monitor (a INT) ENGINE=INNODB;
DROP TABLE innodb_tablespace_monitor;