Debian Codegraph @

mysql-test/suite/innodb/r/innodb_redo_debug_1.result

raw
1 # Test with log_buffer_write_completed_before_store
2 DROP DATABASE IF EXISTS dbredoopt;
3 CREATE DATABASE dbredoopt;
4 USE dbredoopt;
5 CREATE TABLE dbredoopt.t1
6 (col1 INT, col2 INT, c1 LONGBLOB, c2 LONGBLOB,
7 PRIMARY KEY(col1), INDEX `idx2` (col2),
8 INDEX `idx3` (c1(300),c2(200))
9 );
10 CREATE PROCEDURE dbredoopt.populate_t1()
11 BEGIN
12 DECLARE i INT DEFAULT 1;
13 while (i <= 500) DO
14 INSERT INTO dbredoopt.t1 values (i, i,REPEAT('a',5000), REPEAT('b',5000));
15 SET i = i + 1;
16 END WHILE;
17 END|
18 CREATE USER 'redo_wl_user'@'localhost';
19 GRANT ALL PRIVILEGES ON *.* TO 'redo_wl_user'@'localhost' WITH GRANT OPTION;
20 START TRANSACTION;
21 SELECT count(*) FROM dbredoopt.t1;
22 count(*)
23 0
24 call dbredoopt.populate_t1();
25 SELECT count(*) FROM dbredoopt.t1;
26 count(*)
27 500
28 SELECT col1 FROM dbredoopt.t1 LIMIT 10;
29 col1
30 1
31 2
32 3
33 4
34 5
35 6
36 7
37 8
38 9
39 10
40 COMMIT;
41 # Check rows which are not modified by parallel load
42 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
43 col1
44 50
45 100
46 150
47 200
48 250
49 300
50 350
51 400
52 450
53 500
54 # Wait till all mysql clients are connected
55 # Singal all mysql clients since each one is waiting for signal go_ahead
56 # with 'go_ahead' signal , all client suppose to resume in parallel
57 # Wait till all clients are over or server is gone
58 # restart
59 # Check rows which are not modified by parallel load
60 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
61 col1
62 50
63 100
64 150
65 200
66 250
67 300
68 350
69 400
70 450
71 500
72 # Check rows which are updated by parallel load
73 SELECT count(*)=0 FROM (SELECT col1,col2 FROM dbredoopt.t1 WHERE col1 NOT BETWEEN 1 AND 501 ) AS A WHERE (A.col1+A.col2) != 0 ;
74 count(*)=0
75 1
76 DROP DATABASE dbredoopt;
77 DROP USER 'redo_wl_user'@'localhost';
78 # Test with log_buffer_write_before_memcpy
79 DROP DATABASE IF EXISTS dbredoopt;
80 CREATE DATABASE dbredoopt;
81 USE dbredoopt;
82 CREATE TABLE dbredoopt.t1
83 (col1 INT, col2 INT, c1 LONGBLOB, c2 LONGBLOB,
84 PRIMARY KEY(col1), INDEX `idx2` (col2),
85 INDEX `idx3` (c1(300),c2(200))
86 );
87 CREATE PROCEDURE dbredoopt.populate_t1()
88 BEGIN
89 DECLARE i INT DEFAULT 1;
90 while (i <= 500) DO
91 INSERT INTO dbredoopt.t1 values (i, i,REPEAT('a',5000), REPEAT('b',5000));
92 SET i = i + 1;
93 END WHILE;
94 END|
95 CREATE USER 'redo_wl_user'@'localhost';
96 GRANT ALL PRIVILEGES ON *.* TO 'redo_wl_user'@'localhost' WITH GRANT OPTION;
97 START TRANSACTION;
98 SELECT count(*) FROM dbredoopt.t1;
99 count(*)
100 0
101 call dbredoopt.populate_t1();
102 SELECT count(*) FROM dbredoopt.t1;
103 count(*)
104 500
105 SELECT col1 FROM dbredoopt.t1 LIMIT 10;
106 col1
107 1
108 2
109 3
110 4
111 5
112 6
113 7
114 8
115 9
116 10
117 COMMIT;
118 # Check rows which are not modified by parallel load
119 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
120 col1
121 50
122 100
123 150
124 200
125 250
126 300
127 350
128 400
129 450
130 500
131 # Wait till all mysql clients are connected
132 # Singal all mysql clients since each one is waiting for signal go_ahead
133 # with 'go_ahead' signal , all client suppose to resume in parallel
134 # Wait till all clients are over or server is gone
135 # restart
136 # Check rows which are not modified by parallel load
137 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
138 col1
139 50
140 100
141 150
142 200
143 250
144 300
145 350
146 400
147 450
148 500
149 # Check rows which are updated by parallel load
150 SELECT count(*)=0 FROM (SELECT col1,col2 FROM dbredoopt.t1 WHERE col1 NOT BETWEEN 1 AND 501 ) AS A WHERE (A.col1+A.col2) != 0 ;
151 count(*)=0
152 1
153 DROP DATABASE dbredoopt;
154 DROP USER 'redo_wl_user'@'localhost';
155 # Test with log_buffer_set_first_record_group_before_update
156 DROP DATABASE IF EXISTS dbredoopt;
157 CREATE DATABASE dbredoopt;
158 USE dbredoopt;
159 CREATE TABLE dbredoopt.t1
160 (col1 INT, col2 INT, c1 LONGBLOB, c2 LONGBLOB,
161 PRIMARY KEY(col1), INDEX `idx2` (col2),
162 INDEX `idx3` (c1(300),c2(200))
163 );
164 CREATE PROCEDURE dbredoopt.populate_t1()
165 BEGIN
166 DECLARE i INT DEFAULT 1;
167 while (i <= 500) DO
168 INSERT INTO dbredoopt.t1 values (i, i,REPEAT('a',5000), REPEAT('b',5000));
169 SET i = i + 1;
170 END WHILE;
171 END|
172 CREATE USER 'redo_wl_user'@'localhost';
173 GRANT ALL PRIVILEGES ON *.* TO 'redo_wl_user'@'localhost' WITH GRANT OPTION;
174 START TRANSACTION;
175 SELECT count(*) FROM dbredoopt.t1;
176 count(*)
177 0
178 call dbredoopt.populate_t1();
179 SELECT count(*) FROM dbredoopt.t1;
180 count(*)
181 500
182 SELECT col1 FROM dbredoopt.t1 LIMIT 10;
183 col1
184 1
185 2
186 3
187 4
188 5
189 6
190 7
191 8
192 9
193 10
194 COMMIT;
195 # Check rows which are not modified by parallel load
196 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
197 col1
198 50
199 100
200 150
201 200
202 250
203 300
204 350
205 400
206 450
207 500
208 # Wait till all mysql clients are connected
209 # Singal all mysql clients since each one is waiting for signal go_ahead
210 # with 'go_ahead' signal , all client suppose to resume in parallel
211 # Wait till all clients are over or server is gone
212 # restart
213 # Check rows which are not modified by parallel load
214 SELECT col1 FROM dbredoopt.t1 WHERE col1%50=0 AND (col1 < 501 AND col1 > 0 );
215 col1
216 50
217 100
218 150
219 200
220 250
221 300
222 350
223 400
224 450
225 500
226 # Check rows which are updated by parallel load
227 SELECT count(*)=0 FROM (SELECT col1,col2 FROM dbredoopt.t1 WHERE col1 NOT BETWEEN 1 AND 501 ) AS A WHERE (A.col1+A.col2) != 0 ;
228 count(*)=0
229 1
230 DROP DATABASE dbredoopt;
231 DROP USER 'redo_wl_user'@'localhost';