Edit File: rpl_row_max_relay_size.result
include/master-slave.inc [connection master] stop slave; # # Generate a big enough master's binlog to cause relay log rotations # create table t1 (a int); drop table t1; reset slave; # # Test 1 # set @my_max_binlog_size= @@global.max_binlog_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; select @@global.max_relay_log_size; @@global.max_relay_log_size 0 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; create table t1 (a int); include/check_slave_is_running.inc # # Test 6: one more rotation, to be sure Relay_Log_Space is correctly updated # flush logs; drop table t1; include/check_slave_is_running.inc flush logs; show master status; File Position Binlog_Do_DB Binlog_Ignore_DB master-bin.000002 # <Binlog_Do_DB> <Binlog_Ignore_DB> set global max_binlog_size= @my_max_binlog_size; # # End of 4.1 tests # include/rpl_end.inc
Back to File Manager