1 监控锁

1.1 Innodb row lock waits
The number of times operations on InnoDB
1.2Innodb row wait load
The total time spent in acquiring row locks
for InnoDB tables, in milliseconds..
1.3 Avg Row Lock Wait Time
1.4 Innodb row lock current waits
1.5 innodb_status_output_locks（默认不开，设置为on有助观察锁信息）

2 sql执行锁 申请

1 insert