include/master-slave.inc [connection master] connection slave; stop slave; connection master; # # Generate a big enough master's binlog to cause relay log rotations # create table t1 (a int); drop table t1; connection slave; reset slave; # # Test 1 # set @my_max_binlog_size= @@global.max_binlog_size, @my_max_relay_log_size=@@global.max_relay_log_size; set global max_binlog_size=8192; set global max_relay_log_size=8192-1; Warnings: Warning 1292 Truncated incorrect max_relay_log_size value: '8191' select @@global.max_relay_log_size; @@global.max_relay_log_size 4096 start slave; include/check_slave_is_running.inc # # Test 2 # stop slave; reset slave; set global max_relay_log_size=(5*4096); select @@global.max_relay_log_size; @@global.max_relay_log_size 20480 start slave; include/check_slave_is_running.inc # # Test 3: max_relay_log_size = 0 # stop slave; reset slave; set global max_relay_log_size=0; Warnings: Warning 1292 Truncated incorrect max_relay_log_size value: '0' select @@global.max_relay_log_size; @@global.max_relay_log_size 4096 start slave; include/check_slave_is_running.inc # # Test 4: Tests below are mainly to ensure that we have not coded with wrong assumptions # stop slave; reset slave; flush logs; # # Test 5 # reset slave; start slave; flush logs; connection master; create table t1 (a int); connection slave; include/check_slave_is_running.inc # # Test 6: one more rotation, to be sure Relay_Log_Space is correctly updated # flush logs; connection master; drop table t1; connection slave; include/check_slave_is_running.inc connection master; flush logs; show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000002 # connection slave; set global max_binlog_size= @my_max_binlog_size; set global max_relay_log_size= @my_max_relay_log_size; # # End of 4.1 tests # include/rpl_end.inc