read committed mysql_mysql read committed

read commit;

Oracle采用的也是 read committed

默认是:

mysql> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;

+———————–+—————–+

| @@GLOBAL.tx_isolation | @@tx_isolation |

+———————–+—————–+

| REPEATABLE-READ | REPEATABLE-READ |

+———————–+—————–+

1 row in set (0.00 sec)

set session transaction isolation level read committed;

mysql> SELECT @@GLOBAL.tx_isolation, @@tx_isolation;

+———————–+—————-+

| @@GLOBAL.tx_isolation | @@tx_isolation |

+———————–+—————-+

| REPEATABLE-READ | READ-COMMITTED |

+———————–+—————-+

1 row in set (0.00 sec)

SESSION A:

set autocommit=0;

set session transaction isolation level read committed;

SESSION B:

set autocommit=0;

set session transaction isolation level read committed;

SESSION B:

mysql> insert into t1 values(200);

Query OK, 1 row affected (0.00 sec)

mysql> select * from t1;

+——+

| id |

+——+

| 100 |

| 200 |

+——+

2 rows in set (0.00 sec)

mysql> commit;

Query OK, 0 rows affected (0.00 sec)

SESSION A:

mysql> select * from t1;

+——+

| id |

+——+

| 100 |

| 200 |

+——+

2 rows in set (0.00 sec

只要B提交,A就能看到