File: multi_parallel.result

package info (click to toggle)
mariadb-10.5 1%3A10.5.23-0%2Bdeb11u1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 712,240 kB
  • sloc: ansic: 2,158,658; cpp: 1,843,101; asm: 297,745; perl: 59,967; sh: 53,869; pascal: 38,348; java: 33,919; yacc: 19,639; python: 11,119; xml: 10,126; sql: 10,027; ruby: 8,544; makefile: 6,343; cs: 2,866; lex: 1,205; javascript: 1,037; objc: 80; tcl: 73; awk: 46; php: 22; sed: 16
file content (64 lines) | stat: -rw-r--r-- 1,775 bytes parent folder | download | duplicates (4)
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
58
59
60
61
62
63
64
connect  master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
connect  master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
connect  slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
set global slave_parallel_threads=10;
change master 'master1' to
master_port=MYPORT_1,
master_host='127.0.0.1',
master_user='root';
change master 'master2' to
master_port=MYPORT_2,
master_host='127.0.0.1',
master_user='root';
start all slaves;
set default_master_connection = 'master1';
include/wait_for_slave_to_start.inc
set default_master_connection = 'master2';
include/wait_for_slave_to_start.inc
## Slave status variable
set default_master_connection = 'master1';
show status like 'slave_running';
Variable_name	Value
Slave_running	ON
set default_master_connection = 'master2';
show status like 'slave_running';
Variable_name	Value
Slave_running	ON
#master 1
connection master1;
##Running CURD operation
connection slave;
Slave_DDL_Groups= 20;
Slave_Non_Transactional_Groups= 20;
Slave_Transactional_Groups= 0;
#master 2
connection master2;
##Running CURD operation
connection slave;
Slave_DDL_Groups= 20;
Slave_Non_Transactional_Groups= 20;
Slave_Transactional_Groups= 0;
#master 1
connection master1;
##Running CURD operation
connection slave;
Slave_DDL_Groups= 40;
Slave_Non_Transactional_Groups= 20;
Slave_Transactional_Groups= 20;
stop all slaves;
Warnings:
Note	1938	SLAVE 'master2' stopped
Note	1938	SLAVE 'master1' stopped
set default_master_connection = 'master1';
include/wait_for_slave_to_stop.inc
set default_master_connection = 'master2';
include/wait_for_slave_to_stop.inc
set global slave_parallel_threads=0;
include/reset_master_slave.inc
disconnect slave;
connection master1;
include/reset_master_slave.inc
disconnect master1;
connection master2;
include/reset_master_slave.inc
disconnect master2;