Debian Codegraph @

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

raw
1 include/save_sysvars.inc [ "GLOBAL.max_allowed_packet" ]
2 SET @@global.max_allowed_packet = 1024*1024*1024;
3 include/master-slave.inc
4 Warnings:
5 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
6 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.
7 [connection master]
8
9 ==== Setup variables ====
10
11 ==== Scenario: compression=0 ====
12 [connection master]
13 * Writing 8 * 16778240 random bytes to file, 8 times
14 FLUSH BINARY LOGS;
15 SET @@session.binlog_transaction_compression = 0;
16 include/save_binlog_position.inc
17 CREATE TABLE t1 (x LONGBLOB);
18 BEGIN;
19 # Iteration 1/8
20 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
21 # Iteration 2/8
22 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
23 # Iteration 3/8
24 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
25 # Iteration 4/8
26 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
27 # Iteration 5/8
28 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
29 # Iteration 6/8
30 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
31 # Iteration 7/8
32 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
33 # Iteration 8/8
34 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
35 COMMIT;
36
37 ==== Verify result on source ====
38 # There should be no payload event.
39 include/show_binlog_events.inc
40 Log_name Pos Event_type Server_id End_log_pos Info
41 master-bin.000002 # Query # # use `test`; CREATE TABLE t1 (x LONGBLOB)
42 master-bin.000002 # Query # # BEGIN
43 master-bin.000002 # Table_map # # table_id: # (test.t1)
44 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
45 master-bin.000002 # Table_map # # table_id: # (test.t1)
46 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
47 master-bin.000002 # Table_map # # table_id: # (test.t1)
48 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
49 master-bin.000002 # Table_map # # table_id: # (test.t1)
50 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
51 master-bin.000002 # Table_map # # table_id: # (test.t1)
52 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
53 master-bin.000002 # Table_map # # table_id: # (test.t1)
54 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
55 master-bin.000002 # Table_map # # table_id: # (test.t1)
56 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
57 master-bin.000002 # Table_map # # table_id: # (test.t1)
58 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
59 master-bin.000002 # Xid # # COMMIT /* XID */
60 master-bin.000002 # Rotate # # master-bin.000003;pos=POS
61 include/assert.inc [The source's table size should equal the size of inserted data]
62 include/sync_slave_sql_with_master.inc
63 ==== Verify result on replica ====
64 include/assert.inc [The replica's table size should equal the size of inserted data]
65
66 ==== Clean up scenario ====
67 [connection master]
68 DROP TABLE t1;
69 include/sync_slave_sql_with_master.inc
70
71 ==== Scenario: compression=1 ====
72 [connection master]
73 * Writing 8 * 16778240 random bytes to file, 8 times
74 FLUSH BINARY LOGS;
75 SET @@session.binlog_transaction_compression = 1;
76 include/save_binlog_position.inc
77 CREATE TABLE t1 (x LONGBLOB);
78 BEGIN;
79 # Iteration 1/8
80 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
81 # Iteration 2/8
82 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
83 # Iteration 3/8
84 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
85 # Iteration 4/8
86 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
87 # Iteration 5/8
88 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
89 # Iteration 6/8
90 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
91 # Iteration 7/8
92 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
93 # Iteration 8/8
94 INSERT INTO t1 VALUES (LOAD_FILE('FILE'));
95 COMMIT;
96
97 ==== Verify result on source ====
98 # There should be no payload event.
99 include/show_binlog_events.inc
100 Log_name Pos Event_type Server_id End_log_pos Info
101 master-bin.000004 # Query # # use `test`; CREATE TABLE t1 (x LONGBLOB)
102 master-bin.000004 # Query # # BEGIN
103 master-bin.000004 # Table_map # # table_id: # (test.t1)
104 master-bin.000004 # Write_rows # # table_id: # flags: STMT_END_F
105 master-bin.000004 # Table_map # # table_id: # (test.t1)
106 master-bin.000004 # Write_rows # # table_id: # flags: STMT_END_F
107 master-bin.000004 # Table_map # # table_id: # (test.t1)
108 master-bin.000004 # Write_rows # # table_id: # flags: STMT_END_F
109 master-bin.000004 # Table_map # # table_id: # (test.t1)
110 master-bin.000004 # Write_rows # # table_id: # flags: STMT_END_F
111 master-bin.000004 # Table_map # # table_id: # (test.t1)
112 master-bin.000004 # Write_rows # # table_id: # flags: STMT_END_F
113 master-bin.000004 # Table_map # # table_id: # (test.t1)
114 master-bin.000004 # Write_rows # # table_id: # flags: STMT_END_F
115 master-bin.000004 # Table_map # # table_id: # (test.t1)
116 master-bin.000004 # Write_rows # # table_id: # flags: STMT_END_F
117 master-bin.000004 # Table_map # # table_id: # (test.t1)
118 master-bin.000004 # Write_rows # # table_id: # flags: STMT_END_F
119 master-bin.000004 # Xid # # COMMIT /* XID */
120 master-bin.000004 # Rotate # # master-bin.000005;pos=POS
121 include/assert.inc [The source's table size should equal the size of inserted data]
122 include/sync_slave_sql_with_master.inc
123 ==== Verify result on replica ====
124 include/assert.inc [The replica's table size should equal the size of inserted data]
125
126 ==== Clean up scenario ====
127 [connection master]
128 DROP TABLE t1;
129 include/sync_slave_sql_with_master.inc
130
131 ==== Clean up test case ====
132 [connection master]
133 include/restore_sysvars.inc
134 include/rpl_end.inc