mysql 事务中有一个隔离级别serializable(序列化),在共享模式下对表进行了有效锁定。这会阻塞其他事务。
演示如下:
会话一
mysql> set @@session.tx_isolation = "serializable";
Query OK, 0 rows affected (0.00 sec)
mysql> select * from user;
+----+------+------+---------------------+---------------------+
| id | name | age | created_at | update_at |
+----+------+------+---------------------+---------------------+
| 1 | A | 1 | 2018-08-27 08:31:12 | 2018-08-27 08:37:24 |
+----+------+------+---------------------+---------------------+
1 row in set (0.00 sec)
mysql>
会话二