今天执行show processlist 发现大量的commit;查看锁信息,发现基本上都是
+----------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| waiting_trx_id | waiting_thread | waiting_query | blocking_trx_id | blocking_thread | blocking_query
+----------------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+-----------------+------------------------------------------------------------------------------------------------------------
| 1131726E | 501885 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',6) where `a`.`id` = NAME_CONST('in_user_id',6106041) and a.money >= NAME_CONST('pay_money',6) | 11