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
53
54
55
56
57
|
--source include/galera_cluster.inc
--source include/have_innodb.inc
--write_file $MYSQLTEST_VARDIR/tmp/galera_concurrent.sql
CREATE table t1 as SELECT SLEEP(0);
DROP table t1;
CREATE table t1 as SELECT SLEEP(0);
DROP table t1;
CREATE table t1 as SELECT SLEEP(0);
DROP table t1;
CREATE table t1 as SELECT SLEEP(0);
DROP table t1;
CREATE table t1 as SELECT SLEEP(0);
DROP table t1;
CREATE table t1 as SELECT SLEEP(0);
DROP table t1;
CREATE table t1 as SELECT SLEEP(0);
DROP table t1;
CREATE table t1 as SELECT SLEEP(0);
DROP table t1;
CREATE table t1 as SELECT SLEEP(0);
CREATE table t2 as SELECT SLEEP(0);
CREATE table t3 as SELECT SLEEP(0);
CREATE table t4 as SELECT SLEEP(0);
CREATE table t5 as SELECT SLEEP(0);
CREATE table t6 as SELECT SLEEP(0);
CREATE table t7 as SELECT SLEEP(0);
CREATE table t8 as SELECT SLEEP(0);
CREATE table t9 as SELECT SLEEP(0);
DROP table t1;
DROP table t2;
DROP table t3;
DROP table t4;
DROP table t5;
DROP table t6;
DROP table t7;
DROP table t8;
DROP table t9;
EOF
let $run=10;
while($run)
{
--error 0,1
exec $MYSQL --user=root --host=127.0.0.1 --port=$NODE_MYPORT_1 test \
< $MYSQLTEST_VARDIR/tmp/galera_concurrent.sql & \
$MYSQL --user=root --host=127.0.0.1 --port=$NODE_MYPORT_2 test \
< $MYSQLTEST_VARDIR/tmp/galera_concurrent.sql;
dec $run;
}
--remove_file $MYSQLTEST_VARDIR/tmp/galera_concurrent.sql
--source include/galera_end.inc
--echo # End of test
|
