Debian Codegraph @

mysql-test/suite/rpl/r/rpl_ignore_events_mem_growth.result

raw
1 #
2 # Step-1) Create M1<->M2 replication topology
3 #
4 include/rpl_init.inc [topology=1->2->1]
5 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
8 Warnings:
9 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
10 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
11 #
12 # Step-2) Create a sample table to create ignored/skipped
13 # insert events on the table. And run some sample
14 # inserts on both nodes, so that initial hiccups
15 # in bytes used will not be counted.
16 #
17 [connection server_1]
18 CREATE TABLE t1(i INT);
19 include/rpl_sync.inc
20 [connection server_1]
21 INSERT INTO t1 VALUES (1);
22 INSERT INTO t1 VALUES (2);
23 [connection server_2]
24 INSERT INTO t1 VALUES (3);
25 INSERT INTO t1 VALUES (4);
26 include/rpl_sync.inc
27 #
28 # Step-3) If gtid_mode is OFF, set sql_replica_skip_counter to 50 on
29 # M2 node and restart sql thread to make the change effective.
30 #
31 # If gtid_mode is ON, execute 50 empty transactions on
32 # M2 node, so that 50 transactions from M1 will be skipped.
33 #
34 [connection server_2]
35 include/stop_slave_sql.inc
36 include/start_slave_sql.inc
37 #
38 # Step-4) Record thd::main_mem_root usage values on both servers before
39 # starting the experiment.
40 #
41 [connection server_1]
42 [connection server_2]
43 #
44 # Step-5) Insert 100 sample queries on M1 node. First 50 inserts will
45 # be ignored on M2 node (because sql_replica_skip_counter set to
46 # 50). Second 50 inserts will be executed on M2 and will be
47 # replicated back to M1 node. But they will be ignored on M1
48 # because they were originated on M1 node.
49 #
50 [connection server_1]
51 include/rpl_sync.inc
52 [connection server_2]
53 INSERT INTO t1 VALUES (100);
54 include/rpl_sync.inc
55 #
56 # Step-6) Record thd::main_mem_root usage value on M1 after
57 # the experiment. Check that thd::main_mem_root value
58 # did not increased.
59 #
60 [connection server_1]
61 include/assert.inc [thd::main_mem_root on M1 should be the same value as before experiment value.]
62 #
63 # Step-7) Record thd::main_mem_root usage value on M2 after
64 # the experiment. Check that thd::main_mem_root value
65 # did not increased.
66 #
67 [connection server_2]
68 include/assert.inc [thd::main_mem_root on M2 should be the same value as before experiment value.]
69 #
70 # Step-8) Cleanup.
71 #
72 DROP TABLE t1;
73 include/rpl_end.inc