show global status like '%wait%';
Table_locks_waited = 21313
mysql> show global status like '%wait%';
Innodb_row_lock_current_waits:当前等待锁的数量 Innodb_row_lock_time: 系统启动到现在、锁定的总时间长度 Innodb_row_lock_time_avg:每次平均锁定的时间 Innodb_row_lock_time_max:最长一次锁定时间 Innodb_row_lock_waits:系统启动到现在、总共锁定次数
|