153 lines
4.9 KiB
Plaintext
153 lines
4.9 KiB
Plaintext
SET @start_global_value = @@global.xengine_parallel_read_threads;
|
|
SELECT @start_global_value;
|
|
@start_global_value
|
|
4
|
|
create table t1(id int, a char(20), b text, primary key(id), key k1(a(8)), unique key k2(b(8))) engine=xengine;
|
|
create table t2(id int, a char(20), b text, primary key(id), key k1(b(8)), unique key k2(a(8))) engine=xengine;
|
|
create table t3(id int, a char(20), b text, primary key(a(8)), key k1(id), unique key k2(b(8))) engine=xengine;
|
|
create table t4(id int, a char(20), b text, primary key(a(8)), key k1(b(8)), unique key k2(id)) engine=xengine;
|
|
create table t5(id int, a char(20), b text, primary key(b(8)), key k1(id), unique key k2(a(8))) engine=xengine;
|
|
create table t6(id int, a char(20), b text, primary key(b(8)), key k1(a(8)), unique key k2(id)) engine=xengine;
|
|
create table t7(id int, a char(20), b text, primary key(id, a(8)), key k1(b(8))) engine=xengine;
|
|
create table t8(id int, a char(20), b text, primary key(id), key k1(a(8), b(8))) engine=xengine;
|
|
create table t9(id int, a char(20), b text, primary key(id), unique key k2(a(8), b(8))) engine=xengine;
|
|
begin;
|
|
insert into t1 values(1, '1234567890', '0987654321');
|
|
insert into t1 values(2, '0987654321', '1234567890');
|
|
check table t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
set xengine_parallel_read_threads=2;
|
|
check table t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
set xengine_parallel_read_threads=8;
|
|
check table t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 check status OK
|
|
drop table t1;
|
|
insert into t2 values(1, '1234567890', '0987654321');
|
|
insert into t2 values(2, '0987654321', '1234567890');
|
|
check table t2;
|
|
Table Op Msg_type Msg_text
|
|
test.t2 check status OK
|
|
set xengine_parallel_read_threads=2;
|
|
check table t2;
|
|
Table Op Msg_type Msg_text
|
|
test.t2 check status OK
|
|
set xengine_parallel_read_threads=8;
|
|
check table t2;
|
|
Table Op Msg_type Msg_text
|
|
test.t2 check status OK
|
|
drop table t2;
|
|
insert into t3 values(1, '1234567890', '0987654321');
|
|
insert into t3 values(2, '0987654321', '1234567890');
|
|
check table t3;
|
|
Table Op Msg_type Msg_text
|
|
test.t3 check status OK
|
|
set xengine_parallel_read_threads=2;
|
|
check table t3;
|
|
Table Op Msg_type Msg_text
|
|
test.t3 check status OK
|
|
set xengine_parallel_read_threads=8;
|
|
check table t3;
|
|
Table Op Msg_type Msg_text
|
|
test.t3 check status OK
|
|
drop table t3;
|
|
insert into t4 values(1, '1234567890', '0987654321');
|
|
insert into t4 values(2, '0987654321', '1234567890');
|
|
check table t4;
|
|
Table Op Msg_type Msg_text
|
|
test.t4 check status OK
|
|
set xengine_parallel_read_threads=2;
|
|
check table t4;
|
|
Table Op Msg_type Msg_text
|
|
test.t4 check status OK
|
|
set xengine_parallel_read_threads=8;
|
|
check table t4;
|
|
Table Op Msg_type Msg_text
|
|
test.t4 check status OK
|
|
drop table t4;
|
|
insert into t5 values(1, '1234567890', '0987654321');
|
|
insert into t5 values(2, '0987654321', '1234567890');
|
|
check table t5;
|
|
Table Op Msg_type Msg_text
|
|
test.t5 check status OK
|
|
set xengine_parallel_read_threads=2;
|
|
check table t5;
|
|
Table Op Msg_type Msg_text
|
|
test.t5 check status OK
|
|
set xengine_parallel_read_threads=8;
|
|
check table t5;
|
|
Table Op Msg_type Msg_text
|
|
test.t5 check status OK
|
|
drop table t5;
|
|
insert into t6 values(1, '1234567890', '0987654321');
|
|
insert into t6 values(2, '0987654321', '1234567890');
|
|
check table t6;
|
|
Table Op Msg_type Msg_text
|
|
test.t6 check status OK
|
|
set xengine_parallel_read_threads=2;
|
|
check table t6;
|
|
Table Op Msg_type Msg_text
|
|
test.t6 check status OK
|
|
set xengine_parallel_read_threads=8;
|
|
check table t6;
|
|
Table Op Msg_type Msg_text
|
|
test.t6 check status OK
|
|
drop table t6;
|
|
insert into t7 values(1, '1234567890', '0987654321');
|
|
insert into t7 values(2, '0987654321', '1234567890');
|
|
check table t7;
|
|
Table Op Msg_type Msg_text
|
|
test.t7 check status OK
|
|
set xengine_parallel_read_threads=2;
|
|
check table t7;
|
|
Table Op Msg_type Msg_text
|
|
test.t7 check status OK
|
|
set xengine_parallel_read_threads=8;
|
|
check table t7;
|
|
Table Op Msg_type Msg_text
|
|
test.t7 check status OK
|
|
drop table t7;
|
|
insert into t8 values(1, '1234567890', '0987654321');
|
|
insert into t8 values(2, '0987654321', '1234567890');
|
|
check table t8;
|
|
Table Op Msg_type Msg_text
|
|
test.t8 check status OK
|
|
set xengine_parallel_read_threads=2;
|
|
check table t8;
|
|
Table Op Msg_type Msg_text
|
|
test.t8 check status OK
|
|
set xengine_parallel_read_threads=8;
|
|
check table t8;
|
|
Table Op Msg_type Msg_text
|
|
test.t8 check status OK
|
|
drop table t8;
|
|
insert into t9 values(1, '1234567890', '0987654321');
|
|
insert into t9 values(2, '0987654321', '1234567890');
|
|
check table t9;
|
|
Table Op Msg_type Msg_text
|
|
test.t9 check status OK
|
|
set xengine_parallel_read_threads=2;
|
|
check table t9;
|
|
Table Op Msg_type Msg_text
|
|
test.t9 check status OK
|
|
set xengine_parallel_read_threads=8;
|
|
check table t9;
|
|
Table Op Msg_type Msg_text
|
|
test.t9 check status OK
|
|
drop table t9;
|
|
commit;
|
|
create table t10 (a int, b int, key ka(a), key kb(b)) engine=xengine;
|
|
insert into t10 values(1, 5);
|
|
insert into t10 values(2, 6);
|
|
check table t10;
|
|
Table Op Msg_type Msg_text
|
|
test.t10 check status OK
|
|
drop table t10;
|
|
SET @@global.xengine_parallel_read_threads = @start_global_value;
|
|
SELECT @@global.xengine_parallel_read_threads;
|
|
@@global.xengine_parallel_read_threads
|
|
4
|