SET DEFAULT_STORAGE_ENGINE='tokudb'; drop table if exists t; create table t (a int primary key, b int); insert into t values (1,0); set session transaction isolation level serializable; begin; select * from t where a=1 for update; a b 1 0 update t set b=b+1 where a=1; connect conn1,localhost,root; set session transaction isolation level serializable; begin; select * from t where a=1 for update; connection default; commit; connection conn1; a b 1 1 update t set b=b+1 where a=1; select * from t; a b 1 2 commit; connection default; disconnect conn1; drop table t;