show status like 'innodb_row_lock%';
注释
Innodb_row_lock_current_waits : 正在等待锁的sql
Innodb_row_lock_time : 锁的总时长
Innodb_row_lock_time_avg : 平均每条sql锁的时间
Innodb_row_lock_time_max : 最大锁的时间
Innodb_row_lock_waits : 锁的次数
查看正在运行的sql
select i.trx_state,i.trx_mysql_thread_id,i.trx_query FROM information_schema.INNODB_TRX i;