1
include/master-slave.inc
3
drop table if exists t;
4
create table t (a bigint not null, b bigint not null, c bigint not null, primary key(a), unique key(c)) engine=tokudb;
5
insert into t values (1,0,-1);
6
insert into t values (2,0,-2),(3,0,-3);
7
insert into t values (4,0,-4);
8
include/diff_tables.inc [master:test.t, slave:test.t]
9
update t set b=b+1 where a=2;
10
update t set b=b+2 where a=1;
11
update t set b=b+3 where a=4;
12
update t set b=b+4 where a=3;
13
update t set b=b+1 where 1<=a and a<=3;
14
select unix_timestamp() into @tstart;
15
select unix_timestamp() into @tend;
16
select @tend-@tstart <= 5;
25
include/diff_tables.inc [master:test.t, slave:test.t]
26
drop table if exists t;