Debian Codegraph @

mysql-test/suite/innodb_fts/r/phrase_search_perf.result

raw
1 CREATE TABLE `t` (
2 `id` INT NOT NULL AUTO_INCREMENT,
3 `a` VARCHAR(90),
4 `b` INT DEFAULT 1,
5 PRIMARY KEY (`id`),
6 FULLTEXT KEY (`a`)
7 ) ENGINE=InnoDB;
8 CREATE PROCEDURE expand_data(repeat_count INT)
9 BEGIN
10 DECLARE i INT DEFAULT 0;
11 WHILE i < repeat_count DO
12 INSERT INTO t (a)
13 SELECT a FROM t;
14 SET i = i + 1;
15 END WHILE;
16 END |
17 INSERT INTO t (a) VALUES
18 ('amet consectetur adipiscing lorem ipsum'),
19 ('amet consectetur adipiscing ipsum lorem'),
20 ('amet consectetur lorem adipiscing ipsum'),
21 ('amet consectetur lorem ipsum adipiscing'),
22 ('amet consectetur ipsum adipiscing lorem'),
23 ('amet consectetur ipsum lorem adipiscing'),
24 ('amet adipiscing consectetur lorem ipsum'),
25 ('amet adipiscing consectetur ipsum lorem'),
26 ('amet adipiscing lorem consectetur ipsum'),
27 ('amet adipiscing lorem ipsum consectetur'),
28 ('amet adipiscing ipsum consectetur lorem'),
29 ('amet adipiscing ipsum lorem consectetur'),
30 ('amet lorem consectetur adipiscing ipsum'),
31 ('amet lorem consectetur ipsum adipiscing'),
32 ('amet lorem adipiscing consectetur ipsum'),
33 ('amet lorem adipiscing ipsum consectetur'),
34 ('amet lorem ipsum consectetur adipiscing'),
35 ('amet lorem ipsum adipiscing consectetur'),
36 ('amet ipsum consectetur adipiscing lorem'),
37 ('amet ipsum consectetur lorem adipiscing'),
38 ('amet ipsum adipiscing consectetur lorem'),
39 ('amet ipsum adipiscing lorem consectetur'),
40 ('amet ipsum lorem consectetur adipiscing'),
41 ('amet ipsum lorem adipiscing consectetur'),
42 ('consectetur amet adipiscing lorem ipsum'),
43 ('consectetur amet adipiscing ipsum lorem'),
44 ('consectetur amet lorem adipiscing ipsum'),
45 ('consectetur amet lorem ipsum adipiscing'),
46 ('consectetur amet ipsum adipiscing lorem'),
47 ('consectetur amet ipsum lorem adipiscing'),
48 ('consectetur adipiscing amet lorem ipsum'),
49 ('consectetur adipiscing amet ipsum lorem'),
50 ('consectetur adipiscing lorem amet ipsum'),
51 ('consectetur adipiscing lorem ipsum amet'),
52 ('consectetur adipiscing ipsum amet lorem'),
53 ('consectetur adipiscing ipsum lorem amet'),
54 ('consectetur lorem amet adipiscing ipsum'),
55 ('consectetur lorem amet ipsum adipiscing'),
56 ('consectetur lorem adipiscing amet ipsum'),
57 ('consectetur lorem adipiscing ipsum amet'),
58 ('consectetur lorem ipsum amet adipiscing'),
59 ('consectetur lorem ipsum adipiscing amet'),
60 ('consectetur ipsum amet adipiscing lorem'),
61 ('consectetur ipsum amet lorem adipiscing'),
62 ('consectetur ipsum adipiscing amet lorem'),
63 ('consectetur ipsum adipiscing lorem amet'),
64 ('consectetur ipsum lorem amet adipiscing'),
65 ('consectetur ipsum lorem adipiscing amet'),
66 ('adipiscing amet consectetur lorem ipsum'),
67 ('adipiscing amet consectetur ipsum lorem'),
68 ('adipiscing amet lorem consectetur ipsum'),
69 ('adipiscing amet lorem ipsum consectetur'),
70 ('adipiscing amet ipsum consectetur lorem'),
71 ('adipiscing amet ipsum lorem consectetur'),
72 ('adipiscing consectetur amet lorem ipsum'),
73 ('adipiscing consectetur amet ipsum lorem'),
74 ('adipiscing consectetur lorem amet ipsum'),
75 ('adipiscing consectetur lorem ipsum amet'),
76 ('adipiscing consectetur ipsum amet lorem'),
77 ('adipiscing consectetur ipsum lorem amet'),
78 ('adipiscing lorem amet consectetur ipsum'),
79 ('adipiscing lorem amet ipsum consectetur'),
80 ('adipiscing lorem consectetur amet ipsum'),
81 ('adipiscing lorem consectetur ipsum amet'),
82 ('adipiscing lorem ipsum amet consectetur'),
83 ('adipiscing lorem ipsum consectetur amet'),
84 ('adipiscing ipsum amet consectetur lorem'),
85 ('adipiscing ipsum amet lorem consectetur'),
86 ('adipiscing ipsum consectetur amet lorem'),
87 ('adipiscing ipsum consectetur lorem amet'),
88 ('adipiscing ipsum lorem amet consectetur'),
89 ('adipiscing ipsum lorem consectetur amet'),
90 ('lorem amet consectetur adipiscing ipsum'),
91 ('lorem amet consectetur ipsum adipiscing'),
92 ('lorem amet adipiscing consectetur ipsum'),
93 ('lorem amet adipiscing ipsum consectetur'),
94 ('lorem amet ipsum consectetur adipiscing'),
95 ('lorem amet ipsum adipiscing consectetur'),
96 ('lorem consectetur amet adipiscing ipsum'),
97 ('lorem consectetur amet ipsum adipiscing'),
98 ('lorem consectetur adipiscing amet ipsum'),
99 ('lorem consectetur adipiscing ipsum amet'),
100 ('lorem consectetur ipsum amet adipiscing'),
101 ('lorem consectetur ipsum adipiscing amet'),
102 ('lorem adipiscing amet consectetur ipsum'),
103 ('lorem adipiscing amet ipsum consectetur'),
104 ('lorem adipiscing consectetur amet ipsum'),
105 ('lorem adipiscing consectetur ipsum amet'),
106 ('lorem adipiscing ipsum amet consectetur'),
107 ('lorem adipiscing ipsum consectetur amet'),
108 ('lorem ipsum amet consectetur adipiscing'),
109 ('lorem ipsum amet adipiscing consectetur'),
110 ('lorem ipsum consectetur amet adipiscing'),
111 ('lorem ipsum consectetur adipiscing amet'),
112 ('lorem ipsum adipiscing amet consectetur'),
113 ('lorem ipsum adipiscing consectetur amet'),
114 ('ipsum amet consectetur adipiscing lorem'),
115 ('ipsum amet consectetur lorem adipiscing'),
116 ('ipsum amet adipiscing consectetur lorem'),
117 ('ipsum amet adipiscing lorem consectetur'),
118 ('ipsum amet lorem consectetur adipiscing'),
119 ('ipsum amet lorem adipiscing consectetur'),
120 ('ipsum consectetur amet adipiscing lorem'),
121 ('ipsum consectetur amet lorem adipiscing'),
122 ('ipsum consectetur adipiscing amet lorem'),
123 ('ipsum consectetur adipiscing lorem amet'),
124 ('ipsum consectetur lorem amet adipiscing'),
125 ('ipsum consectetur lorem adipiscing amet'),
126 ('ipsum adipiscing amet consectetur lorem'),
127 ('ipsum adipiscing amet lorem consectetur'),
128 ('ipsum adipiscing consectetur amet lorem'),
129 ('ipsum adipiscing consectetur lorem amet'),
130 ('ipsum adipiscing lorem amet consectetur'),
131 ('ipsum adipiscing lorem consectetur amet'),
132 ('ipsum lorem amet consectetur adipiscing'),
133 ('ipsum lorem amet adipiscing consectetur'),
134 ('ipsum lorem consectetur amet adipiscing'),
135 ('ipsum lorem consectetur adipiscing amet'),
136 ('ipsum lorem adipiscing amet consectetur'),
137 ('ipsum lorem adipiscing consectetur amet');
138 INSERT INTO t (a) VALUES
139 ('amet consectetur adipiscing lorem'),
140 ('amet consectetur adipiscing ipsum'),
141 ('amet consectetur lorem adipiscing'),
142 ('amet consectetur lorem ipsum'),
143 ('amet consectetur ipsum adipiscing'),
144 ('amet consectetur ipsum lorem'),
145 ('amet adipiscing consectetur lorem'),
146 ('amet adipiscing consectetur ipsum'),
147 ('amet adipiscing lorem consectetur'),
148 ('amet adipiscing lorem ipsum'),
149 ('amet adipiscing ipsum consectetur'),
150 ('amet adipiscing ipsum lorem'),
151 ('amet lorem consectetur adipiscing'),
152 ('amet lorem consectetur ipsum'),
153 ('amet lorem adipiscing consectetur'),
154 ('amet lorem adipiscing ipsum'),
155 ('amet lorem ipsum consectetur'),
156 ('amet lorem ipsum adipiscing'),
157 ('amet ipsum consectetur adipiscing'),
158 ('amet ipsum consectetur lorem'),
159 ('amet ipsum adipiscing consectetur'),
160 ('amet ipsum adipiscing lorem'),
161 ('amet ipsum lorem consectetur'),
162 ('amet ipsum lorem adipiscing'),
163 ('consectetur amet adipiscing lorem'),
164 ('consectetur amet adipiscing ipsum'),
165 ('consectetur amet lorem adipiscing'),
166 ('consectetur amet lorem ipsum'),
167 ('consectetur amet ipsum adipiscing'),
168 ('consectetur amet ipsum lorem'),
169 ('consectetur adipiscing amet lorem'),
170 ('consectetur adipiscing amet ipsum'),
171 ('consectetur adipiscing lorem amet'),
172 ('consectetur adipiscing lorem ipsum'),
173 ('consectetur adipiscing ipsum amet'),
174 ('consectetur adipiscing ipsum lorem'),
175 ('consectetur lorem amet adipiscing'),
176 ('consectetur lorem amet ipsum'),
177 ('consectetur lorem adipiscing amet'),
178 ('consectetur lorem adipiscing ipsum'),
179 ('consectetur lorem ipsum amet'),
180 ('consectetur lorem ipsum adipiscing'),
181 ('consectetur ipsum amet adipiscing'),
182 ('consectetur ipsum amet lorem'),
183 ('consectetur ipsum adipiscing amet'),
184 ('consectetur ipsum adipiscing lorem'),
185 ('consectetur ipsum lorem amet'),
186 ('consectetur ipsum lorem adipiscing'),
187 ('adipiscing amet consectetur lorem'),
188 ('adipiscing amet consectetur ipsum'),
189 ('adipiscing amet lorem consectetur'),
190 ('adipiscing amet lorem ipsum'),
191 ('adipiscing amet ipsum consectetur'),
192 ('adipiscing amet ipsum lorem'),
193 ('adipiscing consectetur amet lorem'),
194 ('adipiscing consectetur amet ipsum'),
195 ('adipiscing consectetur lorem amet'),
196 ('adipiscing consectetur lorem ipsum'),
197 ('adipiscing consectetur ipsum amet'),
198 ('adipiscing consectetur ipsum lorem'),
199 ('adipiscing lorem amet consectetur'),
200 ('adipiscing lorem amet ipsum'),
201 ('adipiscing lorem consectetur amet'),
202 ('adipiscing lorem consectetur ipsum'),
203 ('adipiscing lorem ipsum amet'),
204 ('adipiscing lorem ipsum consectetur'),
205 ('adipiscing ipsum amet consectetur'),
206 ('adipiscing ipsum amet lorem'),
207 ('adipiscing ipsum consectetur amet'),
208 ('adipiscing ipsum consectetur lorem'),
209 ('adipiscing ipsum lorem amet'),
210 ('adipiscing ipsum lorem consectetur'),
211 ('lorem amet consectetur adipiscing'),
212 ('lorem amet consectetur ipsum'),
213 ('lorem amet adipiscing consectetur'),
214 ('lorem amet adipiscing ipsum'),
215 ('lorem amet ipsum consectetur'),
216 ('lorem amet ipsum adipiscing'),
217 ('lorem consectetur amet adipiscing'),
218 ('lorem consectetur amet ipsum'),
219 ('lorem consectetur adipiscing amet'),
220 ('lorem consectetur adipiscing ipsum'),
221 ('lorem consectetur ipsum amet'),
222 ('lorem consectetur ipsum adipiscing'),
223 ('lorem adipiscing amet consectetur'),
224 ('lorem adipiscing amet ipsum'),
225 ('lorem adipiscing consectetur amet'),
226 ('lorem adipiscing consectetur ipsum'),
227 ('lorem adipiscing ipsum amet'),
228 ('lorem adipiscing ipsum consectetur'),
229 ('lorem ipsum amet consectetur'),
230 ('lorem ipsum amet adipiscing'),
231 ('lorem ipsum consectetur amet'),
232 ('lorem ipsum consectetur adipiscing'),
233 ('lorem ipsum adipiscing amet'),
234 ('lorem ipsum adipiscing consectetur'),
235 ('ipsum amet consectetur adipiscing'),
236 ('ipsum amet consectetur lorem'),
237 ('ipsum amet adipiscing consectetur'),
238 ('ipsum amet adipiscing lorem'),
239 ('ipsum amet lorem consectetur'),
240 ('ipsum amet lorem adipiscing'),
241 ('ipsum consectetur amet adipiscing'),
242 ('ipsum consectetur amet lorem'),
243 ('ipsum consectetur adipiscing amet'),
244 ('ipsum consectetur adipiscing lorem'),
245 ('ipsum consectetur lorem amet'),
246 ('ipsum consectetur lorem adipiscing'),
247 ('ipsum adipiscing amet consectetur'),
248 ('ipsum adipiscing amet lorem'),
249 ('ipsum adipiscing consectetur amet'),
250 ('ipsum adipiscing consectetur lorem'),
251 ('ipsum adipiscing lorem amet'),
252 ('ipsum adipiscing lorem consectetur');
253 INSERT INTO t (a) VALUES
254 ('amet consectetur adipiscing'),
255 ('amet consectetur lorem'),
256 ('amet consectetur ipsum'),
257 ('amet adipiscing consectetur'),
258 ('amet adipiscing lorem'),
259 ('amet adipiscing ipsum'),
260 ('amet lorem consectetur'),
261 ('amet lorem adipiscing'),
262 ('amet lorem ipsum'),
263 ('amet ipsum consectetur'),
264 ('amet ipsum adipiscing'),
265 ('amet ipsum lorem'),
266 ('consectetur amet adipiscing'),
267 ('consectetur amet lorem'),
268 ('consectetur amet ipsum'),
269 ('consectetur adipiscing amet'),
270 ('consectetur adipiscing lorem'),
271 ('consectetur adipiscing ipsum'),
272 ('consectetur lorem amet'),
273 ('consectetur lorem adipiscing'),
274 ('consectetur lorem ipsum'),
275 ('consectetur ipsum amet'),
276 ('consectetur ipsum adipiscing'),
277 ('consectetur ipsum lorem'),
278 ('adipiscing amet consectetur'),
279 ('adipiscing amet lorem'),
280 ('adipiscing amet ipsum'),
281 ('adipiscing consectetur amet'),
282 ('adipiscing consectetur lorem'),
283 ('adipiscing consectetur ipsum'),
284 ('adipiscing lorem amet'),
285 ('adipiscing lorem consectetur'),
286 ('adipiscing lorem ipsum'),
287 ('adipiscing ipsum amet'),
288 ('adipiscing ipsum consectetur'),
289 ('adipiscing ipsum lorem'),
290 ('lorem amet consectetur'),
291 ('lorem amet adipiscing'),
292 ('lorem amet ipsum'),
293 ('lorem consectetur amet'),
294 ('lorem consectetur adipiscing'),
295 ('lorem consectetur ipsum'),
296 ('lorem adipiscing amet'),
297 ('lorem adipiscing consectetur'),
298 ('lorem adipiscing ipsum'),
299 ('lorem ipsum amet'),
300 ('lorem ipsum consectetur'),
301 ('lorem ipsum adipiscing'),
302 ('ipsum amet consectetur'),
303 ('ipsum amet adipiscing'),
304 ('ipsum amet lorem'),
305 ('ipsum consectetur amet'),
306 ('ipsum consectetur adipiscing'),
307 ('ipsum consectetur lorem'),
308 ('ipsum adipiscing amet'),
309 ('ipsum adipiscing consectetur'),
310 ('ipsum adipiscing lorem'),
311 ('ipsum lorem amet'),
312 ('ipsum lorem consectetur'),
313 ('ipsum lorem adipiscing');
314 INSERT INTO t (a) VALUES
315 ('amet consectetur'),
316 ('amet adipiscing'),
317 ('amet lorem'),
318 ('amet ipsum'),
319 ('consectetur amet'),
320 ('consectetur adipiscing'),
321 ('consectetur lorem'),
322 ('consectetur ipsum'),
323 ('adipiscing amet'),
324 ('adipiscing consectetur'),
325 ('adipiscing lorem'),
326 ('adipiscing ipsum'),
327 ('lorem amet'),
328 ('lorem consectetur'),
329 ('lorem adipiscing'),
330 ('lorem ipsum'),
331 ('ipsum amet'),
332 ('ipsum consectetur'),
333 ('ipsum adipiscing'),
334 ('ipsum lorem');
335 INSERT INTO t (a) VALUES
336 ('amet'),
337 ('consectetur'),
338 ('adipiscing'),
339 ('lorem'),
340 ('ipsum');
341 CALL expand_data(11);
342 SELECT COUNT(*) FROM t;
343 COUNT(*)
344 653312
345 SET SESSION max_execution_time=30000;
346 SELECT * FROM t WHERE MATCH(a) AGAINST (+'"amet consectetur"' IN BOOLEAN MODE) ORDER BY id LIMIT 1;
347 id a b
348 1 amet consectetur adipiscing lorem ipsum 1
349 SELECT COUNT(*) FROM t WHERE MATCH(a) AGAINST (+'"amet consectetur"' IN BOOLEAN MODE);
350 COUNT(*)
351 98304
352 SELECT * FROM t WHERE MATCH(a) AGAINST ('"amet consectetur"' IN NATURAL LANGUAGE MODE) ORDER BY id LIMIT 1;
353 id a b
354 1 amet consectetur adipiscing lorem ipsum 1
355 SELECT COUNT(*) FROM t WHERE MATCH(a) AGAINST ('"amet consectetur"' IN NATURAL LANGUAGE MODE);
356 COUNT(*)
357 98304
358 DROP PROCEDURE expand_data;
359 DROP TABLE t;