Debian Codegraph @

mysql-test/suite/rpl/r/rpl_innodb_doublewrite_dir_01.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 [Connection Master]
7 USE test;
8 SELECT @@datadir;
9 @@datadir
10 MASTER_DATADIR
11 #ib_16384_0.dblwr
12 SELECT @@innodb_doublewrite_dir;
13 @@innodb_doublewrite_dir
14 MASTER_DOUBLEWRITE_DIR/#DBWL-DIR
15 SELECT @@innodb_doublewrite_files;
16 @@innodb_doublewrite_files
17 1
18 SELECT @@innodb_doublewrite_pages;
19 @@innodb_doublewrite_pages
20 10
21 SELECT @@innodb_doublewrite_batch_size;
22 @@innodb_doublewrite_batch_size
23 10
24 include/sync_slave_sql_with_master.inc
25 [Connection Slave]
26 USE test;
27 SELECT @@datadir;
28 @@datadir
29 SLAVE_DATADIR
30 #ib_16384_0.dblwr
31 #ib_16384_1.dblwr
32 SELECT @@innodb_doublewrite_dir;
33 @@innodb_doublewrite_dir
34 SLAVE_DOUBLEWRITE_DIR/##%DBWL-DIR
35 SELECT @@innodb_doublewrite_files;
36 @@innodb_doublewrite_files
37 2
38 SELECT @@innodb_doublewrite_pages;
39 @@innodb_doublewrite_pages
40 2
41 SELECT @@innodb_doublewrite_batch_size;
42 @@innodb_doublewrite_batch_size
43 0
44 [Connection Master]
45 USE test;
46 CREATE TABLE tab(c1 int,c2 TEXT);
47 INSERT INTO tab VALUES(1,'Testing of WL#5655');
48 SELECT * FROM tab;
49 c1 c2
50 1 Testing of WL#5655
51 SET GLOBAL innodb_doublewrite_dir=$MYSQL_TMP_DIR/"#DBWL-DIR";
52 ERROR HY000: Variable 'innodb_doublewrite_dir' is a read only variable
53 SET GLOBAL innodb_doublewrite_files=1;
54 ERROR HY000: Variable 'innodb_doublewrite_files' is a read only variable
55 SET GLOBAL innodb_doublewrite_pages=10;
56 ERROR HY000: Variable 'innodb_doublewrite_pages' is a read only variable
57 SET GLOBAL innodb_doublewrite_batch_size=1;
58 ERROR HY000: Variable 'innodb_doublewrite_batch_size' is a read only variable
59 include/sync_slave_sql_with_master.inc
60 [Connection Slave]
61 USE test;
62 SELECT * FROM tab;
63 c1 c2
64 1 Testing of WL#5655
65 SET GLOBAL innodb_doublewrite_dir=$MYSQL_TMP_DIR/"#DBWL-DIR";
66 ERROR HY000: Variable 'innodb_doublewrite_dir' is a read only variable
67 SET GLOBAL innodb_doublewrite_files=1;
68 ERROR HY000: Variable 'innodb_doublewrite_files' is a read only variable
69 SET GLOBAL innodb_doublewrite_pages=10;
70 ERROR HY000: Variable 'innodb_doublewrite_pages' is a read only variable
71 SET GLOBAL innodb_doublewrite_batch_size=1;
72 ERROR HY000: Variable 'innodb_doublewrite_batch_size' is a read only variable
73 [Connection Master]
74 USE test;
75 DROP TABLE tab;
76 include/sync_slave_sql_with_master.inc
77 [Connection Slave]
78 USE test;
79 SELECT * FROM tab;
80 ERROR 42S02: Table 'test.tab' doesn't exist
81 include/rpl_end.inc