Here's a simple method for regression testing:
create table t (i int primary key auto_increment, s int);
insert into t values (1,0); insert into t values (2,0);
insert into t(s) select s from t; -- repeat this as long until you get > 10K rows in t
select * from t into outfile '/tmp/t';
truncate t;
load data infile '/tmp/t' into table t; .. this should be split and replicated in two batches
begin; load data infile '/tmp/t' into table t; -- this should be not split, but replicated as one transactiion commit;
Here's a simple method for regression testing:
create table t (i int primary key auto_increment, s int);
insert into t values (1,0);
insert into t values (2,0);
insert into t(s) select s from t; -- repeat this as long until you get > 10K rows in t
select * from t into outfile '/tmp/t';
truncate t;
load data infile '/tmp/t' into table t; .. this should be split and replicated in two batches
truncate t;
begin;
load data infile '/tmp/t' into table t; -- this should be not split, but replicated as one transactiion
commit;