mysql processlist 表_mysql show processlist 发现大量的commit

78 阅读 0 评论 52 点赞

我是靠谱客的博主贪玩小丸子，最近开发中收集的这篇文章主要介绍mysql processlist 表_mysql show processlist 发现大量的commit，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

今天执行show processlist 发现大量的commit；查看锁信息，发现基本上都是

+----------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

+----------------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+-----------------+------------------------------------------------------------------------------------------------------------

| 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) | 113159E3 | 501939 | 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)

| 11317266 | 501631 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',15) where `a`.`id` = NAME_CONST('in_user_id',6232465) and a.money >= NAME_CONST('pay_money',15) | 11316F66 | 501485 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',15) where `a`.`id` = NAME_CONST('in_user_id',6232465) and a.money >= NAME_CONST('pay_money',15)

| 1131720C | 501785 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',6) where `a`.`id` = NAME_CONST('in_user_id',5214183) and a.money >= NAME_CONST('pay_money',6) | 1131624D | 501699 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',6) where `a`.`id` = NAME_CONST('in_user_id',5214183) and a.money >= NAME_CONST('pay_money',6)

| 1131720C | 501785 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',6) where `a`.`id` = NAME_CONST('in_user_id',5214183) and a.money >= NAME_CONST('pay_money',6) | 113146D2 | 501710 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',6) where `a`.`id` = NAME_CONST('in_user_id',5214183) and a.money >= NAME_CONST('pay_money',6)

| 113171EA | 501711 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',9) where `a`.`id` = NAME_CONST('in_user_id',5889087) and a.money >= NAME_CONST('pay_money',9) | 11316383 | 501887 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',9) where `a`.`id` = NAME_CONST('in_user_id',5889087) and a.money >= NAME_CONST('pay_money',9)

| 113171EA | 501711 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',9) where `a`.`id` = NAME_CONST('in_user_id',5889087) and a.money >= NAME_CONST('pay_money',9) | 1131607B | 501045 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',9) where `a`.`id` = NAME_CONST('in_user_id',5889087) and a.money >= NAME_CONST('pay_money',9)

| 113171EA | 501711 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',9) where `a`.`id` = NAME_CONST('in_user_id',5889087) and a.money >= NAME_CONST('pay_money',9) | 11315087 | 500378 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',9) where `a`.`id` = NAME_CONST('in_user_id',5889087) and a.money >= NAME_CONST('pay_money',9) |

| 113171DA | 501941 | update `a` set `a`.`money` = `a`.`money` - NAME_CONST('pay_money',9) where `a`.`id` = NAME_CONST('in_user_id',6389794) and a.money >= NAME_CONST('pay_money',9) | 11316230 | 501547 | commit

好多都是和commit锁等待.

这不是由于DB commit比较频繁造成的？批量提交可以解决这个问题吗？