1SET DEFAULT_STORAGE_ENGINE='tokudb'; 2set global tokudb_lock_timeout=0; 3select @@tokudb_lock_timeout; 4@@tokudb_lock_timeout 50 6drop table if exists t; 7create table t (a int primary key, b int); 8insert into t values (1,0),(2,0),(3,0),(4,0); 9commit; 10select @@autocommit; 11@@autocommit 121 13set autocommit=off; 14select @@autocommit; 15@@autocommit 161 17set autocommit=off; 18select * from t where a=1 for update; 19a b 201 0 21select * from t where a=1 for update; 22ERROR HY000: Lock wait timeout exceeded; try restarting transaction 23commit; 24commit; 25set global tokudb_lock_timeout=30000000; 26drop table t; 27