mysql rr 索引_Mysql RR隔离更新列没有索引 会锁全表

mysql> show variables like '%tx_isolation%';

+---------------+-----------------+

| Variable_name | Value |

+---------------+-----------------+

| tx_isolation | REPEATABLE-READ |

+---------------+-----------------+

1 row in set (0.00 sec)

Session 1:

mysql> show index from test;

Empty set (0.00 sec)

mysql> update test set name='xxxx' where id=2;

Query OK, 0 rows affected (0.00 sec)

Rows matched: 1 Changed: 0 Warnings: 0

Session 2:

mysql> select * from test;

+------+------+

| id | name |

+------+------+

| 1 | b |

| 11 | aa |

| 2 | xxxx |

| 10 | a |

+------+------+

4 rows in set (0.00 sec)

mysql>