查看mysq当前l锁状态
mysql> show status like “table_lock%”;
±----------------------±------+
| Variable_name | Value |
±----------------------±------+
| Table_locks_immediate | 101 |
| Table_locks_waited | 0 |
±----------------------±------+
可用通过Table_locks_immediate和Table_locks_waited 状态变量来分析系统上的表锁定争夺
如果Table_locks_waited过高.则说明存在着较严重的表级锁争用情况.
查看mysq当前l表锁状态
最新推荐文章于 2024-03-10 17:54:11 发布