1SET DEFAULT_STORAGE_ENGINE='tokudb'; 2drop table if exists t; 3create table t (a int primary key, b int); 4insert into t values (1,0); 5set session transaction isolation level repeatable read; 6begin; 7select * from t where a=1 for update; 8a b 91 0 10update t set b=b+1 where a=1; 11connect conn1,localhost,root; 12set session transaction isolation level repeatable read; 13begin; 14select * from t where a=1 for update; 15connection default; 16commit; 17connection conn1; 18a b 191 1 20update t set b=b+1 where a=1; 21select * from t; 22a b 231 2 24commit; 25connection default; 26disconnect conn1; 27drop table t; 28