set default_storage_engine='tokudb'; set tokudb_prelock_empty=false; drop table if exists t; create table t (id int primary key); set autocommit=0; select locks_dname,locks_key_left,locks_key_right,locks_table_schema,locks_table_name,locks_table_dictionary_name from information_schema.tokudb_locks where locks_table_schema='test' and locks_table_name='t' and locks_table_dictionary_name='main' order by locks_key_left, locks_key_right; locks_dname locks_key_left locks_key_right locks_table_schema locks_table_name locks_table_dictionary_name insert into t values (1); insert into t values (3); insert into t values (5); connect conn_a,localhost,root,,; set autocommit=0; insert into t values (2); insert into t values (4); insert into t values (6); connection default; select locks_dname,locks_key_left,locks_key_right,locks_table_schema,locks_table_name,locks_table_dictionary_name from information_schema.tokudb_locks where locks_table_schema='test' and locks_table_name='t' and locks_table_dictionary_name='main' order by locks_key_left, locks_key_right; locks_dname locks_key_left locks_key_right locks_table_schema locks_table_name locks_table_dictionary_name ./test/t-main 0001000000 0001000000 test t main ./test/t-main 0002000000 0002000000 test t main ./test/t-main 0003000000 0003000000 test t main ./test/t-main 0004000000 0004000000 test t main ./test/t-main 0005000000 0005000000 test t main ./test/t-main 0006000000 0006000000 test t main connection conn_a; commit; connection default; commit; select locks_dname,locks_key_left,locks_key_right,locks_table_schema,locks_table_name,locks_table_dictionary_name from information_schema.tokudb_locks where locks_table_schema='test' and locks_table_name='t' and locks_table_dictionary_name='main' order by locks_key_left, locks_key_right; locks_dname locks_key_left locks_key_right locks_table_schema locks_table_name locks_table_dictionary_name commit; disconnect conn_a; drop table t;