1 ################################################################################
2 # Build connections to master server
3 # Stress test that execute massive queries on every connection
5 # ################################################################################
13 --eval CREATE
TABLE t$i(c1 INT) ENGINE= $engine;
19 --sync_slave_with_master
21 --echo # Build connections
to master server
27 --connect(con$i,127.0.0.1,root,,
test,$MASTER_MYPORT,)
31 while ($i < $connections)
34 set session debug=
"+d,simulate_binlog_flush_error";
40 --echo # Stress
test that execute massive queries on every connection
47 # Execute INSERT statement on these connections in parallel
53 --eval INSERT INTO t$i VALUES(2)
56 # reap on every connection
68 while ($i < $connections)
71 set session debug=
"-d,simulate_binlog_flush_error";
77 --let $slave_timeout= 3600
78 if ($enable_diff_table)
80 --source include/sync_slave_sql_with_master.inc
81 --echo #
Test if the results are consistent on master and slave
85 --let $diff_tables= master:t$i, slave:t$i
86 --source include/diff_tables.inc
95 # disconnect connections
106 --eval DROP
TABLE t$i
111 --source include/sync_slave_sql_with_master.inc