Debian Codegraph @

mysql-test/suite/ndb/t/ndb_fragment_count.inc

raw
1 #
2 # test fragment creation
3 #
4 #
5 create table t1
6 (a bigint, b bigint, c bigint, d bigint,
7 primary key (a,b,c,d))
8 engine=ndb;
9 insert into t1 values
10 (1,2,3,4),(2,3,4,5),(3,4,5,6),
11 (3,2,3,4),(1,3,4,5),(2,4,5,6),
12 (1,2,3,5),(2,3,4,8),(3,4,5,9),
13 (3,2,3,5),(1,3,4,8),(2,4,5,9),
14 (1,2,3,6),(2,3,4,6),(3,4,5,7),
15 (3,2,3,6),(1,3,4,6),(2,4,5,7),
16 (1,2,3,7),(2,3,4,7),(3,4,5,8),
17 (3,2,3,7),(1,3,4,7),(2,4,5,8),
18 (1,3,3,4),(2,4,4,5),(3,5,5,6),
19 (3,3,3,4),(1,4,4,5),(2,5,5,6),
20 (1,3,3,5),(2,4,4,8),(3,5,5,9),
21 (3,3,3,5),(1,4,4,8),(2,5,5,9),
22 (1,3,3,6),(2,4,4,6),(3,5,5,7),
23 (3,3,3,6),(1,4,4,6),(2,5,5,7),
24 (1,3,3,7),(2,4,4,7),(3,5,5,8),
25 (3,3,3,7),(1,4,4,7),(2,5,5,8);
26
27 select count(*) into @cnt_start
28 from information_schema.partitions
29 where table_schema = 'test' and table_name = 't1';
30
31 # block_instance is a bit unstable, since we are using
32 # PARTITION_BALANCE=FOR_RA_BY_NODE for the table the first fragment can end up
33 # a bit anywhere depending on the PartitionsPerNode, NoOfReplicas and
34 # number of LDMs used. To avoid issues running the tests multiple times
35 # we are now using two queries. First one to show the fragment distribution
36 # across nodes and second to count the number of fragments per LDM. (The number
37 # of fragments per ldm should never differ by more than one.
38
39 select node_id, fragment_num from ndbinfo.memory_per_fragment
40 where fq_name = 'test/def/t1' order by node_id, fragment_num;
41
42 select count(*) as cnt from ndbinfo.memory_per_fragment
43 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
44
45 alter table t1 algorithm=copy,
46 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
47
48 select count(*) into @cnt_one_per_ldm_per_node
49 from information_schema.partitions
50 where table_schema = 'test' and table_name = 't1';
51
52 select count(*) as cnt from ndbinfo.memory_per_fragment
53 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
54
55 select node_id, fragment_num from ndbinfo.memory_per_fragment
56 where fq_name = 'test/def/t1' order by node_id, fragment_num;
57
58 select count(*) as cnt from ndbinfo.memory_per_fragment
59 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
60
61 alter table t1 algorithm=copy,
62 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM";
63
64 select count(*) into @cnt_one_per_ldm_per_nodegroup
65 from information_schema.partitions
66 where table_schema = 'test' and table_name = 't1';
67
68 select node_id, fragment_num from ndbinfo.memory_per_fragment
69 where fq_name = 'test/def/t1' order by node_id, fragment_num;
70
71 select count(*) as cnt from ndbinfo.memory_per_fragment
72 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
73
74 alter table t1 algorithm=copy,
75 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
76
77 select count(*) into @cnt_one_per_node
78 from information_schema.partitions
79 where table_schema = 'test' and table_name = 't1';
80
81 select node_id, fragment_num from ndbinfo.memory_per_fragment
82 where fq_name = 'test/def/t1' order by node_id, fragment_num;
83
84 select count(*) as cnt from ndbinfo.memory_per_fragment
85 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
86
87 alter table t1 algorithm=copy,
88 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
89 select count(*) into @cnt_one_per_nodegroup
90 from information_schema.partitions
91 where table_schema = 'test' and table_name = 't1';
92
93 select node_id, fragment_num from ndbinfo.memory_per_fragment
94 where fq_name = 'test/def/t1' order by node_id, fragment_num;
95
96 select count(*) as cnt from ndbinfo.memory_per_fragment
97 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
98
99 drop table t1;
100
101 select @cnt_start = @cnt_one_per_ldm_per_node;
102 select @cnt_one_per_ldm_per_node > @cnt_one_per_ldm_per_nodegroup;
103 select @cnt_one_per_ldm_per_node > @cnt_one_per_node;
104 select @cnt_one_per_nodegroup <= @cnt_one_per_ldm_per_nodegroup;
105 select @cnt_one_per_nodegroup = 1;
106
107 ###
108 #
109 # Test online alter table
110 #
111 create table t1 (a bigint, b bigint, c bigint, d bigint, primary key (a,b,c,d))
112 engine=ndb;
113
114 select node_id, fragment_num from ndbinfo.memory_per_fragment
115 where fq_name = 'test/def/t1' order by node_id, fragment_num;
116
117 select count(*) as cnt from ndbinfo.memory_per_fragment
118 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
119
120 create table t2 (a bigint, b bigint, c bigint, d bigint, primary key (a,b,c,d))
121 engine=ndb comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
122
123 select node_id, fragment_num from ndbinfo.memory_per_fragment
124 where fq_name = 'test/def/t2' order by node_id, fragment_num;
125
126 select count(*) as cnt from ndbinfo.memory_per_fragment
127 where fq_name = 'test/def/t2' group by node_id, block_instance order by cnt desc;
128
129 create table t3 (a bigint, b bigint, c bigint, d bigint, primary key (a,b,c,d))
130 engine=ndb comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM";
131
132 select node_id, fragment_num from ndbinfo.memory_per_fragment
133 where fq_name = 'test/def/t3' order by node_id, fragment_num;
134
135 select count(*) as cnt from ndbinfo.memory_per_fragment
136 where fq_name = 'test/def/t3' group by node_id, block_instance order by cnt desc;
137
138 create table t4 (a bigint, b bigint, c bigint, d bigint, primary key (a,b,c,d))
139 engine=ndb comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
140
141 select node_id, fragment_num from ndbinfo.memory_per_fragment
142 where fq_name = 'test/def/t4' order by node_id, fragment_num;
143
144 select count(*) as cnt from ndbinfo.memory_per_fragment
145 where fq_name = 'test/def/t4' group by node_id, block_instance order by cnt desc;
146
147 create table t5 (a bigint, b bigint, c bigint, d bigint, primary key (a,b,c,d))
148 engine=ndb comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
149 select node_id, fragment_num from ndbinfo.memory_per_fragment
150 where fq_name = 'test/def/t5' order by node_id, fragment_num;
151
152 select count(*) as cnt from ndbinfo.memory_per_fragment
153 where fq_name = 'test/def/t5' group by node_id, block_instance order by cnt desc;
154
155 select count(*) into @cnt_t1_0
156 from information_schema.partitions
157 where table_schema = 'test' and table_name = 't1';
158
159 select count(*) into @cnt_t2_0
160 from information_schema.partitions
161 where table_schema = 'test' and table_name = 't2';
162
163 select count(*) into @cnt_t3_0
164 from information_schema.partitions
165 where table_schema = 'test' and table_name = 't3';
166
167 select count(*) into @cnt_t4_0
168 from information_schema.partitions
169 where table_schema = 'test' and table_name = 't4';
170
171 select count(*) into @cnt_t5_0
172 from information_schema.partitions
173 where table_schema = 'test' and table_name = 't5';
174
175 ##
176 #
177 # reorganize partitions work for PARTITION_BALANCE
178 # but should do nothing in these cases
179 #
180 alter table t1 algorithm=inplace, reorganize partition;
181 select node_id, fragment_num from ndbinfo.memory_per_fragment
182 where fq_name = 'test/def/t1' order by node_id, fragment_num;
183
184 select count(*) as cnt from ndbinfo.memory_per_fragment
185 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
186
187 alter table t2 algorithm=inplace, reorganize partition;
188 select node_id, fragment_num from ndbinfo.memory_per_fragment
189 where fq_name = 'test/def/t2' order by node_id, fragment_num;
190
191 select count(*) as cnt from ndbinfo.memory_per_fragment
192 where fq_name = 'test/def/t2' group by node_id, block_instance order by cnt desc;
193
194 alter table t3 algorithm=inplace, reorganize partition;
195 select node_id, fragment_num from ndbinfo.memory_per_fragment
196 where fq_name = 'test/def/t3' order by node_id, fragment_num;
197
198 select count(*) as cnt from ndbinfo.memory_per_fragment
199 where fq_name = 'test/def/t3' group by node_id, block_instance order by cnt desc;
200
201 alter table t4 algorithm=inplace, reorganize partition;
202 select node_id, fragment_num from ndbinfo.memory_per_fragment
203 where fq_name = 'test/def/t4' order by node_id, fragment_num;
204
205 select count(*) as cnt from ndbinfo.memory_per_fragment
206 where fq_name = 'test/def/t4' group by node_id, block_instance order by cnt desc;
207
208 alter table t5 algorithm=inplace, reorganize partition;
209 select node_id, fragment_num from ndbinfo.memory_per_fragment
210 where fq_name = 'test/def/t5' order by node_id, fragment_num;
211
212 select count(*) as cnt from ndbinfo.memory_per_fragment
213 where fq_name = 'test/def/t5' group by node_id, block_instance order by cnt desc;
214
215 select count(*) into @cnt_t1_1
216 from information_schema.partitions
217 where table_schema = 'test' and table_name = 't1';
218
219 select count(*) into @cnt_t2_1
220 from information_schema.partitions
221 where table_schema = 'test' and table_name = 't2';
222
223 select count(*) into @cnt_t3_1
224 from information_schema.partitions
225 where table_schema = 'test' and table_name = 't3';
226
227 select count(*) into @cnt_t4_1
228 from information_schema.partitions
229 where table_schema = 'test' and table_name = 't4';
230
231 select count(*) into @cnt_t5_1
232 from information_schema.partitions
233 where table_schema = 'test' and table_name = 't5';
234
235 select @cnt_t1_0 = @cnt_t1_1;
236 select @cnt_t2_0 = @cnt_t2_1;
237 select @cnt_t3_0 = @cnt_t3_1;
238 select @cnt_t4_0 = @cnt_t4_1;
239 select @cnt_t5_0 = @cnt_t5_1;
240
241 ##
242 #
243 # but add partition does not!
244 #
245 alter table t1 algorithm=inplace, add partition partitions 1;
246 select node_id, fragment_num from ndbinfo.memory_per_fragment
247 where fq_name = 'test/def/t1' order by node_id, fragment_num;
248
249 select count(*) as cnt from ndbinfo.memory_per_fragment
250 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
251
252 alter table t2 algorithm=inplace, add partition partitions 1;
253 select node_id, fragment_num from ndbinfo.memory_per_fragment
254 where fq_name = 'test/def/t2' order by node_id, fragment_num;
255
256 select count(*) as cnt from ndbinfo.memory_per_fragment
257 where fq_name = 'test/def/t2' group by node_id, block_instance order by cnt desc;
258
259 alter table t3 algorithm=inplace, add partition partitions 1;
260 select node_id, fragment_num from ndbinfo.memory_per_fragment
261 where fq_name = 'test/def/t3' order by node_id, fragment_num;
262
263 select count(*) as cnt from ndbinfo.memory_per_fragment
264 where fq_name = 'test/def/t3' group by node_id, block_instance order by cnt desc;
265
266 alter table t4 algorithm=inplace, add partition partitions 1;
267 select node_id, fragment_num from ndbinfo.memory_per_fragment
268 where fq_name = 'test/def/t4' order by node_id, fragment_num;
269
270 select count(*) as cnt from ndbinfo.memory_per_fragment
271 where fq_name = 'test/def/t4' group by node_id, block_instance order by cnt desc;
272
273 alter table t5 algorithm=inplace, add partition partitions 1;
274 select node_id, fragment_num from ndbinfo.memory_per_fragment
275 where fq_name = 'test/def/t5' order by node_id, fragment_num;
276
277 select count(*) as cnt from ndbinfo.memory_per_fragment
278 where fq_name = 'test/def/t5' group by node_id, block_instance order by cnt desc;
279
280 select count(*) into @cnt_t1_2
281 from information_schema.partitions
282 where table_schema = 'test' and table_name = 't1';
283
284 select count(*) into @cnt_t2_2
285 from information_schema.partitions
286 where table_schema = 'test' and table_name = 't2';
287
288 select count(*) into @cnt_t3_2
289 from information_schema.partitions
290 where table_schema = 'test' and table_name = 't3';
291
292 select count(*) into @cnt_t4_2
293 from information_schema.partitions
294 where table_schema = 'test' and table_name = 't4';
295
296 select count(*) into @cnt_t5_2
297 from information_schema.partitions
298 where table_schema = 'test' and table_name = 't5';
299
300 select @cnt_t1_2;
301 select @cnt_t2_2;
302 select @cnt_t3_2;
303 select @cnt_t4_2;
304 select @cnt_t5_2;
305
306 select @cnt_t1_0 < @cnt_t1_2;
307 select @cnt_t2_0 < @cnt_t2_2;
308 select @cnt_t3_0 < @cnt_t3_2;
309 select @cnt_t4_0 < @cnt_t4_2;
310 select @cnt_t5_0 < @cnt_t5_2;
311
312 drop table t1, t2, t3, t4, t5;
313
314 create table t1 (a int primary key) engine ndb
315 COMMENT="NDB_TABLE=NOLOGGING=1";
316 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
317 alter table t1 algorithm=inplace,
318 COMMENT="NDB_TABLE=NOLOGGING=0";
319 drop table t1;
320
321 ##
322 #
323 # to add partitions to t2, we can go from low number to a high number.
324 create table t1 (a bigint, b bigint, c bigint, d bigint, primary key (a,b,c,d))
325 engine=ndb comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
326 alter table t1 algorithm=inplace,
327 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
328
329 select count(*) into @cnt_t1_3
330 from information_schema.partitions
331 where table_schema = 'test' and table_name = 't1';
332
333 select @cnt_t1_0 = @cnt_t1_3;
334 #alter table t1 algorithm=inplace, add partition partitions 1;
335
336 select count(*) into @cnt_t1_4
337 from information_schema.partitions
338 where table_schema = 'test' and table_name = 't1';
339
340 select @cnt_t1_0 < @cnt_t1_4;
341
342 drop table t1;
343
344 create table t1 (a bigint, b bigint, c bigint, d bigint, primary key (a,b,c,d))
345 engine=ndb comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
346
347 --error ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
348 alter table t1 algorithm=inplace,
349 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
350
351 alter table t1 algorithm=copy,
352 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE,NOLOGGING=1";
353 select node_id, fragment_num from ndbinfo.memory_per_fragment
354 where fq_name = 'test/def/t1' order by node_id, fragment_num;
355
356 select count(*) as cnt from ndbinfo.memory_per_fragment
357 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
358
359 show create table t1;
360
361 alter table t1 algorithm=inplace,
362 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
363 select node_id, fragment_num from ndbinfo.memory_per_fragment
364 where fq_name = 'test/def/t1' order by node_id, fragment_num;
365
366 select count(*) as cnt from ndbinfo.memory_per_fragment
367 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
368
369 select count(*) into @cnt_t1_5
370 from information_schema.partitions
371 where table_schema = 'test' and table_name = 't1';
372
373 select @cnt_t1_5;
374
375 show create table t1;
376
377 alter table t1 algorithm=inplace,
378 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM";
379 select node_id, fragment_num from ndbinfo.memory_per_fragment
380 where fq_name = 'test/def/t1' order by node_id, fragment_num;
381
382 select count(*) as cnt from ndbinfo.memory_per_fragment
383 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
384
385 select count(*) into @cnt_t1_6
386 from information_schema.partitions
387 where table_schema = 'test' and table_name = 't1';
388
389 select @cnt_t1_6;
390
391 show create table t1;
392
393 alter table t1 algorithm=inplace,
394 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
395 select node_id, fragment_num from ndbinfo.memory_per_fragment
396 where fq_name = 'test/def/t1' order by node_id, fragment_num;
397
398 select count(*) as cnt from ndbinfo.memory_per_fragment
399 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
400
401 select count(*) into @cnt_t1_7
402 from information_schema.partitions
403 where table_schema = 'test' and table_name = 't1';
404
405 select @cnt_t1_7;
406
407 show create table t1;
408 let $ndb_describe_table=t1;
409 source suite/ndb/include/ndb_describe_table.inc;
410
411 drop table t1;
412
413 #Verify that it isn't possible to create no logging table with disk fields
414 --error ER_ILLEGAL_HA_CREATE_OPTION
415 create table t1 (a bigint primary key, b bigint storage disk) engine ndb
416 comment="NDB_TABLE=NOLOGGING=1";
417 show warnings;
418
419 #Verify that unique indexes gets also correct partition balance
420 create table t2 (a bigint primary key, b bigint unique) engine ndb
421 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
422 select node_id, fragment_num from ndbinfo.memory_per_fragment
423 where fq_name = 'test/def/t2' order by node_id, fragment_num;
424
425 select count(*) as cnt from ndbinfo.memory_per_fragment
426 where fq_name = 'test/def/t2' group by node_id, block_instance order by cnt desc;
427
428 select node_id, fragment_num from ndbinfo.memory_per_fragment
429 where fq_name like '%unique' order by node_id, fragment_num;
430
431 select count(*) as cnt from ndbinfo.memory_per_fragment
432 where fq_name = 'test/def/t2' group by node_id, block_instance order by cnt desc;
433
434 #Verify that unique indexes gets also correct partition balance also after
435 #alter table with copy algorithm
436 alter table t2 algorithm=copy,
437 COMMENT="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
438 select node_id, fragment_num from ndbinfo.memory_per_fragment
439 where fq_name = 'test/def/t2' order by node_id, fragment_num;
440
441 select count(*) as cnt from ndbinfo.memory_per_fragment
442 where fq_name = 'test/def/t2' group by node_id, block_instance order by cnt desc;
443
444 select node_id, fragment_num from ndbinfo.memory_per_fragment
445 where fq_name like '%unique' order by node_id, fragment_num;
446
447 select count(*) as cnt from ndbinfo.memory_per_fragment
448 where fq_name = 'test/def/t2' group by node_id, block_instance order by cnt desc;
449
450 drop table t2;
451
452 #Verify that unique indexes gets also correct partition balance also after
453 #alter table with inplace algorithm. In fact it doesn't since unique indexes
454 #are not reorganised as part of ALTER TABLE reorg, this is a known bug that
455 #should be fixed.
456 create table t2 (a bigint primary key, b bigint unique) engine ndb
457 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
458 alter table t2 algorithm=inplace,
459 COMMENT="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
460 select node_id, fragment_num from ndbinfo.memory_per_fragment
461 where fq_name = 'test/def/t2' order by node_id, fragment_num;
462
463 select count(*) as cnt from ndbinfo.memory_per_fragment
464 where fq_name = 'test/def/t2' group by node_id, block_instance order by cnt desc;
465
466 select node_id, fragment_num from ndbinfo.memory_per_fragment
467 where fq_name like '%unique' order by node_id, fragment_num;
468
469 select count(*) as cnt from ndbinfo.memory_per_fragment
470 where fq_name like '%unique' group by node_id, block_instance order by cnt desc;
471
472 drop table t2;
473
474 #A few tests with READ_BACKUP flag set
475 create table t1 (a bigint primary key, b bigint unique) engine ndb
476 comment="NDB_TABLE=READ_BACKUP=1";
477 show create table t1;
478 select node_id, fragment_num from ndbinfo.memory_per_fragment
479 where fq_name = 'test/def/t1' order by node_id, fragment_num;
480
481 select count(*) as cnt from ndbinfo.memory_per_fragment
482 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
483
484 select node_id, fragment_num from ndbinfo.memory_per_fragment
485 where fq_name like '%unique' order by node_id, fragment_num;
486
487 select count(*) as cnt from ndbinfo.memory_per_fragment
488 where fq_name like '%unique' group by node_id, block_instance order by cnt desc;
489
490 alter table t1 algorithm=inplace,
491 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
492 show create table t1;
493 select node_id, fragment_num from ndbinfo.memory_per_fragment
494 where fq_name = 'test/def/t1' order by node_id, fragment_num;
495
496 select count(*) as cnt from ndbinfo.memory_per_fragment
497 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
498
499 select node_id, fragment_num from ndbinfo.memory_per_fragment
500 where fq_name like '%unique' order by node_id, fragment_num;
501
502 select count(*) as cnt from ndbinfo.memory_per_fragment
503 where fq_name like '%unique' group by node_id, block_instance order by cnt desc;
504
505 drop table t1;
506 create table t1 (a bigint primary key, b bigint unique) engine ndb;
507 select node_id, fragment_num from ndbinfo.memory_per_fragment
508 where fq_name = 'test/def/t1' order by node_id, fragment_num;
509
510 select count(*) as cnt from ndbinfo.memory_per_fragment
511 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
512
513 alter table t1 algorithm=copy,
514 COMMENT="NDB_TABLE=READ_BACKUP=1";
515 select node_id, fragment_num from ndbinfo.memory_per_fragment
516 where fq_name = 'test/def/t1' order by node_id, fragment_num;
517
518 select count(*) as cnt from ndbinfo.memory_per_fragment
519 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
520
521 drop table t1;
522
523 create table t1 (a bigint primary key) engine ndb
524 partition by key();
525 select node_id, fragment_num from ndbinfo.memory_per_fragment
526 where fq_name = 'test/def/t1' order by node_id, fragment_num;
527
528 select count(*) as cnt from ndbinfo.memory_per_fragment
529 where fq_name = 'test/def/t1' group by node_id, block_instance order by cnt desc;
530
531 drop table t1;
532
533 create table t1 (a bigint primary key) engine ndb
534 comment="NDB_TABLE=READ_BACKUP=0"
535 partition by key();
536 alter table t1 algorithm=inplace, comment="NDB_TABLE=READ_BACKUP=1";
537 alter table t1 algorithm=inplace, comment="NDB_TABLE=READ_BACKUP=1";
538 alter table t1 algorithm=inplace, comment="NDB_TABLE=READ_BACKUP=0";
539 alter table t1 algorithm=inplace, comment="NDB_TABLE=READ_BACKUP=0";
540 drop table t1;