查看mysql锁情况的命令详解
1.检查InnoDB_row_lock状态变量来分析系统上的行锁的争夺情况mysql> show status like 'InnoDB_row_lock%';+-------------------------------+-------+| Variable_name | Value |+-------------------------------+-------+| InnoDB_row_lock_current_waits | 0
