mysql锁的问题
我的mysql是:REPEATABLE-READ,开了2个session来做如下操作
我在a session中:
begin;
select id from order where id=1 for update;
然后在马上在b session中:
我想
begin;
update order set age=12 where id=1;
commit;
但这样会出现锁超时:Lock wait timeout exceeded; try restarting transaction
或死锁
我试过在b中执行
begin;
set session tx_isolation = 'READ-COMMITTED';或set session tx_isolation = 'READ-UNCOMMITTED';
update order set age=12 where id=1;
commit;
这样也是报同样的错误
各位大侠有招没?