1include/master-slave.inc 2Warnings: 3Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. 4Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 5[connection master] 6[connection slave] 7[connection master] 8call mtr.add_suppression('Slave: Error dropping database'); 9include/stop_slave.inc 10start slave; 11include/sync_slave_sql_with_master.inc 12stop slave sql_thread; 13insert into test0.benchmark set state='slave is processing load'; 14start slave sql_thread; 15use test; 16select * from test0.benchmark into outfile 'benchmark.out'; 17select ts from test0.benchmark where state like 'master started load' into @m_0; 18select ts from test0.benchmark where state like 'master ends load' into @m_1; 19select ts from test0.benchmark where state like 'slave takes on load' into @s_0; 20select ts from test0.benchmark where state like 'slave ends load' into @s_1; 21select time_to_sec(@m_1) - time_to_sec(@m_0) as 'delta.out'; 22include/sync_slave_sql_with_master.inc 23include/diff_tables.inc [master:test15.tm_nk, slave:test15.tm_nk] 24include/diff_tables.inc [master:test15.ti_nk, slave:test15.ti_nk] 25include/diff_tables.inc [master:test15.tm_wk, slave:test15.tm_wk] 26include/diff_tables.inc [master:test15.ti_wk, slave:test15.ti_wk] 27include/sync_slave_sql_with_master.inc 28include/diff_tables.inc [master:test14.tm_nk, slave:test14.tm_nk] 29include/diff_tables.inc [master:test14.ti_nk, slave:test14.ti_nk] 30include/diff_tables.inc [master:test14.tm_wk, slave:test14.tm_wk] 31include/diff_tables.inc [master:test14.ti_wk, slave:test14.ti_wk] 32include/sync_slave_sql_with_master.inc 33include/diff_tables.inc [master:test13.tm_nk, slave:test13.tm_nk] 34include/diff_tables.inc [master:test13.ti_nk, slave:test13.ti_nk] 35include/diff_tables.inc [master:test13.tm_wk, slave:test13.tm_wk] 36include/diff_tables.inc [master:test13.ti_wk, slave:test13.ti_wk] 37include/sync_slave_sql_with_master.inc 38include/diff_tables.inc [master:test12.tm_nk, slave:test12.tm_nk] 39include/diff_tables.inc [master:test12.ti_nk, slave:test12.ti_nk] 40include/diff_tables.inc [master:test12.tm_wk, slave:test12.tm_wk] 41include/diff_tables.inc [master:test12.ti_wk, slave:test12.ti_wk] 42include/sync_slave_sql_with_master.inc 43include/diff_tables.inc [master:test11.tm_nk, slave:test11.tm_nk] 44include/diff_tables.inc [master:test11.ti_nk, slave:test11.ti_nk] 45include/diff_tables.inc [master:test11.tm_wk, slave:test11.tm_wk] 46include/diff_tables.inc [master:test11.ti_wk, slave:test11.ti_wk] 47include/sync_slave_sql_with_master.inc 48include/diff_tables.inc [master:test10.tm_nk, slave:test10.tm_nk] 49include/diff_tables.inc [master:test10.ti_nk, slave:test10.ti_nk] 50include/diff_tables.inc [master:test10.tm_wk, slave:test10.tm_wk] 51include/diff_tables.inc [master:test10.ti_wk, slave:test10.ti_wk] 52include/sync_slave_sql_with_master.inc 53include/diff_tables.inc [master:test9.tm_nk, slave:test9.tm_nk] 54include/diff_tables.inc [master:test9.ti_nk, slave:test9.ti_nk] 55include/diff_tables.inc [master:test9.tm_wk, slave:test9.tm_wk] 56include/diff_tables.inc [master:test9.ti_wk, slave:test9.ti_wk] 57include/sync_slave_sql_with_master.inc 58include/diff_tables.inc [master:test8.tm_nk, slave:test8.tm_nk] 59include/diff_tables.inc [master:test8.ti_nk, slave:test8.ti_nk] 60include/diff_tables.inc [master:test8.tm_wk, slave:test8.tm_wk] 61include/diff_tables.inc [master:test8.ti_wk, slave:test8.ti_wk] 62include/sync_slave_sql_with_master.inc 63include/diff_tables.inc [master:test7.tm_nk, slave:test7.tm_nk] 64include/diff_tables.inc [master:test7.ti_nk, slave:test7.ti_nk] 65include/diff_tables.inc [master:test7.tm_wk, slave:test7.tm_wk] 66include/diff_tables.inc [master:test7.ti_wk, slave:test7.ti_wk] 67include/sync_slave_sql_with_master.inc 68include/diff_tables.inc [master:test6.tm_nk, slave:test6.tm_nk] 69include/diff_tables.inc [master:test6.ti_nk, slave:test6.ti_nk] 70include/diff_tables.inc [master:test6.tm_wk, slave:test6.tm_wk] 71include/diff_tables.inc [master:test6.ti_wk, slave:test6.ti_wk] 72include/sync_slave_sql_with_master.inc 73include/diff_tables.inc [master:test5.tm_nk, slave:test5.tm_nk] 74include/diff_tables.inc [master:test5.ti_nk, slave:test5.ti_nk] 75include/diff_tables.inc [master:test5.tm_wk, slave:test5.tm_wk] 76include/diff_tables.inc [master:test5.ti_wk, slave:test5.ti_wk] 77include/sync_slave_sql_with_master.inc 78include/diff_tables.inc [master:test4.tm_nk, slave:test4.tm_nk] 79include/diff_tables.inc [master:test4.ti_nk, slave:test4.ti_nk] 80include/diff_tables.inc [master:test4.tm_wk, slave:test4.tm_wk] 81include/diff_tables.inc [master:test4.ti_wk, slave:test4.ti_wk] 82include/sync_slave_sql_with_master.inc 83include/diff_tables.inc [master:test3.tm_nk, slave:test3.tm_nk] 84include/diff_tables.inc [master:test3.ti_nk, slave:test3.ti_nk] 85include/diff_tables.inc [master:test3.tm_wk, slave:test3.tm_wk] 86include/diff_tables.inc [master:test3.ti_wk, slave:test3.ti_wk] 87include/sync_slave_sql_with_master.inc 88include/diff_tables.inc [master:test2.tm_nk, slave:test2.tm_nk] 89include/diff_tables.inc [master:test2.ti_nk, slave:test2.ti_nk] 90include/diff_tables.inc [master:test2.tm_wk, slave:test2.tm_wk] 91include/diff_tables.inc [master:test2.ti_wk, slave:test2.ti_wk] 92include/sync_slave_sql_with_master.inc 93include/diff_tables.inc [master:test1.tm_nk, slave:test1.tm_nk] 94include/diff_tables.inc [master:test1.ti_nk, slave:test1.ti_nk] 95include/diff_tables.inc [master:test1.tm_wk, slave:test1.tm_wk] 96include/diff_tables.inc [master:test1.ti_wk, slave:test1.ti_wk] 97include/sync_slave_sql_with_master.inc 98include/diff_tables.inc [master:test0.tm_nk, slave:test0.tm_nk] 99include/diff_tables.inc [master:test0.ti_nk, slave:test0.ti_nk] 100include/diff_tables.inc [master:test0.tm_wk, slave:test0.tm_wk] 101include/diff_tables.inc [master:test0.ti_wk, slave:test0.ti_wk] 102include/sync_slave_sql_with_master.inc 103include/rpl_end.inc 104