Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 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.
5 [connection master]
6 CREATE TABLE t1(i INT, t LONGTEXT);
7 include/sync_slave_sql_with_master.inc
8 [connection master]
9 INSERT INTO t1 VALUES (1, 'start');
10 include/sync_slave_sql_with_master.inc
11 include/stop_slave_sql.inc
12 [connection master]
13 include/sync_slave_io_with_master.inc
14 START SLAVE SQL_THREAD;
15 Warnings:
16 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
17 include/sync_slave_sql_with_io.inc
18 include/assert.inc ["The expected read count and actual read count are same"]
19 The read count for @@GLOBAL.rpl_read_size= 8192 is 883
20 SET @@GLOBAL.rpl_read_size= 1048576;
21 include/stop_slave.inc
22 include/start_slave.inc
23 [connection master]
24 INSERT INTO t1 VALUES (1, 'start');
25 include/sync_slave_sql_with_master.inc
26 include/stop_slave_sql.inc
27 [connection master]
28 include/sync_slave_io_with_master.inc
29 START SLAVE SQL_THREAD;
30 Warnings:
31 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
32 include/sync_slave_sql_with_io.inc
33 include/assert.inc ["The expected read count and actual read count are same"]
34 The read count for @@GLOBAL.rpl_read_size= 1048576 is 7
35 SET @@GLOBAL.rpl_read_size= 1048576;
36 include/stop_slave.inc
37 include/start_slave.inc
38 SET @@GLOBAL.rpl_read_size= 8192;
39 SET @@GLOBAL.rpl_read_size = 1048576;
40 SELECT @@GLOBAL.rpl_read_size;
41 @@GLOBAL.rpl_read_size
42 1048576
43 FLUSH RELAY LOGS;
44 [connection master]
45 INSERT INTO t1 VALUES (0, "");
46 INSERT INTO t1 VALUES (1, lpad("foo", 7000, "bar"));
47 include/sync_slave_sql_with_master.inc
48 include/diff_tables.inc [master:t1, slave:t1]
49 SET @@GLOBAL.rpl_read_size= 8192;
50 [connection master]
51 DROP TABLE t1;
52 include/rpl_end.inc