1 set @saved_binlog_format = @@global.binlog_format;
2 SET SESSION BINLOG_FORMAT=ROW;
3 SET GLOBAL BINLOG_FORMAT=ROW;
5 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
8 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
12 # Generate a big enough master's binlog to cause relay log rotations
14 create table t1 (a int);
20 set @my_max_binlog_size= @@global.max_binlog_size;
21 set global max_binlog_size=8192;
22 set global max_relay_log_size=8192-1;
23 select @@global.max_relay_log_size;
24 @@global.max_relay_log_size
27 Checking that both slave threads are running.
33 set global max_relay_log_size=(5*4096);
34 select @@global.max_relay_log_size;
35 @@global.max_relay_log_size 20480
37 Checking that both slave threads are running.
39 # Test 3: max_relay_log_size = 0
43 set global max_relay_log_size=0;
44 select @@global.max_relay_log_size;
45 @@global.max_relay_log_size 0
47 Checking that both slave threads are running.
49 # Test 4: Tests below are mainly to ensure that we have not coded with wrong assumptions
60 create table t1 (a int);
61 Checking that both slave threads are running.
63 # Test 6: one more rotation, to be sure Relay_Log_Space is correctly updated
67 Checking that both slave threads are running.
70 File Position Binlog_Do_DB Binlog_Ignore_DB
71 master-bin.000002 # <Binlog_Do_DB> <Binlog_Ignore_DB>
72 set global max_binlog_size= @my_max_binlog_size;
76 SET GLOBAL BINLOG_FORMAT= @saved_binlog_format;