Debian Codegraph @

mysql-test/suite/rpl/r/rpl_parallel_multi_db.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 include/stop_slave.inc
7 set @save.replica_parallel_workers= @@global.replica_parallel_workers;
8 set @@global.replica_parallel_workers= 4;
9 include/start_slave.inc
10 create database d8;
11 create table d8.t8 (a int);
12 select round(rand()*8) into @var;
13 insert into d8.t8 values (@var);
14 create table d8.t7 (a int);
15 select round(rand()*8) into @var;
16 insert into d8.t7 values (@var);
17 create table d8.t6 (a int);
18 select round(rand()*8) into @var;
19 insert into d8.t6 values (@var);
20 create table d8.t5 (a int);
21 select round(rand()*8) into @var;
22 insert into d8.t5 values (@var);
23 create table d8.t4 (a int);
24 select round(rand()*8) into @var;
25 insert into d8.t4 values (@var);
26 create table d8.t3 (a int);
27 select round(rand()*8) into @var;
28 insert into d8.t3 values (@var);
29 create table d8.t2 (a int);
30 select round(rand()*8) into @var;
31 insert into d8.t2 values (@var);
32 create table d8.t1 (a int);
33 select round(rand()*8) into @var;
34 insert into d8.t1 values (@var);
35 create database d7;
36 create table d7.t8 (a int);
37 select round(rand()*8) into @var;
38 insert into d7.t8 values (@var);
39 create table d7.t7 (a int);
40 select round(rand()*8) into @var;
41 insert into d7.t7 values (@var);
42 create table d7.t6 (a int);
43 select round(rand()*8) into @var;
44 insert into d7.t6 values (@var);
45 create table d7.t5 (a int);
46 select round(rand()*8) into @var;
47 insert into d7.t5 values (@var);
48 create table d7.t4 (a int);
49 select round(rand()*8) into @var;
50 insert into d7.t4 values (@var);
51 create table d7.t3 (a int);
52 select round(rand()*8) into @var;
53 insert into d7.t3 values (@var);
54 create table d7.t2 (a int);
55 select round(rand()*8) into @var;
56 insert into d7.t2 values (@var);
57 create table d7.t1 (a int);
58 select round(rand()*8) into @var;
59 insert into d7.t1 values (@var);
60 create database d6;
61 create table d6.t8 (a int);
62 select round(rand()*8) into @var;
63 insert into d6.t8 values (@var);
64 create table d6.t7 (a int);
65 select round(rand()*8) into @var;
66 insert into d6.t7 values (@var);
67 create table d6.t6 (a int);
68 select round(rand()*8) into @var;
69 insert into d6.t6 values (@var);
70 create table d6.t5 (a int);
71 select round(rand()*8) into @var;
72 insert into d6.t5 values (@var);
73 create table d6.t4 (a int);
74 select round(rand()*8) into @var;
75 insert into d6.t4 values (@var);
76 create table d6.t3 (a int);
77 select round(rand()*8) into @var;
78 insert into d6.t3 values (@var);
79 create table d6.t2 (a int);
80 select round(rand()*8) into @var;
81 insert into d6.t2 values (@var);
82 create table d6.t1 (a int);
83 select round(rand()*8) into @var;
84 insert into d6.t1 values (@var);
85 create database d5;
86 create table d5.t8 (a int);
87 select round(rand()*8) into @var;
88 insert into d5.t8 values (@var);
89 create table d5.t7 (a int);
90 select round(rand()*8) into @var;
91 insert into d5.t7 values (@var);
92 create table d5.t6 (a int);
93 select round(rand()*8) into @var;
94 insert into d5.t6 values (@var);
95 create table d5.t5 (a int);
96 select round(rand()*8) into @var;
97 insert into d5.t5 values (@var);
98 create table d5.t4 (a int);
99 select round(rand()*8) into @var;
100 insert into d5.t4 values (@var);
101 create table d5.t3 (a int);
102 select round(rand()*8) into @var;
103 insert into d5.t3 values (@var);
104 create table d5.t2 (a int);
105 select round(rand()*8) into @var;
106 insert into d5.t2 values (@var);
107 create table d5.t1 (a int);
108 select round(rand()*8) into @var;
109 insert into d5.t1 values (@var);
110 create database d4;
111 create table d4.t8 (a int);
112 select round(rand()*8) into @var;
113 insert into d4.t8 values (@var);
114 create table d4.t7 (a int);
115 select round(rand()*8) into @var;
116 insert into d4.t7 values (@var);
117 create table d4.t6 (a int);
118 select round(rand()*8) into @var;
119 insert into d4.t6 values (@var);
120 create table d4.t5 (a int);
121 select round(rand()*8) into @var;
122 insert into d4.t5 values (@var);
123 create table d4.t4 (a int);
124 select round(rand()*8) into @var;
125 insert into d4.t4 values (@var);
126 create table d4.t3 (a int);
127 select round(rand()*8) into @var;
128 insert into d4.t3 values (@var);
129 create table d4.t2 (a int);
130 select round(rand()*8) into @var;
131 insert into d4.t2 values (@var);
132 create table d4.t1 (a int);
133 select round(rand()*8) into @var;
134 insert into d4.t1 values (@var);
135 create database d3;
136 create table d3.t8 (a int);
137 select round(rand()*8) into @var;
138 insert into d3.t8 values (@var);
139 create table d3.t7 (a int);
140 select round(rand()*8) into @var;
141 insert into d3.t7 values (@var);
142 create table d3.t6 (a int);
143 select round(rand()*8) into @var;
144 insert into d3.t6 values (@var);
145 create table d3.t5 (a int);
146 select round(rand()*8) into @var;
147 insert into d3.t5 values (@var);
148 create table d3.t4 (a int);
149 select round(rand()*8) into @var;
150 insert into d3.t4 values (@var);
151 create table d3.t3 (a int);
152 select round(rand()*8) into @var;
153 insert into d3.t3 values (@var);
154 create table d3.t2 (a int);
155 select round(rand()*8) into @var;
156 insert into d3.t2 values (@var);
157 create table d3.t1 (a int);
158 select round(rand()*8) into @var;
159 insert into d3.t1 values (@var);
160 create database d2;
161 create table d2.t8 (a int);
162 select round(rand()*8) into @var;
163 insert into d2.t8 values (@var);
164 create table d2.t7 (a int);
165 select round(rand()*8) into @var;
166 insert into d2.t7 values (@var);
167 create table d2.t6 (a int);
168 select round(rand()*8) into @var;
169 insert into d2.t6 values (@var);
170 create table d2.t5 (a int);
171 select round(rand()*8) into @var;
172 insert into d2.t5 values (@var);
173 create table d2.t4 (a int);
174 select round(rand()*8) into @var;
175 insert into d2.t4 values (@var);
176 create table d2.t3 (a int);
177 select round(rand()*8) into @var;
178 insert into d2.t3 values (@var);
179 create table d2.t2 (a int);
180 select round(rand()*8) into @var;
181 insert into d2.t2 values (@var);
182 create table d2.t1 (a int);
183 select round(rand()*8) into @var;
184 insert into d2.t1 values (@var);
185 create database d1;
186 create table d1.t8 (a int);
187 select round(rand()*8) into @var;
188 insert into d1.t8 values (@var);
189 create table d1.t7 (a int);
190 select round(rand()*8) into @var;
191 insert into d1.t7 values (@var);
192 create table d1.t6 (a int);
193 select round(rand()*8) into @var;
194 insert into d1.t6 values (@var);
195 create table d1.t5 (a int);
196 select round(rand()*8) into @var;
197 insert into d1.t5 values (@var);
198 create table d1.t4 (a int);
199 select round(rand()*8) into @var;
200 insert into d1.t4 values (@var);
201 create table d1.t3 (a int);
202 select round(rand()*8) into @var;
203 insert into d1.t3 values (@var);
204 create table d1.t2 (a int);
205 select round(rand()*8) into @var;
206 insert into d1.t2 values (@var);
207 create table d1.t1 (a int);
208 select round(rand()*8) into @var;
209 insert into d1.t1 values (@var);
210 include/sync_slave_sql_with_master.inc
211 include/sync_slave_sql_with_master.inc
212 include/sync_slave_sql_with_master.inc
213 include/diff_tables.inc [master:d8.t8, slave:d8.t8]
214 include/diff_tables.inc [master:d8.t7, slave:d8.t7]
215 include/diff_tables.inc [master:d8.t6, slave:d8.t6]
216 include/diff_tables.inc [master:d8.t5, slave:d8.t5]
217 include/diff_tables.inc [master:d8.t4, slave:d8.t4]
218 include/diff_tables.inc [master:d8.t3, slave:d8.t3]
219 include/diff_tables.inc [master:d8.t2, slave:d8.t2]
220 include/diff_tables.inc [master:d8.t1, slave:d8.t1]
221 include/diff_tables.inc [master:d7.t8, slave:d7.t8]
222 include/diff_tables.inc [master:d7.t7, slave:d7.t7]
223 include/diff_tables.inc [master:d7.t6, slave:d7.t6]
224 include/diff_tables.inc [master:d7.t5, slave:d7.t5]
225 include/diff_tables.inc [master:d7.t4, slave:d7.t4]
226 include/diff_tables.inc [master:d7.t3, slave:d7.t3]
227 include/diff_tables.inc [master:d7.t2, slave:d7.t2]
228 include/diff_tables.inc [master:d7.t1, slave:d7.t1]
229 include/diff_tables.inc [master:d6.t8, slave:d6.t8]
230 include/diff_tables.inc [master:d6.t7, slave:d6.t7]
231 include/diff_tables.inc [master:d6.t6, slave:d6.t6]
232 include/diff_tables.inc [master:d6.t5, slave:d6.t5]
233 include/diff_tables.inc [master:d6.t4, slave:d6.t4]
234 include/diff_tables.inc [master:d6.t3, slave:d6.t3]
235 include/diff_tables.inc [master:d6.t2, slave:d6.t2]
236 include/diff_tables.inc [master:d6.t1, slave:d6.t1]
237 include/diff_tables.inc [master:d5.t8, slave:d5.t8]
238 include/diff_tables.inc [master:d5.t7, slave:d5.t7]
239 include/diff_tables.inc [master:d5.t6, slave:d5.t6]
240 include/diff_tables.inc [master:d5.t5, slave:d5.t5]
241 include/diff_tables.inc [master:d5.t4, slave:d5.t4]
242 include/diff_tables.inc [master:d5.t3, slave:d5.t3]
243 include/diff_tables.inc [master:d5.t2, slave:d5.t2]
244 include/diff_tables.inc [master:d5.t1, slave:d5.t1]
245 include/diff_tables.inc [master:d4.t8, slave:d4.t8]
246 include/diff_tables.inc [master:d4.t7, slave:d4.t7]
247 include/diff_tables.inc [master:d4.t6, slave:d4.t6]
248 include/diff_tables.inc [master:d4.t5, slave:d4.t5]
249 include/diff_tables.inc [master:d4.t4, slave:d4.t4]
250 include/diff_tables.inc [master:d4.t3, slave:d4.t3]
251 include/diff_tables.inc [master:d4.t2, slave:d4.t2]
252 include/diff_tables.inc [master:d4.t1, slave:d4.t1]
253 include/diff_tables.inc [master:d3.t8, slave:d3.t8]
254 include/diff_tables.inc [master:d3.t7, slave:d3.t7]
255 include/diff_tables.inc [master:d3.t6, slave:d3.t6]
256 include/diff_tables.inc [master:d3.t5, slave:d3.t5]
257 include/diff_tables.inc [master:d3.t4, slave:d3.t4]
258 include/diff_tables.inc [master:d3.t3, slave:d3.t3]
259 include/diff_tables.inc [master:d3.t2, slave:d3.t2]
260 include/diff_tables.inc [master:d3.t1, slave:d3.t1]
261 include/diff_tables.inc [master:d2.t8, slave:d2.t8]
262 include/diff_tables.inc [master:d2.t7, slave:d2.t7]
263 include/diff_tables.inc [master:d2.t6, slave:d2.t6]
264 include/diff_tables.inc [master:d2.t5, slave:d2.t5]
265 include/diff_tables.inc [master:d2.t4, slave:d2.t4]
266 include/diff_tables.inc [master:d2.t3, slave:d2.t3]
267 include/diff_tables.inc [master:d2.t2, slave:d2.t2]
268 include/diff_tables.inc [master:d2.t1, slave:d2.t1]
269 include/diff_tables.inc [master:d1.t8, slave:d1.t8]
270 include/diff_tables.inc [master:d1.t7, slave:d1.t7]
271 include/diff_tables.inc [master:d1.t6, slave:d1.t6]
272 include/diff_tables.inc [master:d1.t5, slave:d1.t5]
273 include/diff_tables.inc [master:d1.t4, slave:d1.t4]
274 include/diff_tables.inc [master:d1.t3, slave:d1.t3]
275 include/diff_tables.inc [master:d1.t2, slave:d1.t2]
276 include/diff_tables.inc [master:d1.t1, slave:d1.t1]
277 include/sync_slave_sql_with_master.inc
278 create database d20;
279 create table d20.t1 (a int);
280 select round(rand()*8) into @var;
281 insert into d20.t1 values (@var);
282 create database d19;
283 create table d19.t1 (a int);
284 select round(rand()*8) into @var;
285 insert into d19.t1 values (@var);
286 create database d18;
287 create table d18.t1 (a int);
288 select round(rand()*8) into @var;
289 insert into d18.t1 values (@var);
290 create database d17;
291 create table d17.t1 (a int);
292 select round(rand()*8) into @var;
293 insert into d17.t1 values (@var);
294 create database d16;
295 create table d16.t1 (a int);
296 select round(rand()*8) into @var;
297 insert into d16.t1 values (@var);
298 create database d15;
299 create table d15.t1 (a int);
300 select round(rand()*8) into @var;
301 insert into d15.t1 values (@var);
302 create database d14;
303 create table d14.t1 (a int);
304 select round(rand()*8) into @var;
305 insert into d14.t1 values (@var);
306 create database d13;
307 create table d13.t1 (a int);
308 select round(rand()*8) into @var;
309 insert into d13.t1 values (@var);
310 create database d12;
311 create table d12.t1 (a int);
312 select round(rand()*8) into @var;
313 insert into d12.t1 values (@var);
314 create database d11;
315 create table d11.t1 (a int);
316 select round(rand()*8) into @var;
317 insert into d11.t1 values (@var);
318 create database d10;
319 create table d10.t1 (a int);
320 select round(rand()*8) into @var;
321 insert into d10.t1 values (@var);
322 create database d9;
323 create table d9.t1 (a int);
324 select round(rand()*8) into @var;
325 insert into d9.t1 values (@var);
326 create database d8;
327 create table d8.t1 (a int);
328 select round(rand()*8) into @var;
329 insert into d8.t1 values (@var);
330 create database d7;
331 create table d7.t1 (a int);
332 select round(rand()*8) into @var;
333 insert into d7.t1 values (@var);
334 create database d6;
335 create table d6.t1 (a int);
336 select round(rand()*8) into @var;
337 insert into d6.t1 values (@var);
338 create database d5;
339 create table d5.t1 (a int);
340 select round(rand()*8) into @var;
341 insert into d5.t1 values (@var);
342 create database d4;
343 create table d4.t1 (a int);
344 select round(rand()*8) into @var;
345 insert into d4.t1 values (@var);
346 create database d3;
347 create table d3.t1 (a int);
348 select round(rand()*8) into @var;
349 insert into d3.t1 values (@var);
350 create database d2;
351 create table d2.t1 (a int);
352 select round(rand()*8) into @var;
353 insert into d2.t1 values (@var);
354 create database d1;
355 create table d1.t1 (a int);
356 select round(rand()*8) into @var;
357 insert into d1.t1 values (@var);
358 include/sync_slave_sql_with_master.inc
359 include/diff_tables.inc [master:d20.t1, slave:d20.t1]
360 include/diff_tables.inc [master:d19.t1, slave:d19.t1]
361 include/diff_tables.inc [master:d18.t1, slave:d18.t1]
362 include/diff_tables.inc [master:d17.t1, slave:d17.t1]
363 include/diff_tables.inc [master:d16.t1, slave:d16.t1]
364 include/diff_tables.inc [master:d15.t1, slave:d15.t1]
365 include/diff_tables.inc [master:d14.t1, slave:d14.t1]
366 include/diff_tables.inc [master:d13.t1, slave:d13.t1]
367 include/diff_tables.inc [master:d12.t1, slave:d12.t1]
368 include/diff_tables.inc [master:d11.t1, slave:d11.t1]
369 include/diff_tables.inc [master:d10.t1, slave:d10.t1]
370 include/diff_tables.inc [master:d9.t1, slave:d9.t1]
371 include/diff_tables.inc [master:d8.t1, slave:d8.t1]
372 include/diff_tables.inc [master:d7.t1, slave:d7.t1]
373 include/diff_tables.inc [master:d6.t1, slave:d6.t1]
374 include/diff_tables.inc [master:d5.t1, slave:d5.t1]
375 include/diff_tables.inc [master:d4.t1, slave:d4.t1]
376 include/diff_tables.inc [master:d3.t1, slave:d3.t1]
377 include/diff_tables.inc [master:d2.t1, slave:d2.t1]
378 include/diff_tables.inc [master:d1.t1, slave:d1.t1]
379 include/sync_slave_sql_with_master.inc
380 set @@global.replica_parallel_workers= @save.replica_parallel_workers;
381 include/rpl_end.inc