Debian Codegraph @

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

raw
1 TRUNCATE TABLE test_innodb_stats;
2 SELECT 'dummy INSERT, the table should be empty';
3 dummy INSERT, the table should be empty
4 dummy INSERT, the table should be empty
5 ANALYZE TABLE test_innodb_stats;
6 Table Op Msg_type Msg_text
7 test.test_innodb_stats analyze status OK
8 SELECT
9 stat_name,
10 stat_value,
11 sample_size,
12 stat_description
13 FROM mysql.innodb_index_stats
14 WHERE
15 database_name = DATABASE() AND
16 table_name = 'test_innodb_stats' AND
17 index_name = 'a_key' AND
18 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
19 ORDER BY stat_name;
20 stat_name n_diff_pfx01
21 stat_value 0
22 sample_size 1
23 stat_description a
24 stat_name n_diff_pfx02
25 stat_value 0
26 sample_size 1
27 stat_description a,DB_ROW_ID
28 stat_name n_leaf_pages
29 stat_value 1
30 sample_size NULL
31 stat_description Number of leaf pages in the index
32 stat_name size
33 stat_value 1
34 sample_size NULL
35 stat_description Number of pages in the index
36 FLUSH TABLE test_innodb_stats;
37 SELECT * FROM information_schema.statistics
38 WHERE table_name = 'test_innodb_stats';
39 TABLE_CATALOG def
40 TABLE_SCHEMA test
41 TABLE_NAME test_innodb_stats
42 NON_UNIQUE 1
43 INDEX_SCHEMA test
44 INDEX_NAME a_key
45 SEQ_IN_INDEX 1
46 COLUMN_NAME a
47 COLLATION A
48 CARDINALITY 0
49 SUB_PART NULL
50 PACKED NULL
51 NULLABLE YES
52 INDEX_TYPE BTREE
53 COMMENT
54 INDEX_COMMENT
55 IS_VISIBLE YES
56 EXPRESSION NULL
57 TRUNCATE TABLE test_innodb_stats;
58 INSERT INTO test_innodb_stats (a) VALUES (1);
59 ANALYZE TABLE test_innodb_stats;
60 Table Op Msg_type Msg_text
61 test.test_innodb_stats analyze status OK
62 SELECT
63 stat_name,
64 stat_value,
65 sample_size,
66 stat_description
67 FROM mysql.innodb_index_stats
68 WHERE
69 database_name = DATABASE() AND
70 table_name = 'test_innodb_stats' AND
71 index_name = 'a_key' AND
72 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
73 ORDER BY stat_name;
74 stat_name n_diff_pfx01
75 stat_value 1
76 sample_size 1
77 stat_description a
78 stat_name n_diff_pfx02
79 stat_value 1
80 sample_size 1
81 stat_description a,DB_ROW_ID
82 stat_name n_leaf_pages
83 stat_value 1
84 sample_size NULL
85 stat_description Number of leaf pages in the index
86 stat_name size
87 stat_value 1
88 sample_size NULL
89 stat_description Number of pages in the index
90 FLUSH TABLE test_innodb_stats;
91 SELECT * FROM information_schema.statistics
92 WHERE table_name = 'test_innodb_stats';
93 TABLE_CATALOG def
94 TABLE_SCHEMA test
95 TABLE_NAME test_innodb_stats
96 NON_UNIQUE 1
97 INDEX_SCHEMA test
98 INDEX_NAME a_key
99 SEQ_IN_INDEX 1
100 COLUMN_NAME a
101 COLLATION A
102 CARDINALITY 1
103 SUB_PART NULL
104 PACKED NULL
105 NULLABLE YES
106 INDEX_TYPE BTREE
107 COMMENT
108 INDEX_COMMENT
109 IS_VISIBLE YES
110 EXPRESSION NULL
111 TRUNCATE TABLE test_innodb_stats;
112 INSERT INTO test_innodb_stats (a) VALUES (1), (1);
113 ANALYZE TABLE test_innodb_stats;
114 Table Op Msg_type Msg_text
115 test.test_innodb_stats analyze status OK
116 SELECT
117 stat_name,
118 stat_value,
119 sample_size,
120 stat_description
121 FROM mysql.innodb_index_stats
122 WHERE
123 database_name = DATABASE() AND
124 table_name = 'test_innodb_stats' AND
125 index_name = 'a_key' AND
126 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
127 ORDER BY stat_name;
128 stat_name n_diff_pfx01
129 stat_value 1
130 sample_size 1
131 stat_description a
132 stat_name n_diff_pfx02
133 stat_value 2
134 sample_size 1
135 stat_description a,DB_ROW_ID
136 stat_name n_leaf_pages
137 stat_value 1
138 sample_size NULL
139 stat_description Number of leaf pages in the index
140 stat_name size
141 stat_value 1
142 sample_size NULL
143 stat_description Number of pages in the index
144 FLUSH TABLE test_innodb_stats;
145 SELECT * FROM information_schema.statistics
146 WHERE table_name = 'test_innodb_stats';
147 TABLE_CATALOG def
148 TABLE_SCHEMA test
149 TABLE_NAME test_innodb_stats
150 NON_UNIQUE 1
151 INDEX_SCHEMA test
152 INDEX_NAME a_key
153 SEQ_IN_INDEX 1
154 COLUMN_NAME a
155 COLLATION A
156 CARDINALITY 1
157 SUB_PART NULL
158 PACKED NULL
159 NULLABLE YES
160 INDEX_TYPE BTREE
161 COMMENT
162 INDEX_COMMENT
163 IS_VISIBLE YES
164 EXPRESSION NULL
165 TRUNCATE TABLE test_innodb_stats;
166 INSERT INTO test_innodb_stats (a) VALUES (1), (1), (1);
167 ANALYZE TABLE test_innodb_stats;
168 Table Op Msg_type Msg_text
169 test.test_innodb_stats analyze status OK
170 SELECT
171 stat_name,
172 stat_value,
173 sample_size,
174 stat_description
175 FROM mysql.innodb_index_stats
176 WHERE
177 database_name = DATABASE() AND
178 table_name = 'test_innodb_stats' AND
179 index_name = 'a_key' AND
180 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
181 ORDER BY stat_name;
182 stat_name n_diff_pfx01
183 stat_value 1
184 sample_size 1
185 stat_description a
186 stat_name n_diff_pfx02
187 stat_value 3
188 sample_size 1
189 stat_description a,DB_ROW_ID
190 stat_name n_leaf_pages
191 stat_value 1
192 sample_size NULL
193 stat_description Number of leaf pages in the index
194 stat_name size
195 stat_value 1
196 sample_size NULL
197 stat_description Number of pages in the index
198 FLUSH TABLE test_innodb_stats;
199 SELECT * FROM information_schema.statistics
200 WHERE table_name = 'test_innodb_stats';
201 TABLE_CATALOG def
202 TABLE_SCHEMA test
203 TABLE_NAME test_innodb_stats
204 NON_UNIQUE 1
205 INDEX_SCHEMA test
206 INDEX_NAME a_key
207 SEQ_IN_INDEX 1
208 COLUMN_NAME a
209 COLLATION A
210 CARDINALITY 1
211 SUB_PART NULL
212 PACKED NULL
213 NULLABLE YES
214 INDEX_TYPE BTREE
215 COMMENT
216 INDEX_COMMENT
217 IS_VISIBLE YES
218 EXPRESSION NULL
219 TRUNCATE TABLE test_innodb_stats;
220 INSERT INTO test_innodb_stats (a) VALUES (1), (1), (1), (1), (1), (1), (1), (1), (1), (1);
221 ANALYZE TABLE test_innodb_stats;
222 Table Op Msg_type Msg_text
223 test.test_innodb_stats analyze status OK
224 SELECT
225 stat_name,
226 stat_value,
227 sample_size,
228 stat_description
229 FROM mysql.innodb_index_stats
230 WHERE
231 database_name = DATABASE() AND
232 table_name = 'test_innodb_stats' AND
233 index_name = 'a_key' AND
234 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
235 ORDER BY stat_name;
236 stat_name n_diff_pfx01
237 stat_value 1
238 sample_size 1
239 stat_description a
240 stat_name n_diff_pfx02
241 stat_value 10
242 sample_size 1
243 stat_description a,DB_ROW_ID
244 stat_name n_leaf_pages
245 stat_value 1
246 sample_size NULL
247 stat_description Number of leaf pages in the index
248 stat_name size
249 stat_value 1
250 sample_size NULL
251 stat_description Number of pages in the index
252 FLUSH TABLE test_innodb_stats;
253 SELECT * FROM information_schema.statistics
254 WHERE table_name = 'test_innodb_stats';
255 TABLE_CATALOG def
256 TABLE_SCHEMA test
257 TABLE_NAME test_innodb_stats
258 NON_UNIQUE 1
259 INDEX_SCHEMA test
260 INDEX_NAME a_key
261 SEQ_IN_INDEX 1
262 COLUMN_NAME a
263 COLLATION A
264 CARDINALITY 1
265 SUB_PART NULL
266 PACKED NULL
267 NULLABLE YES
268 INDEX_TYPE BTREE
269 COMMENT
270 INDEX_COMMENT
271 IS_VISIBLE YES
272 EXPRESSION NULL
273 TRUNCATE TABLE test_innodb_stats;
274 INSERT INTO test_innodb_stats (a) VALUES (1), (2);
275 ANALYZE TABLE test_innodb_stats;
276 Table Op Msg_type Msg_text
277 test.test_innodb_stats analyze status OK
278 SELECT
279 stat_name,
280 stat_value,
281 sample_size,
282 stat_description
283 FROM mysql.innodb_index_stats
284 WHERE
285 database_name = DATABASE() AND
286 table_name = 'test_innodb_stats' AND
287 index_name = 'a_key' AND
288 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
289 ORDER BY stat_name;
290 stat_name n_diff_pfx01
291 stat_value 2
292 sample_size 1
293 stat_description a
294 stat_name n_diff_pfx02
295 stat_value 2
296 sample_size 1
297 stat_description a,DB_ROW_ID
298 stat_name n_leaf_pages
299 stat_value 1
300 sample_size NULL
301 stat_description Number of leaf pages in the index
302 stat_name size
303 stat_value 1
304 sample_size NULL
305 stat_description Number of pages in the index
306 FLUSH TABLE test_innodb_stats;
307 SELECT * FROM information_schema.statistics
308 WHERE table_name = 'test_innodb_stats';
309 TABLE_CATALOG def
310 TABLE_SCHEMA test
311 TABLE_NAME test_innodb_stats
312 NON_UNIQUE 1
313 INDEX_SCHEMA test
314 INDEX_NAME a_key
315 SEQ_IN_INDEX 1
316 COLUMN_NAME a
317 COLLATION A
318 CARDINALITY 2
319 SUB_PART NULL
320 PACKED NULL
321 NULLABLE YES
322 INDEX_TYPE BTREE
323 COMMENT
324 INDEX_COMMENT
325 IS_VISIBLE YES
326 EXPRESSION NULL
327 TRUNCATE TABLE test_innodb_stats;
328 INSERT INTO test_innodb_stats (a) VALUES (1), (1), (2);
329 ANALYZE TABLE test_innodb_stats;
330 Table Op Msg_type Msg_text
331 test.test_innodb_stats analyze status OK
332 SELECT
333 stat_name,
334 stat_value,
335 sample_size,
336 stat_description
337 FROM mysql.innodb_index_stats
338 WHERE
339 database_name = DATABASE() AND
340 table_name = 'test_innodb_stats' AND
341 index_name = 'a_key' AND
342 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
343 ORDER BY stat_name;
344 stat_name n_diff_pfx01
345 stat_value 2
346 sample_size 1
347 stat_description a
348 stat_name n_diff_pfx02
349 stat_value 3
350 sample_size 1
351 stat_description a,DB_ROW_ID
352 stat_name n_leaf_pages
353 stat_value 1
354 sample_size NULL
355 stat_description Number of leaf pages in the index
356 stat_name size
357 stat_value 1
358 sample_size NULL
359 stat_description Number of pages in the index
360 FLUSH TABLE test_innodb_stats;
361 SELECT * FROM information_schema.statistics
362 WHERE table_name = 'test_innodb_stats';
363 TABLE_CATALOG def
364 TABLE_SCHEMA test
365 TABLE_NAME test_innodb_stats
366 NON_UNIQUE 1
367 INDEX_SCHEMA test
368 INDEX_NAME a_key
369 SEQ_IN_INDEX 1
370 COLUMN_NAME a
371 COLLATION A
372 CARDINALITY 2
373 SUB_PART NULL
374 PACKED NULL
375 NULLABLE YES
376 INDEX_TYPE BTREE
377 COMMENT
378 INDEX_COMMENT
379 IS_VISIBLE YES
380 EXPRESSION NULL
381 TRUNCATE TABLE test_innodb_stats;
382 INSERT INTO test_innodb_stats (a) VALUES (1), (2), (3);
383 ANALYZE TABLE test_innodb_stats;
384 Table Op Msg_type Msg_text
385 test.test_innodb_stats analyze status OK
386 SELECT
387 stat_name,
388 stat_value,
389 sample_size,
390 stat_description
391 FROM mysql.innodb_index_stats
392 WHERE
393 database_name = DATABASE() AND
394 table_name = 'test_innodb_stats' AND
395 index_name = 'a_key' AND
396 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
397 ORDER BY stat_name;
398 stat_name n_diff_pfx01
399 stat_value 3
400 sample_size 1
401 stat_description a
402 stat_name n_diff_pfx02
403 stat_value 3
404 sample_size 1
405 stat_description a,DB_ROW_ID
406 stat_name n_leaf_pages
407 stat_value 1
408 sample_size NULL
409 stat_description Number of leaf pages in the index
410 stat_name size
411 stat_value 1
412 sample_size NULL
413 stat_description Number of pages in the index
414 FLUSH TABLE test_innodb_stats;
415 SELECT * FROM information_schema.statistics
416 WHERE table_name = 'test_innodb_stats';
417 TABLE_CATALOG def
418 TABLE_SCHEMA test
419 TABLE_NAME test_innodb_stats
420 NON_UNIQUE 1
421 INDEX_SCHEMA test
422 INDEX_NAME a_key
423 SEQ_IN_INDEX 1
424 COLUMN_NAME a
425 COLLATION A
426 CARDINALITY 3
427 SUB_PART NULL
428 PACKED NULL
429 NULLABLE YES
430 INDEX_TYPE BTREE
431 COMMENT
432 INDEX_COMMENT
433 IS_VISIBLE YES
434 EXPRESSION NULL
435 TRUNCATE TABLE test_innodb_stats;
436 INSERT INTO test_innodb_stats (a) VALUES (1), (1), (2), (3), (3);
437 ANALYZE TABLE test_innodb_stats;
438 Table Op Msg_type Msg_text
439 test.test_innodb_stats analyze status OK
440 SELECT
441 stat_name,
442 stat_value,
443 sample_size,
444 stat_description
445 FROM mysql.innodb_index_stats
446 WHERE
447 database_name = DATABASE() AND
448 table_name = 'test_innodb_stats' AND
449 index_name = 'a_key' AND
450 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
451 ORDER BY stat_name;
452 stat_name n_diff_pfx01
453 stat_value 3
454 sample_size 1
455 stat_description a
456 stat_name n_diff_pfx02
457 stat_value 5
458 sample_size 1
459 stat_description a,DB_ROW_ID
460 stat_name n_leaf_pages
461 stat_value 1
462 sample_size NULL
463 stat_description Number of leaf pages in the index
464 stat_name size
465 stat_value 1
466 sample_size NULL
467 stat_description Number of pages in the index
468 FLUSH TABLE test_innodb_stats;
469 SELECT * FROM information_schema.statistics
470 WHERE table_name = 'test_innodb_stats';
471 TABLE_CATALOG def
472 TABLE_SCHEMA test
473 TABLE_NAME test_innodb_stats
474 NON_UNIQUE 1
475 INDEX_SCHEMA test
476 INDEX_NAME a_key
477 SEQ_IN_INDEX 1
478 COLUMN_NAME a
479 COLLATION A
480 CARDINALITY 3
481 SUB_PART NULL
482 PACKED NULL
483 NULLABLE YES
484 INDEX_TYPE BTREE
485 COMMENT
486 INDEX_COMMENT
487 IS_VISIBLE YES
488 EXPRESSION NULL
489 TRUNCATE TABLE test_innodb_stats;
490 INSERT INTO test_innodb_stats (a) VALUES (1), (2), (3), (4), (5), (1), (2), (3), (4), (5);
491 ANALYZE TABLE test_innodb_stats;
492 Table Op Msg_type Msg_text
493 test.test_innodb_stats analyze status OK
494 SELECT
495 stat_name,
496 stat_value,
497 sample_size,
498 stat_description
499 FROM mysql.innodb_index_stats
500 WHERE
501 database_name = DATABASE() AND
502 table_name = 'test_innodb_stats' AND
503 index_name = 'a_key' AND
504 stat_name IN ('n_diff_pfx01', 'n_diff_pfx02', 'n_leaf_pages', 'size')
505 ORDER BY stat_name;
506 stat_name n_diff_pfx01
507 stat_value 5
508 sample_size 1
509 stat_description a
510 stat_name n_diff_pfx02
511 stat_value 10
512 sample_size 1
513 stat_description a,DB_ROW_ID
514 stat_name n_leaf_pages
515 stat_value 1
516 sample_size NULL
517 stat_description Number of leaf pages in the index
518 stat_name size
519 stat_value 1
520 sample_size NULL
521 stat_description Number of pages in the index
522 FLUSH TABLE test_innodb_stats;
523 SELECT * FROM information_schema.statistics
524 WHERE table_name = 'test_innodb_stats';
525 TABLE_CATALOG def
526 TABLE_SCHEMA test
527 TABLE_NAME test_innodb_stats
528 NON_UNIQUE 1
529 INDEX_SCHEMA test
530 INDEX_NAME a_key
531 SEQ_IN_INDEX 1
532 COLUMN_NAME a
533 COLLATION A
534 CARDINALITY 5
535 SUB_PART NULL
536 PACKED NULL
537 NULLABLE YES
538 INDEX_TYPE BTREE
539 COMMENT
540 INDEX_COMMENT
541 IS_VISIBLE YES
542 EXPRESSION NULL