2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
9
# Generate a big enough master's binlog to cause relay log rotations
11
create table t1 (a int);
17
set @my_max_binlog_size= @@global.max_binlog_size;
18
set global max_binlog_size=8192;
19
set global max_relay_log_size=8192-1;
21
Warning 1292 Truncated incorrect max_relay_log_size value: '8191'
22
select @@global.max_relay_log_size;
23
@@global.max_relay_log_size
26
Checking that both slave threads are running.
32
set global max_relay_log_size=(5*4096);
33
select @@global.max_relay_log_size;
34
@@global.max_relay_log_size 20480
36
Checking that both slave threads are running.
38
# Test 3: max_relay_log_size = 0
42
set global max_relay_log_size=0;
43
select @@global.max_relay_log_size;
44
@@global.max_relay_log_size 0
46
Checking that both slave threads are running.
48
# Test 4: Tests below are mainly to ensure that we have not coded with wrong assumptions
59
create table t1 (a int);
60
Checking that both slave threads are running.
62
# Test 6: one more rotation, to be sure Relay_Log_Space is correctly updated
66
Checking that both slave threads are running.
69
File Position Binlog_Do_DB Binlog_Ignore_DB
70
master-bin.000002 # <Binlog_Do_DB> <Binlog_Ignore_DB>
71
set global max_binlog_size= @my_max_binlog_size;