1set default_storage_engine='tokudb'; 2set tokudb_prelock_empty=false; 3drop table if exists t; 4create table t (id int primary key); 5set autocommit=0; 6select 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; 7locks_dname locks_key_left locks_key_right locks_table_schema locks_table_name locks_table_dictionary_name 8insert into t values (1); 9insert into t values (3); 10insert into t values (5); 11connect conn_a,localhost,root,,; 12set autocommit=0; 13insert into t values (2); 14insert into t values (4); 15insert into t values (6); 16connection default; 17select 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; 18locks_dname locks_key_left locks_key_right locks_table_schema locks_table_name locks_table_dictionary_name 19./test/t-main 0001000000 0001000000 test t main 20./test/t-main 0002000000 0002000000 test t main 21./test/t-main 0003000000 0003000000 test t main 22./test/t-main 0004000000 0004000000 test t main 23./test/t-main 0005000000 0005000000 test t main 24./test/t-main 0006000000 0006000000 test t main 25connection conn_a; 26commit; 27connection default; 28commit; 29select 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; 30locks_dname locks_key_left locks_key_right locks_table_schema locks_table_name locks_table_dictionary_name 31commit; 32disconnect conn_a; 33drop table t; 34