mysql分布式事务控制
sesson 1:
mysql> select * from t;
+------+--------------------------+----------------------------------+
| id | context | hash_value |
+------+--------------------------+----------------------------------+
| 888 | beijingbeijing | 09746eef633dbbccb7997dfd795cff17 |
| 888 | beijingbeijing | 09746eef633dbbccb7997dfd795cff17 |
| 888 | beijing 2008beijing 2008 | 1c0ddb82cca9ed63e1cacbddd3f74082 |
+------+--------------------------+----------------------------------+
3 rows in set (0.00 sec)
mysql> lock table t write;
Query OK, 0 rows affected (0.00 sec)
session2 :
等待
mysql> select * from t;
session 1:
mysql> insert into t (id) values (999);
Query OK, 1 row affected (0.03 sec)
mysql> rollback;
Query OK, 0 rows affected (0.00 sec)
mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)
session 2:
直到session1 执行start transaction;才被解锁
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29313086/viewspace-1736266/ ，如需转载，请注明出处，否则将追究法律责任。
