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;
mysql锁
最新推荐文章于 2024-06-23 18:17:34 发布