Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_stm_max_relay_size.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 stop slave;
5 connection master;
6 #
7 # Generate a big enough master's binlog to cause relay log rotations
8 #
9 create table t1 (a int);
10 drop table t1;
11 connection slave;
12 reset slave;
13 #
14 # Test 1
15 #
16 set @my_max_binlog_size= @@global.max_binlog_size, @my_max_relay_log_size=@@global.max_relay_log_size;
17 set global max_binlog_size=8192;
18 set global max_relay_log_size=8192-1;
19 Warnings:
20 Warning 1292 Truncated incorrect max_relay_log_size value: '8191'
21 select @@global.max_relay_log_size;
22 @@global.max_relay_log_size
23 4096
24 start slave;
25 include/check_slave_is_running.inc
26 #
27 # Test 2
28 #
29 stop slave;
30 reset slave;
31 set global max_relay_log_size=(5*4096);
32 select @@global.max_relay_log_size;
33 @@global.max_relay_log_size 20480
34 start slave;
35 include/check_slave_is_running.inc
36 #
37 # Test 3: max_relay_log_size = 0
38 #
39 stop slave;
40 reset slave;
41 set global max_relay_log_size=0;
42 Warnings:
43 Warning 1292 Truncated incorrect max_relay_log_size value: '0'
44 select @@global.max_relay_log_size;
45 @@global.max_relay_log_size 4096
46 start slave;
47 include/check_slave_is_running.inc
48 #
49 # Test 4: Tests below are mainly to ensure that we have not coded with wrong assumptions
50 #
51 stop slave;
52 reset slave;
53 flush logs;
54 #
55 # Test 5
56 #
57 reset slave;
58 start slave;
59 flush logs;
60 connection master;
61 create table t1 (a int);
62 connection slave;
63 include/check_slave_is_running.inc
64 #
65 # Test 6: one more rotation, to be sure Relay_Log_Space is correctly updated
66 #
67 flush logs;
68 connection master;
69 drop table t1;
70 connection slave;
71 include/check_slave_is_running.inc
72 connection master;
73 flush logs;
74 show master status;
75 File Position Binlog_Do_DB Binlog_Ignore_DB
76 master-bin.000002 # <Binlog_Do_DB> <Binlog_Ignore_DB>
77 connection slave;
78 set global max_binlog_size= @my_max_binlog_size;
79 set global max_relay_log_size= @my_max_relay_log_size;
80 #
81 # End of 4.1 tests
82 #
83 include/rpl_end.inc