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 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
|
include/master-slave.inc
[connection master]
call mtr.add_suppression('Slave: Error dropping database');
include/stop_slave.inc
start slave;
stop slave sql_thread;
insert into test0.benchmark set state='slave is processing load';
start slave sql_thread;
use test0;
insert into benchmark set state='slave ends load';
use test;
select * from test1.benchmark into outfile 'benchmark.out';
select ts from test0.benchmark where state like 'master started load' into @m_0;
select ts from test0.benchmark where state like 'master ends load' into @m_1;
select ts from test0.benchmark where state like 'slave takes on load' into @s_m0;
select ts from test0.benchmark where state like 'slave is supposed to finish with load' into @s_m1;
select ts from test0.benchmark where state like 'slave ends load' into @s_1;
select ts from test0.benchmark where state like 'slave is processing load' into @s_0;
select time_to_sec(@m_1) - time_to_sec(@m_0) as 'delta.out';
include/diff_tables.inc [master:test15.ti_nk, slave:test15.ti_nk]
include/diff_tables.inc [master:test15.ti_wk, slave:test15.ti_wk]
include/diff_tables.inc [master:test14.ti_nk, slave:test14.ti_nk]
include/diff_tables.inc [master:test14.ti_wk, slave:test14.ti_wk]
include/diff_tables.inc [master:test13.ti_nk, slave:test13.ti_nk]
include/diff_tables.inc [master:test13.ti_wk, slave:test13.ti_wk]
include/diff_tables.inc [master:test12.ti_nk, slave:test12.ti_nk]
include/diff_tables.inc [master:test12.ti_wk, slave:test12.ti_wk]
include/diff_tables.inc [master:test11.ti_nk, slave:test11.ti_nk]
include/diff_tables.inc [master:test11.ti_wk, slave:test11.ti_wk]
include/diff_tables.inc [master:test10.ti_nk, slave:test10.ti_nk]
include/diff_tables.inc [master:test10.ti_wk, slave:test10.ti_wk]
include/diff_tables.inc [master:test9.ti_nk, slave:test9.ti_nk]
include/diff_tables.inc [master:test9.ti_wk, slave:test9.ti_wk]
include/diff_tables.inc [master:test8.ti_nk, slave:test8.ti_nk]
include/diff_tables.inc [master:test8.ti_wk, slave:test8.ti_wk]
include/diff_tables.inc [master:test7.ti_nk, slave:test7.ti_nk]
include/diff_tables.inc [master:test7.ti_wk, slave:test7.ti_wk]
include/diff_tables.inc [master:test6.ti_nk, slave:test6.ti_nk]
include/diff_tables.inc [master:test6.ti_wk, slave:test6.ti_wk]
include/diff_tables.inc [master:test5.ti_nk, slave:test5.ti_nk]
include/diff_tables.inc [master:test5.ti_wk, slave:test5.ti_wk]
include/diff_tables.inc [master:test4.ti_nk, slave:test4.ti_nk]
include/diff_tables.inc [master:test4.ti_wk, slave:test4.ti_wk]
include/diff_tables.inc [master:test3.ti_nk, slave:test3.ti_nk]
include/diff_tables.inc [master:test3.ti_wk, slave:test3.ti_wk]
include/diff_tables.inc [master:test2.ti_nk, slave:test2.ti_nk]
include/diff_tables.inc [master:test2.ti_wk, slave:test2.ti_wk]
include/diff_tables.inc [master:test1.ti_nk, slave:test1.ti_nk]
include/diff_tables.inc [master:test1.ti_wk, slave:test1.ti_wk]
include/diff_tables.inc [master:test0.ti_nk, slave:test0.ti_nk]
include/diff_tables.inc [master:test0.ti_wk, slave:test0.ti_wk]
include/rpl_end.inc
|