mysql5.7事务未提交导致锁等待如何解决

最新推荐文章于 2025-04-11 17:35:50 发布

qq_34701838

最新推荐文章于 2025-04-11 17:35:50 发布

阅读量1.2k

点赞数

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/qq_34701838/article/details/114630269

版权

1、实验环境

Myql版本5.7.17-log

实验表结构

(root@localhost)[apex]> show create table test;
+-------+-----------------------------------------------------------------------------------------------------------------------------------+
| Table| Create Table                                                                                                                     |
+-------+-----------------------------------------------------------------------------------------------------------------------------------+
|test  | CREATE TABLE `test` (
  `x` int(11) NOT NULL,
  `y` int(11) DEFAULT NULL,
  PRIMARY KEY (`x`)
)ENGINE=InnoDB DEFAULT CHARSET=gbk |
+-------+-----------------------------------------------------------------------------------------------------------------------------------+
1 row inset (0.01 sec)

插入数据

(root@localhost)[apex]> insert into test values(1,1);
(root@localhost)[apex]> insert into test values(2,2);
(root@localhost)[apex]> insert into test values(3,3);

2、锁产生步骤

会话一：开启事务，更新数据，不提交

(root@localhost)[apex]> begin;
QueryOK, 0 rows affected (0.00 sec)
(root@localhost)[apex]> update test set y=y+1 where x=1;
QueryOK, 1 row affected (0.00 sec)
Rowsmatched: 1  Changed: 1  Warnings: 0

查看当前连接id号（线程id号）