1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
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;
|