conn1:
begin
start transaction; update account set username='5665656' where userid=1;
if sleep(10)=0 then
select 1;
end if;
commit;
endconn2:
BEGIN
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
select * from account where userid=1;
END
conn1还没有提交的时候,conn2就可以查询了。。也就是说产生了不可重复读的问题。谁可以解决的?
begin
start transaction; update account set username='5665656' where userid=1;
if sleep(10)=0 then
select 1;
end if;
commit;
endconn2:
BEGIN
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
select * from account where userid=1;
END
conn1还没有提交的时候,conn2就可以查询了。。也就是说产生了不可重复读的问题。谁可以解决的?
设计上的思路问题
begin
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
start transaction; update account set username='5665656' where userid=1;
if sleep(10)=0 then
select 1;
end if;
commit;
end conn2:
BEGIN
SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
select * from account where userid=1;
END