summaryrefslogtreecommitdiff
path: root/mysql-test/extra
diff options
context:
space:
mode:
authorunknown <lars/lthalmann@dl145k.mysql.com>2006-09-21 13:54:57 +0200
committerunknown <lars/lthalmann@dl145k.mysql.com>2006-09-21 13:54:57 +0200
commit01fe0214a38051f7b9f4abb8ae7a0c46d5536ca6 (patch)
treea172f6e88727c33c247ca6dc16ad78f674653b88 /mysql-test/extra
parentf8ff88f9e3c37938460534e208c62997222ec9db (diff)
parent9de027bdd54c84f0037f123e815e8628029261c5 (diff)
downloadmariadb-git-01fe0214a38051f7b9f4abb8ae7a0c46d5536ca6.tar.gz
Merge mysql.com:/users/lthalmann/bk/MERGE/mysql-5.0-merge
into mysql.com:/users/lthalmann/bk/MERGE/mysql-5.1-merge mysql-test/extra/rpl_tests/rpl_max_relay_size.test: Manual merge 5.0->5.1 mysql-test/r/rpl_insert_id.result: Manual merge 5.0->5.1 mysql-test/r/rpl_stm_max_relay_size.result: Manual merge 5.0->5.1 mysql-test/t/rpl_insert_id.test: Manual merge 5.0->5.1
Diffstat (limited to 'mysql-test/extra')
-rw-r--r--mysql-test/extra/rpl_tests/rpl_max_relay_size.test44
1 files changed, 41 insertions, 3 deletions
diff --git a/mysql-test/extra/rpl_tests/rpl_max_relay_size.test b/mysql-test/extra/rpl_tests/rpl_max_relay_size.test
index 14223392224..50325f83358 100644
--- a/mysql-test/extra/rpl_tests/rpl_max_relay_size.test
+++ b/mysql-test/extra/rpl_tests/rpl_max_relay_size.test
@@ -9,7 +9,10 @@
connection slave;
stop slave;
connection master;
-# Generate a big enough master's binlog to cause relay log rotations
+
+--echo #
+--echo # Generate a big enough master's binlog to cause relay log rotations
+--echo #
create table t1 (a int);
let $1=800;
@@ -26,6 +29,11 @@ drop table t1;
save_master_pos;
connection slave;
reset slave;
+
+--echo #
+--echo # Test 1
+--echo #
+
set global max_binlog_size=8192;
set global max_relay_log_size=8192-1; # mapped to 4096
select @@global.max_relay_log_size;
@@ -33,7 +41,13 @@ start slave;
sync_with_master;
--replace_result $MASTER_MYPORT MASTER_PORT
--replace_column 1 # 8 # 9 # 16 # 23 # 33 #
+--vertical_results
show slave status;
+
+--echo #
+--echo # Test 2
+--echo #
+
stop slave;
reset slave;
set global max_relay_log_size=(5*4096);
@@ -42,7 +56,13 @@ start slave;
sync_with_master;
--replace_result $MASTER_MYPORT MASTER_PORT
--replace_column 1 # 8 # 9 # 16 # 23 # 33 #
+--vertical_results
show slave status;
+
+--echo #
+--echo # Test 3: max_relay_log_size = 0
+--echo #
+
stop slave;
reset slave;
set global max_relay_log_size=0;
@@ -51,9 +71,12 @@ start slave;
sync_with_master;
--replace_result $MASTER_MYPORT MASTER_PORT
--replace_column 1 # 8 # 9 # 16 # 23 # 33 #
+--vertical_results
show slave status;
-# Tests below are mainly to ensure that we have not coded with wrong assumptions
+--echo #
+--echo # Test 4: Tests below are mainly to ensure that we have not coded with wrong assumptions
+--echo #
stop slave;
reset slave;
@@ -62,8 +85,13 @@ reset slave;
flush logs;
--replace_result $MASTER_MYPORT MASTER_PORT
--replace_column 1 # 8 # 9 # 16 # 23 # 33 #
+--vertical_results
show slave status;
+--echo #
+--echo # Test 5
+--echo #
+
reset slave;
start slave;
sync_with_master;
@@ -78,8 +106,13 @@ connection slave;
sync_with_master;
--replace_result $MASTER_MYPORT MASTER_PORT
--replace_column 1 # 8 # 9 # 16 # 23 # 33 #
+--vertical_results
show slave status;
-# one more rotation, to be sure Relay_Log_Space is correctly updated
+
+--echo #
+--echo # Test 6: one more rotation, to be sure Relay_Log_Space is correctly updated
+--echo #
+
flush logs;
connection master;
drop table t1;
@@ -88,6 +121,7 @@ connection slave;
sync_with_master;
--replace_result $MASTER_MYPORT MASTER_PORT
--replace_column 1 # 8 # 9 # 16 # 23 # 33 #
+--vertical_results
show slave status;
connection master;
@@ -95,3 +129,7 @@ connection master;
flush logs;
-- replace_column 3 <Binlog_Ignore_DB>
show master status;
+
+--echo #
+--echo # End of 4.1 tests
+--echo #