mysql锁

show status like ‘table%’;
Table_locks_immediate 能够立即获得表级锁的次数
Table_locks_waited 不能立即获取表级锁而需要等待的次数，值比较高说明存在着较严重的表级锁争用情况
show status like ‘innodb_row_lock%’
InnoDB_row_lock_waits和InnoDB_row_lock_time_avg的值比较高说明锁争用比较严重
show OPEN TABLES where In_use > 0;
show processlist;
kill 123;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;