Debian Codegraph @

mysql-test/suite/ndb_big/ndb_big_addnode.result

raw
1 result_format: 2
2 connect j1,localhost,root,,test;
3 connect j2,localhost,root,,test;
4 connect j3,localhost,root,,test;
5 connect j4,localhost,root,,test;
6
7 connect ddl,localhost,root,,test,$MASTER_MYPORT1,;
8
9 connection ddl;
10
11 CREATE LOGFILE GROUP lg_1
12 ADD UNDOFILE 'undo_1.dat'
13 INITIAL_SIZE 4M
14 UNDO_BUFFER_SIZE 2M
15 ENGINE NDB;
16
17 CREATE TABLESPACE ts_1
18 ADD DATAFILE 'data_1.dat'
19 USE LOGFILE GROUP lg_1
20 INITIAL_SIZE 16M
21 ENGINE NDB;
22
23 create table t1(id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb;
24 create table t2(id int NOT NULL PRIMARY KEY, data char(8))
25 TABLESPACE ts_1 STORAGE DISK engine=ndb;
26 create table t5(id int NOT NULL PRIMARY KEY, data char(8)) max_rows=50000000 engine=ndb;
27 create table t6(id int not null primary key, val int unique key, dat blob, txt text) engine=ndb;
28
29
30
31 load data local infile 'suite/ndb/data/table_data10000.dat' into table t1 fields terminated by ' ' lines terminated by '\n';
32 load data local infile 'suite/ndb/data/table_data10000.dat' into table t2 fields terminated by ' ' lines terminated by '\n';
33 load data local infile 'suite/ndb/data/table_data10000.dat' into table t5 fields terminated by ' ' lines terminated by '\n';
34 load data local infile 'suite/ndb/data/table_data10000.dat' into table t6 fields terminated by ' ' lines terminated by '\n' ignore 9000 lines (@id, @data) set id = (@id - 9000)*10 - 9, val = (@id - 9000)*10 - 9, dat = repeat(@data, 10000), txt = repeat(@data,10000);
35
36 select count(1) as t1_part_count from information_schema.partitions where table_schema='test' and table_name='t1';
37 t1_part_count
38 8
39 select count(1) as t2_part_count from information_schema.partitions where table_schema='test' and table_name='t2';
40 t2_part_count
41 8
42 select @init_t5_part_count:= count(1) as t5_part_count from information_schema.partitions where table_schema='test' and table_name='t5';
43 t5_part_count
44 8
45 select count(1) as t6_part_count from information_schema.partitions where table_schema='test' and table_name='t6';
46 t6_part_count
47 8
48
49 connection default;
50 explain
51 select count(*)
52 from t6 join t1
53 on (t6.val = t1.id)
54 where t6.val < 25;
55 id select_type table type possible_keys key key_len ref rows Extra
56 1 SIMPLE t6 range val val 5 NULL ### Parent of 2 pushed join@1; Using where with pushed condition; Using MRR
57 1 SIMPLE t1 eq_ref PRIMARY PRIMARY 4 test.t6.val ### Child of 't6' in pushed join@1
58
59 Starting engines...
60 connection j1;
61 call updateload(300,0);
62
63 connection j2;
64 call queryload(300,2000);
65
66 connection j3;
67 call updateload(300,4000);
68
69 connection j4;
70 call queryload(300,6000);
71
72 connection default;
73
74 connection ddl;
75
76
77 ## Check details of t5 partitioning
78 FragmentCount 8
79 HashMap DEFAULT-HASHMAP-3840-8
80
81
82 ## Check details of t6 partitioning
83 FragmentCount 8
84 HashMap DEFAULT-HASHMAP-3840-8
85 FragmentCount 8
86 HashMap DEFAULT-HASHMAP-3840-8
87 FragmentCount 8
88 HashMap DEFAULT-HASHMAP-3840-8
89
90
91 ## Create nodegroup for "new" nodes
92 Nodegroup 1 created
93 ## Drop
94 Drop Node Group 1 done
95 ## and create
96 Nodegroup 1 created
97 create table t3(id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb;
98 create table t4(id int NOT NULL PRIMARY KEY, data char(8))
99 TABLESPACE ts_1 STORAGE DISK engine=ndb;
100
101 insert into t3(id, data) VALUES
102 (1,'new'), (2,'new'),(3,'new'),(4,'new'),(5,'new'),
103 (6,'new'),(7,'new'),(8,'new'),(9,'new'),(10,'new');
104 insert into t4(id, data) VALUES
105 (1,'new'), (2,'new'),(3,'new'),(4,'new'),(5,'new'),
106 (6,'new'),(7,'new'),(8,'new'),(9,'new'),(10,'new');
107
108 connection ddl;
109
110 alter table t1 algorithm=inplace, reorganize partition;
111 alter table t2 algorithm=inplace, reorganize partition;
112 alter table t5 algorithm=inplace, max_rows=300000000;
113 alter table t6 algorithm=inplace, reorganize partition;
114
115 connection default;
116 connection ddl;
117 select count(1) as t1_part_count from information_schema.partitions where table_schema='test' and table_name='t1';
118 t1_part_count
119 16
120 select count(1) as t2_part_count from information_schema.partitions where table_schema='test' and table_name='t2';
121 t2_part_count
122 16
123 select count(1) as t3_part_count from information_schema.partitions where table_schema='test' and table_name='t3';
124 t3_part_count
125 16
126 select count(1) as t4_part_count from information_schema.partitions where table_schema='test' and table_name='t4';
127 t4_part_count
128 16
129 select @reorg_t5_part_count:= count(1) as t5_part_count from information_schema.partitions where table_schema='test' and table_name='t5';
130 t5_part_count
131 16
132 select count(1) as t6_part_count from information_schema.partitions where table_schema='test' and table_name='t6';
133 t6_part_count
134 16
135
136 ## Check details of t5 partitioning
137 FragmentCount 16
138 HashMap DEFAULT-HASHMAP-3840-16
139
140
141
142 ## Simple blob usage of t6
143 select count(0) as row_count, min(abs(id)) as id_min, max(id) as id_max, sum(length(dat)) as data_length, sum(length(txt)) as text_length from t6;
144 row_count id_min id_max data_length text_length
145 1000 1 9991 29740000 29740000
146 select count(0) from t6 where val = abs(id) and (id between -4991 and -4001 or id between -991 and 9991);
147 count(0)
148 1000
149
150 ## Check details of t6 partitioning
151 FragmentCount 16
152 HashMap DEFAULT-HASHMAP-3840-16
153 FragmentCount 16
154 HashMap DEFAULT-HASHMAP-3840-16
155 FragmentCount 16
156 HashMap DEFAULT-HASHMAP-3840-16
157
158
159 HashMap DEFAULT-HASHMAP-3840-16
160 HashMap DEFAULT-HASHMAP-3840-16
161 HashMap DEFAULT-HASHMAP-3840-16
162
163
164 drop table t1,t2,t3,t4,t5,t6;
165
166 connection default;
167 connection j1;
168 connection j2;
169 connection j3;
170 connection j4;
171 connection ddl;
172
173 connection default;
174
175 disconnect j1;
176 disconnect j2;
177 disconnect j3;
178 disconnect j4;
179
180 connection default;
181
182 drop procedure queryload;
183 drop procedure updateload;
184
185 connection ddl;
186 ## Drop nodegroup with "new" nodes
187 Drop Node Group 1 done
188 ALTER TABLESPACE ts_1 DROP DATAFILE 'data_1.dat';
189 DROP TABLESPACE ts_1;
190 DROP LOGFILE GROUP lg_1 ENGINE NDB;
191 disconnect ddl;
192
193 connection default;