blob: 9fce0695983ca833e64b92edde8e4d555c133abe (
plain)
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
|
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 * from information_schema.tokudb_locks;
locks_trx_id locks_mysql_thread_id locks_dname locks_key_left locks_key_right
insert into t values (1);
insert into t values (3);
insert into t values (5);
set autocommit=0;
insert into t values (2);
insert into t values (4);
insert into t values (6);
select * from information_schema.tokudb_locks order by locks_trx_id,locks_key_left;
locks_trx_id locks_mysql_thread_id locks_dname locks_key_left locks_key_right
TRX_ID MYSQL_ID ./test/t-main 0001000000 0001000000
TRX_ID MYSQL_ID ./test/t-main 0003000000 0003000000
TRX_ID MYSQL_ID ./test/t-main 0005000000 0005000000
TRX_ID MYSQL_ID ./test/t-main 0002000000 0002000000
TRX_ID MYSQL_ID ./test/t-main 0004000000 0004000000
TRX_ID MYSQL_ID ./test/t-main 0006000000 0006000000
commit;
commit;
select * from information_schema.tokudb_locks;
locks_trx_id locks_mysql_thread_id locks_dname locks_key_left locks_key_right
commit;
drop table t;
|