mysql RR事务隔离机制

OB事务隔离机制:

mysql> select @@tx_isolation;
+----------------+
| @@tx_isolation |
+----------------+
| READ-COMMITTED |
+----------------+
1 row in set (0.00 sec)

测试库:

mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation  |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)

CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '登录名',
  PRIMARY KEY (`id`)
  
) ENGINE=InnoDB ;

mysql> select * from t_user;
+----+----------+
| id | username |
+----+----------+
|  1 | aaa      |
|  2 | bbb      |
|  3 | ccc      |<