1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
|
call mtr.add_suppression("Cannot add field");
SET optimizer_trace_max_mem_size=1048576;
SET end_markers_in_json=off;
SET optimizer_trace="enabled=on,one_line=off";
CREATE TABLE t1 (
c1 VARCHAR(1022) NOT NULL DEFAULT '',
c2 VARCHAR(1022) NOT NULL DEFAULT '',
c3 VARCHAR(1022) NOT NULL DEFAULT '',
c4 VARCHAR(1022) NOT NULL DEFAULT '',
c5 VARCHAR(1022) NOT NULL DEFAULT '',
c6 VARCHAR(1022) NOT NULL DEFAULT '',
c7 VARCHAR(1022) NOT NULL DEFAULT '',
c8 VARCHAR(1022) NOT NULL DEFAULT '',
c9 VARCHAR(1022) NOT NULL DEFAULT '',
c10 VARCHAR(1022) NOT NULL DEFAULT '',
c11 VARCHAR(1022) NOT NULL DEFAULT '',
c12 VARCHAR(1022) NOT NULL DEFAULT '',
c13 VARCHAR(1022) NOT NULL DEFAULT '',
c14 VARCHAR(1022) NOT NULL DEFAULT '',
c15 VARCHAR(1022) NOT NULL DEFAULT '',
c16 VARCHAR(1022) NOT NULL DEFAULT '',
c17 VARCHAR(1022) NOT NULL DEFAULT '',
c18 VARCHAR(1022) NOT NULL DEFAULT '',
c19 VARCHAR(1022) NOT NULL DEFAULT '',
c20 VARCHAR(1022) NOT NULL DEFAULT '',
c21 VARCHAR(1022) NOT NULL DEFAULT '',
c22 VARCHAR(1022) NOT NULL DEFAULT '',
c23 VARCHAR(1022) NOT NULL DEFAULT '',
c24 VARCHAR(1022) NOT NULL DEFAULT '',
c25 VARCHAR(1022) NOT NULL DEFAULT '',
c26 VARCHAR(1022) NOT NULL DEFAULT '',
c27 VARCHAR(1022) NOT NULL DEFAULT '',
c28 VARCHAR(1022) NOT NULL DEFAULT '',
c29 VARCHAR(1022) NOT NULL DEFAULT '',
c30 VARCHAR(1022) NOT NULL DEFAULT '',
c31 VARCHAR(1022) NOT NULL DEFAULT '',
c32 VARCHAR(1022) NOT NULL DEFAULT '',
c33 VARCHAR(1022) NOT NULL DEFAULT '',
c34 VARCHAR(1022) NOT NULL DEFAULT '',
c35 VARCHAR(1022) NOT NULL DEFAULT '',
c36 VARCHAR(1022) NOT NULL DEFAULT '',
c37 VARCHAR(1022) NOT NULL DEFAULT '',
c38 VARCHAR(1022) NOT NULL DEFAULT '',
c39 VARCHAR(1022) NOT NULL DEFAULT '',
c40 VARCHAR(1022) NOT NULL DEFAULT '',
c41 VARCHAR(1022) NOT NULL DEFAULT '',
c42 VARCHAR(1022) NOT NULL DEFAULT '',
c43 VARCHAR(1022) NOT NULL DEFAULT '',
c44 VARCHAR(1022) NOT NULL DEFAULT '',
c45 VARCHAR(1022) NOT NULL DEFAULT '',
c46 VARCHAR(1022) NOT NULL DEFAULT '',
c47 VARCHAR(1022) NOT NULL DEFAULT '',
c48 VARCHAR(1022) NOT NULL DEFAULT '',
c49 VARCHAR(1022) NOT NULL DEFAULT '',
c50 VARCHAR(1022) NOT NULL DEFAULT '',
c51 VARCHAR(1022) NOT NULL DEFAULT '',
c52 VARCHAR(1022) NOT NULL DEFAULT '',
c53 VARCHAR(1022) NOT NULL DEFAULT '',
c54 VARCHAR(1022) NOT NULL DEFAULT '',
c55 VARCHAR(1022) NOT NULL DEFAULT '',
c56 VARCHAR(1022) NOT NULL DEFAULT '',
c57 VARCHAR(1022) NOT NULL DEFAULT '',
c58 VARCHAR(1022) NOT NULL DEFAULT '',
c59 VARCHAR(1022) NOT NULL DEFAULT '',
c60 VARCHAR(1022) NOT NULL DEFAULT '',
c61 VARCHAR(1022) NOT NULL DEFAULT '',
c62 VARCHAR(1022) NOT NULL DEFAULT '',
c63 VARCHAR(1022) NOT NULL DEFAULT '',
c64 VARCHAR(1021) NOT NULL DEFAULT ''
) ENGINE = INNODB, charset latin1;
SET @save_sort_buffer_size= @@sort_buffer_size;
SET @@sort_buffer_size = 8 + 15 * (65535 + 1022 + 8);
select * from t1 order by c1;
c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 c33 c34 c35 c36 c37 c38 c39 c40 c41 c42 c43 c44 c45 c46 c47 c48 c49 c50 c51 c52 c53 c54 c55 c56 c57 c58 c59 c60 c61 c62 c63 c64
SELECT * FROM information_schema.OPTIMIZER_TRACE;
QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
select * from t1 order by c1 {
"steps": [
{
"join_preparation": {
"select#": 1,
"steps": [
{
"expanded_query": "/* select#1 */ select `t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5`,`t1`.`c6` AS `c6`,`t1`.`c7` AS `c7`,`t1`.`c8` AS `c8`,`t1`.`c9` AS `c9`,`t1`.`c10` AS `c10`,`t1`.`c11` AS `c11`,`t1`.`c12` AS `c12`,`t1`.`c13` AS `c13`,`t1`.`c14` AS `c14`,`t1`.`c15` AS `c15`,`t1`.`c16` AS `c16`,`t1`.`c17` AS `c17`,`t1`.`c18` AS `c18`,`t1`.`c19` AS `c19`,`t1`.`c20` AS `c20`,`t1`.`c21` AS `c21`,`t1`.`c22` AS `c22`,`t1`.`c23` AS `c23`,`t1`.`c24` AS `c24`,`t1`.`c25` AS `c25`,`t1`.`c26` AS `c26`,`t1`.`c27` AS `c27`,`t1`.`c28` AS `c28`,`t1`.`c29` AS `c29`,`t1`.`c30` AS `c30`,`t1`.`c31` AS `c31`,`t1`.`c32` AS `c32`,`t1`.`c33` AS `c33`,`t1`.`c34` AS `c34`,`t1`.`c35` AS `c35`,`t1`.`c36` AS `c36`,`t1`.`c37` AS `c37`,`t1`.`c38` AS `c38`,`t1`.`c39` AS `c39`,`t1`.`c40` AS `c40`,`t1`.`c41` AS `c41`,`t1`.`c42` AS `c42`,`t1`.`c43` AS `c43`,`t1`.`c44` AS `c44`,`t1`.`c45` AS `c45`,`t1`.`c46` AS `c46`,`t1`.`c47` AS `c47`,`t1`.`c48` AS `c48`,`t1`.`c49` AS `c49`,`t1`.`c50` AS `c50`,`t1`.`c51` AS `c51`,`t1`.`c52` AS `c52`,`t1`.`c53` AS `c53`,`t1`.`c54` AS `c54`,`t1`.`c55` AS `c55`,`t1`.`c56` AS `c56`,`t1`.`c57` AS `c57`,`t1`.`c58` AS `c58`,`t1`.`c59` AS `c59`,`t1`.`c60` AS `c60`,`t1`.`c61` AS `c61`,`t1`.`c62` AS `c62`,`t1`.`c63` AS `c63`,`t1`.`c64` AS `c64` from `t1` order by `t1`.`c1`"
}
]
}
},
{
"join_optimization": {
"select#": 1,
"steps": [
{
"substitute_generated_columns": {
}
},
{
"table_dependencies": [
{
"table": "`t1`",
"row_may_be_null": false,
"map_bit": 0,
"depends_on_map_bits": [
]
}
]
},
{
"rows_estimation": [
{
"table": "`t1`",
"table_scan": {
"rows": 1,
"cost": 0.25
}
}
]
},
{
"considered_execution_plans": [
{
"plan_prefix": [
],
"table": "`t1`",
"best_access_path": {
"considered_access_paths": [
{
"rows_to_scan": 1,
"access_type": "scan",
"resulting_rows": 1,
"cost": 0.35,
"chosen": true,
"use_tmp_table": true
}
]
},
"condition_filtering_pct": 100,
"rows_for_plan": 1,
"cost_for_plan": 0.35,
"sort_cost": 1,
"new_cost_for_plan": 1.35,
"chosen": true
}
]
},
{
"attaching_conditions_to_tables": {
"original_condition": null,
"attached_conditions_computation": [
],
"attached_conditions_summary": [
{
"table": "`t1`",
"attached": null
}
]
}
},
{
"optimizing_distinct_group_by_order_by": {
"simplifying_order_by": {
"original_clause": "`t1`.`c1`",
"items": [
{
"item": "`t1`.`c1`"
}
],
"resulting_clause_is_simple": true,
"resulting_clause": "`t1`.`c1`"
}
}
},
{
"finalizing_table_conditions": [
]
},
{
"refine_plan": [
{
"table": "`t1`"
}
]
},
{
"considering_tmp_tables": [
{
"adding_sort_to_table": "t1"
}
]
}
]
}
},
{
"join_execution": {
"select#": 1,
"steps": [
{
"sorting_table": "t1",
"filesort_information": [
{
"direction": "asc",
"expression": "`t1`.`c1`"
}
],
"filesort_priority_queue_optimization": {
"usable": false,
"cause": "not applicable (no LIMIT)"
},
"filesort_execution": [
],
"filesort_summary": {
"memory_available": 998483,
"key_size": 1022,
"row_size": 66561,
"max_rows_per_buffer": 14,
"num_rows_estimate": 15,
"num_rows_found": 0,
"num_initial_chunks_spilled_to_disk": 0,
"peak_memory_used": 0,
"sort_algorithm": "none",
"sort_mode": "<fixed_sort_key, packed_additional_fields>"
}
}
]
}
}
]
} 0 0
SET @@sort_buffer_size = 8 + 15 * (65535 + 1023 + 8);
select * from t1 order by c1;
c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 c33 c34 c35 c36 c37 c38 c39 c40 c41 c42 c43 c44 c45 c46 c47 c48 c49 c50 c51 c52 c53 c54 c55 c56 c57 c58 c59 c60 c61 c62 c63 c64
SELECT * FROM information_schema.OPTIMIZER_TRACE;
QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
select * from t1 order by c1 {
"steps": [
{
"join_preparation": {
"select#": 1,
"steps": [
{
"expanded_query": "/* select#1 */ select `t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5`,`t1`.`c6` AS `c6`,`t1`.`c7` AS `c7`,`t1`.`c8` AS `c8`,`t1`.`c9` AS `c9`,`t1`.`c10` AS `c10`,`t1`.`c11` AS `c11`,`t1`.`c12` AS `c12`,`t1`.`c13` AS `c13`,`t1`.`c14` AS `c14`,`t1`.`c15` AS `c15`,`t1`.`c16` AS `c16`,`t1`.`c17` AS `c17`,`t1`.`c18` AS `c18`,`t1`.`c19` AS `c19`,`t1`.`c20` AS `c20`,`t1`.`c21` AS `c21`,`t1`.`c22` AS `c22`,`t1`.`c23` AS `c23`,`t1`.`c24` AS `c24`,`t1`.`c25` AS `c25`,`t1`.`c26` AS `c26`,`t1`.`c27` AS `c27`,`t1`.`c28` AS `c28`,`t1`.`c29` AS `c29`,`t1`.`c30` AS `c30`,`t1`.`c31` AS `c31`,`t1`.`c32` AS `c32`,`t1`.`c33` AS `c33`,`t1`.`c34` AS `c34`,`t1`.`c35` AS `c35`,`t1`.`c36` AS `c36`,`t1`.`c37` AS `c37`,`t1`.`c38` AS `c38`,`t1`.`c39` AS `c39`,`t1`.`c40` AS `c40`,`t1`.`c41` AS `c41`,`t1`.`c42` AS `c42`,`t1`.`c43` AS `c43`,`t1`.`c44` AS `c44`,`t1`.`c45` AS `c45`,`t1`.`c46` AS `c46`,`t1`.`c47` AS `c47`,`t1`.`c48` AS `c48`,`t1`.`c49` AS `c49`,`t1`.`c50` AS `c50`,`t1`.`c51` AS `c51`,`t1`.`c52` AS `c52`,`t1`.`c53` AS `c53`,`t1`.`c54` AS `c54`,`t1`.`c55` AS `c55`,`t1`.`c56` AS `c56`,`t1`.`c57` AS `c57`,`t1`.`c58` AS `c58`,`t1`.`c59` AS `c59`,`t1`.`c60` AS `c60`,`t1`.`c61` AS `c61`,`t1`.`c62` AS `c62`,`t1`.`c63` AS `c63`,`t1`.`c64` AS `c64` from `t1` order by `t1`.`c1`"
}
]
}
},
{
"join_optimization": {
"select#": 1,
"steps": [
{
"substitute_generated_columns": {
}
},
{
"table_dependencies": [
{
"table": "`t1`",
"row_may_be_null": false,
"map_bit": 0,
"depends_on_map_bits": [
]
}
]
},
{
"rows_estimation": [
{
"table": "`t1`",
"table_scan": {
"rows": 1,
"cost": 0.25
}
}
]
},
{
"considered_execution_plans": [
{
"plan_prefix": [
],
"table": "`t1`",
"best_access_path": {
"considered_access_paths": [
{
"rows_to_scan": 1,
"access_type": "scan",
"resulting_rows": 1,
"cost": 0.35,
"chosen": true,
"use_tmp_table": true
}
]
},
"condition_filtering_pct": 100,
"rows_for_plan": 1,
"cost_for_plan": 0.35,
"sort_cost": 1,
"new_cost_for_plan": 1.35,
"chosen": true
}
]
},
{
"attaching_conditions_to_tables": {
"original_condition": null,
"attached_conditions_computation": [
],
"attached_conditions_summary": [
{
"table": "`t1`",
"attached": null
}
]
}
},
{
"optimizing_distinct_group_by_order_by": {
"simplifying_order_by": {
"original_clause": "`t1`.`c1`",
"items": [
{
"item": "`t1`.`c1`"
}
],
"resulting_clause_is_simple": true,
"resulting_clause": "`t1`.`c1`"
}
}
},
{
"finalizing_table_conditions": [
]
},
{
"refine_plan": [
{
"table": "`t1`"
}
]
},
{
"considering_tmp_tables": [
{
"adding_sort_to_table": "t1"
}
]
}
]
}
},
{
"join_execution": {
"select#": 1,
"steps": [
{
"sorting_table": "t1",
"filesort_information": [
{
"direction": "asc",
"expression": "`t1`.`c1`"
}
],
"filesort_priority_queue_optimization": {
"usable": false,
"cause": "not applicable (no LIMIT)"
},
"filesort_execution": [
],
"filesort_summary": {
"memory_available": 998498,
"key_size": 1022,
"row_size": 66561,
"max_rows_per_buffer": 14,
"num_rows_estimate": 15,
"num_rows_found": 0,
"num_initial_chunks_spilled_to_disk": 0,
"peak_memory_used": 0,
"sort_algorithm": "none",
"sort_mode": "<fixed_sort_key, packed_additional_fields>"
}
}
]
}
}
]
} 0 0
SET @@sort_buffer_size = 8 + 15 * (65535 + 1024 + 8);
select * from t1 order by c1;
c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 c33 c34 c35 c36 c37 c38 c39 c40 c41 c42 c43 c44 c45 c46 c47 c48 c49 c50 c51 c52 c53 c54 c55 c56 c57 c58 c59 c60 c61 c62 c63 c64
SELECT * FROM information_schema.OPTIMIZER_TRACE;
QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
select * from t1 order by c1 {
"steps": [
{
"join_preparation": {
"select#": 1,
"steps": [
{
"expanded_query": "/* select#1 */ select `t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5`,`t1`.`c6` AS `c6`,`t1`.`c7` AS `c7`,`t1`.`c8` AS `c8`,`t1`.`c9` AS `c9`,`t1`.`c10` AS `c10`,`t1`.`c11` AS `c11`,`t1`.`c12` AS `c12`,`t1`.`c13` AS `c13`,`t1`.`c14` AS `c14`,`t1`.`c15` AS `c15`,`t1`.`c16` AS `c16`,`t1`.`c17` AS `c17`,`t1`.`c18` AS `c18`,`t1`.`c19` AS `c19`,`t1`.`c20` AS `c20`,`t1`.`c21` AS `c21`,`t1`.`c22` AS `c22`,`t1`.`c23` AS `c23`,`t1`.`c24` AS `c24`,`t1`.`c25` AS `c25`,`t1`.`c26` AS `c26`,`t1`.`c27` AS `c27`,`t1`.`c28` AS `c28`,`t1`.`c29` AS `c29`,`t1`.`c30` AS `c30`,`t1`.`c31` AS `c31`,`t1`.`c32` AS `c32`,`t1`.`c33` AS `c33`,`t1`.`c34` AS `c34`,`t1`.`c35` AS `c35`,`t1`.`c36` AS `c36`,`t1`.`c37` AS `c37`,`t1`.`c38` AS `c38`,`t1`.`c39` AS `c39`,`t1`.`c40` AS `c40`,`t1`.`c41` AS `c41`,`t1`.`c42` AS `c42`,`t1`.`c43` AS `c43`,`t1`.`c44` AS `c44`,`t1`.`c45` AS `c45`,`t1`.`c46` AS `c46`,`t1`.`c47` AS `c47`,`t1`.`c48` AS `c48`,`t1`.`c49` AS `c49`,`t1`.`c50` AS `c50`,`t1`.`c51` AS `c51`,`t1`.`c52` AS `c52`,`t1`.`c53` AS `c53`,`t1`.`c54` AS `c54`,`t1`.`c55` AS `c55`,`t1`.`c56` AS `c56`,`t1`.`c57` AS `c57`,`t1`.`c58` AS `c58`,`t1`.`c59` AS `c59`,`t1`.`c60` AS `c60`,`t1`.`c61` AS `c61`,`t1`.`c62` AS `c62`,`t1`.`c63` AS `c63`,`t1`.`c64` AS `c64` from `t1` order by `t1`.`c1`"
}
]
}
},
{
"join_optimization": {
"select#": 1,
"steps": [
{
"substitute_generated_columns": {
}
},
{
"table_dependencies": [
{
"table": "`t1`",
"row_may_be_null": false,
"map_bit": 0,
"depends_on_map_bits": [
]
}
]
},
{
"rows_estimation": [
{
"table": "`t1`",
"table_scan": {
"rows": 1,
"cost": 0.25
}
}
]
},
{
"considered_execution_plans": [
{
"plan_prefix": [
],
"table": "`t1`",
"best_access_path": {
"considered_access_paths": [
{
"rows_to_scan": 1,
"access_type": "scan",
"resulting_rows": 1,
"cost": 0.35,
"chosen": true,
"use_tmp_table": true
}
]
},
"condition_filtering_pct": 100,
"rows_for_plan": 1,
"cost_for_plan": 0.35,
"sort_cost": 1,
"new_cost_for_plan": 1.35,
"chosen": true
}
]
},
{
"attaching_conditions_to_tables": {
"original_condition": null,
"attached_conditions_computation": [
],
"attached_conditions_summary": [
{
"table": "`t1`",
"attached": null
}
]
}
},
{
"optimizing_distinct_group_by_order_by": {
"simplifying_order_by": {
"original_clause": "`t1`.`c1`",
"items": [
{
"item": "`t1`.`c1`"
}
],
"resulting_clause_is_simple": true,
"resulting_clause": "`t1`.`c1`"
}
}
},
{
"finalizing_table_conditions": [
]
},
{
"refine_plan": [
{
"table": "`t1`"
}
]
},
{
"considering_tmp_tables": [
{
"adding_sort_to_table": "t1"
}
]
}
]
}
},
{
"join_execution": {
"select#": 1,
"steps": [
{
"sorting_table": "t1",
"filesort_information": [
{
"direction": "asc",
"expression": "`t1`.`c1`"
}
],
"filesort_priority_queue_optimization": {
"usable": false,
"cause": "not applicable (no LIMIT)"
},
"filesort_execution": [
],
"filesort_summary": {
"memory_available": 998513,
"key_size": 1022,
"row_size": 66561,
"max_rows_per_buffer": 14,
"num_rows_estimate": 15,
"num_rows_found": 0,
"num_initial_chunks_spilled_to_disk": 0,
"peak_memory_used": 0,
"sort_algorithm": "none",
"sort_mode": "<fixed_sort_key, packed_additional_fields>"
}
}
]
}
}
]
} 0 0
SET @@sort_buffer_size= @save_sort_buffer_size;
DROP TABLE t1;
SET innodb_strict_mode=off;
CREATE TABLE t1 (
c1 CHAR(255) NOT NULL DEFAULT '',
c2 CHAR(255) NOT NULL DEFAULT '',
c3 CHAR(255) NOT NULL DEFAULT '',
c4 CHAR(255) NOT NULL DEFAULT '',
c5 CHAR(255) NOT NULL DEFAULT '',
c6 CHAR(255) NOT NULL DEFAULT '',
c7 CHAR(255) NOT NULL DEFAULT '',
c8 CHAR(255) NOT NULL DEFAULT '',
c9 CHAR(255) NOT NULL DEFAULT '',
c10 CHAR(255) NOT NULL DEFAULT '',
c11 CHAR(255) NOT NULL DEFAULT '',
c12 CHAR(255) NOT NULL DEFAULT '',
c13 CHAR(255) NOT NULL DEFAULT '',
c14 CHAR(255) NOT NULL DEFAULT '',
c15 CHAR(255) NOT NULL DEFAULT '',
c16 CHAR(255) NOT NULL DEFAULT '',
c17 CHAR(255) NOT NULL DEFAULT '',
c18 CHAR(255) NOT NULL DEFAULT '',
c19 CHAR(255) NOT NULL DEFAULT '',
c20 CHAR(255) NOT NULL DEFAULT '',
c21 CHAR(255) NOT NULL DEFAULT '',
c22 CHAR(255) NOT NULL DEFAULT '',
c23 CHAR(255) NOT NULL DEFAULT '',
c24 CHAR(255) NOT NULL DEFAULT '',
c25 CHAR(255) NOT NULL DEFAULT '',
c26 CHAR(255) NOT NULL DEFAULT '',
c27 CHAR(255) NOT NULL DEFAULT '',
c28 CHAR(255) NOT NULL DEFAULT '',
c29 CHAR(255) NOT NULL DEFAULT '',
c30 CHAR(255) NOT NULL DEFAULT '',
c31 CHAR(255) NOT NULL DEFAULT '',
c32 CHAR(255) NOT NULL DEFAULT '',
c33 CHAR(255) NOT NULL DEFAULT '',
c34 CHAR(255) NOT NULL DEFAULT '',
c35 CHAR(255) NOT NULL DEFAULT '',
c36 CHAR(255) NOT NULL DEFAULT '',
c37 CHAR(255) NOT NULL DEFAULT '',
c38 CHAR(255) NOT NULL DEFAULT '',
c39 CHAR(255) NOT NULL DEFAULT '',
c40 CHAR(255) NOT NULL DEFAULT '',
c41 CHAR(255) NOT NULL DEFAULT '',
c42 CHAR(255) NOT NULL DEFAULT '',
c43 CHAR(255) NOT NULL DEFAULT '',
c44 CHAR(255) NOT NULL DEFAULT '',
c45 CHAR(255) NOT NULL DEFAULT '',
c46 CHAR(255) NOT NULL DEFAULT '',
c47 CHAR(255) NOT NULL DEFAULT '',
c48 CHAR(255) NOT NULL DEFAULT '',
c49 CHAR(255) NOT NULL DEFAULT '',
c50 CHAR(255) NOT NULL DEFAULT '',
c51 CHAR(255) NOT NULL DEFAULT '',
c52 CHAR(255) NOT NULL DEFAULT '',
c53 CHAR(255) NOT NULL DEFAULT '',
c54 CHAR(255) NOT NULL DEFAULT '',
c55 CHAR(255) NOT NULL DEFAULT '',
c56 CHAR(255) NOT NULL DEFAULT '',
c57 CHAR(255) NOT NULL DEFAULT '',
c58 CHAR(255) NOT NULL DEFAULT '',
c59 CHAR(255) NOT NULL DEFAULT '',
c60 CHAR(255) NOT NULL DEFAULT '',
c61 CHAR(255) NOT NULL DEFAULT '',
c62 CHAR(255) NOT NULL DEFAULT '',
c63 CHAR(255) NOT NULL DEFAULT '',
c64 CHAR(255) NOT NULL DEFAULT '',
c65 CHAR(255) NOT NULL DEFAULT '',
c66 CHAR(255) NOT NULL DEFAULT '',
c67 CHAR(255) NOT NULL DEFAULT '',
c68 CHAR(255) NOT NULL DEFAULT '',
c69 CHAR(255) NOT NULL DEFAULT '',
c70 CHAR(255) NOT NULL DEFAULT '',
c71 CHAR(255) NOT NULL DEFAULT '',
c72 CHAR(255) NOT NULL DEFAULT '',
c73 CHAR(255) NOT NULL DEFAULT '',
c74 CHAR(255) NOT NULL DEFAULT '',
c75 CHAR(255) NOT NULL DEFAULT '',
c76 CHAR(255) NOT NULL DEFAULT '',
c77 CHAR(255) NOT NULL DEFAULT '',
c78 CHAR(255) NOT NULL DEFAULT '',
c79 CHAR(255) NOT NULL DEFAULT '',
c80 CHAR(255) NOT NULL DEFAULT '',
c81 CHAR(255) NOT NULL DEFAULT '',
c82 CHAR(255) NOT NULL DEFAULT '',
c83 CHAR(255) NOT NULL DEFAULT '',
c84 CHAR(255) NOT NULL DEFAULT '',
c85 CHAR(255) NOT NULL DEFAULT '',
c86 CHAR(255) NOT NULL DEFAULT '',
c87 CHAR(255) NOT NULL DEFAULT '',
c88 CHAR(255) NOT NULL DEFAULT '',
c89 CHAR(255) NOT NULL DEFAULT '',
c90 CHAR(255) NOT NULL DEFAULT '',
c91 CHAR(255) NOT NULL DEFAULT '',
c92 CHAR(255) NOT NULL DEFAULT '',
c93 CHAR(255) NOT NULL DEFAULT '',
c94 CHAR(255) NOT NULL DEFAULT '',
c95 CHAR(255) NOT NULL DEFAULT '',
c96 CHAR(255) NOT NULL DEFAULT '',
c97 CHAR(255) NOT NULL DEFAULT '',
c98 CHAR(255) NOT NULL DEFAULT '',
c99 CHAR(255) NOT NULL DEFAULT '',
c100 CHAR(255) NOT NULL DEFAULT '',
c101 CHAR(255) NOT NULL DEFAULT '',
c102 CHAR(255) NOT NULL DEFAULT '',
c103 CHAR(255) NOT NULL DEFAULT '',
c104 CHAR(255) NOT NULL DEFAULT '',
c105 CHAR(255) NOT NULL DEFAULT '',
c106 CHAR(255) NOT NULL DEFAULT '',
c107 CHAR(255) NOT NULL DEFAULT '',
c108 CHAR(255) NOT NULL DEFAULT '',
c109 CHAR(255) NOT NULL DEFAULT '',
c110 CHAR(255) NOT NULL DEFAULT '',
c111 CHAR(255) NOT NULL DEFAULT '',
c112 CHAR(255) NOT NULL DEFAULT '',
c113 CHAR(255) NOT NULL DEFAULT '',
c114 CHAR(255) NOT NULL DEFAULT '',
c115 CHAR(255) NOT NULL DEFAULT '',
c116 CHAR(255) NOT NULL DEFAULT '',
c117 CHAR(255) NOT NULL DEFAULT '',
c118 CHAR(255) NOT NULL DEFAULT '',
c119 CHAR(255) NOT NULL DEFAULT '',
c120 CHAR(255) NOT NULL DEFAULT '',
c121 CHAR(255) NOT NULL DEFAULT '',
c122 CHAR(255) NOT NULL DEFAULT '',
c123 CHAR(255) NOT NULL DEFAULT '',
c124 CHAR(255) NOT NULL DEFAULT '',
c125 CHAR(255) NOT NULL DEFAULT '',
c126 CHAR(255) NOT NULL DEFAULT '',
c127 CHAR(255) NOT NULL DEFAULT '',
c128 CHAR(255) NOT NULL DEFAULT '',
c129 CHAR(255) NOT NULL DEFAULT '',
c130 CHAR(255) NOT NULL DEFAULT '',
c131 CHAR(255) NOT NULL DEFAULT '',
c132 CHAR(255) NOT NULL DEFAULT '',
c133 CHAR(255) NOT NULL DEFAULT '',
c134 CHAR(255) NOT NULL DEFAULT '',
c135 CHAR(255) NOT NULL DEFAULT '',
c136 CHAR(255) NOT NULL DEFAULT '',
c137 CHAR(255) NOT NULL DEFAULT '',
c138 CHAR(255) NOT NULL DEFAULT '',
c139 CHAR(255) NOT NULL DEFAULT '',
c140 CHAR(255) NOT NULL DEFAULT '',
c141 CHAR(255) NOT NULL DEFAULT '',
c142 CHAR(255) NOT NULL DEFAULT '',
c143 CHAR(255) NOT NULL DEFAULT '',
c144 CHAR(255) NOT NULL DEFAULT '',
c145 CHAR(255) NOT NULL DEFAULT '',
c146 CHAR(255) NOT NULL DEFAULT '',
c147 CHAR(255) NOT NULL DEFAULT '',
c148 CHAR(255) NOT NULL DEFAULT '',
c149 CHAR(255) NOT NULL DEFAULT '',
c150 CHAR(255) NOT NULL DEFAULT '',
c151 CHAR(255) NOT NULL DEFAULT '',
c152 CHAR(255) NOT NULL DEFAULT '',
c153 CHAR(255) NOT NULL DEFAULT '',
c154 CHAR(255) NOT NULL DEFAULT '',
c155 CHAR(255) NOT NULL DEFAULT '',
c156 CHAR(255) NOT NULL DEFAULT '',
c157 CHAR(255) NOT NULL DEFAULT '',
c158 CHAR(255) NOT NULL DEFAULT '',
c159 CHAR(255) NOT NULL DEFAULT '',
c160 CHAR(255) NOT NULL DEFAULT '',
c161 CHAR(255) NOT NULL DEFAULT '',
c162 CHAR(255) NOT NULL DEFAULT '',
c163 CHAR(255) NOT NULL DEFAULT '',
c164 CHAR(255) NOT NULL DEFAULT '',
c165 CHAR(255) NOT NULL DEFAULT '',
c166 CHAR(255) NOT NULL DEFAULT '',
c167 CHAR(255) NOT NULL DEFAULT '',
c168 CHAR(255) NOT NULL DEFAULT '',
c169 CHAR(255) NOT NULL DEFAULT '',
c170 CHAR(255) NOT NULL DEFAULT '',
c171 CHAR(255) NOT NULL DEFAULT '',
c172 CHAR(255) NOT NULL DEFAULT '',
c173 CHAR(255) NOT NULL DEFAULT '',
c174 CHAR(255) NOT NULL DEFAULT '',
c175 CHAR(255) NOT NULL DEFAULT '',
c176 CHAR(255) NOT NULL DEFAULT '',
c177 CHAR(255) NOT NULL DEFAULT '',
c178 CHAR(255) NOT NULL DEFAULT '',
c179 CHAR(255) NOT NULL DEFAULT '',
c180 CHAR(255) NOT NULL DEFAULT '',
c181 CHAR(255) NOT NULL DEFAULT '',
c182 CHAR(255) NOT NULL DEFAULT '',
c183 CHAR(255) NOT NULL DEFAULT '',
c184 CHAR(255) NOT NULL DEFAULT '',
c185 CHAR(255) NOT NULL DEFAULT '',
c186 CHAR(255) NOT NULL DEFAULT '',
c187 CHAR(255) NOT NULL DEFAULT '',
c188 CHAR(255) NOT NULL DEFAULT '',
c189 CHAR(255) NOT NULL DEFAULT '',
c190 CHAR(255) NOT NULL DEFAULT '',
c191 CHAR(255) NOT NULL DEFAULT '',
c192 CHAR(255) NOT NULL DEFAULT '',
c193 CHAR(255) NOT NULL DEFAULT '',
c194 CHAR(255) NOT NULL DEFAULT '',
c195 CHAR(255) NOT NULL DEFAULT '',
c196 CHAR(255) NOT NULL DEFAULT '',
c197 CHAR(255) NOT NULL DEFAULT '',
c198 CHAR(255) NOT NULL DEFAULT '',
c199 CHAR(255) NOT NULL DEFAULT '',
c200 CHAR(255) NOT NULL DEFAULT '',
c201 CHAR(255) NOT NULL DEFAULT '',
c202 CHAR(255) NOT NULL DEFAULT '',
c203 CHAR(255) NOT NULL DEFAULT '',
c204 CHAR(255) NOT NULL DEFAULT '',
c205 CHAR(255) NOT NULL DEFAULT '',
c206 CHAR(255) NOT NULL DEFAULT '',
c207 CHAR(255) NOT NULL DEFAULT '',
c208 CHAR(255) NOT NULL DEFAULT '',
c209 CHAR(255) NOT NULL DEFAULT '',
c210 CHAR(255) NOT NULL DEFAULT '',
c211 CHAR(255) NOT NULL DEFAULT '',
c212 CHAR(255) NOT NULL DEFAULT '',
c213 CHAR(255) NOT NULL DEFAULT '',
c214 CHAR(255) NOT NULL DEFAULT '',
c215 CHAR(255) NOT NULL DEFAULT '',
c216 CHAR(255) NOT NULL DEFAULT '',
c217 CHAR(255) NOT NULL DEFAULT '',
c218 CHAR(255) NOT NULL DEFAULT '',
c219 CHAR(255) NOT NULL DEFAULT '',
c220 CHAR(255) NOT NULL DEFAULT '',
c221 CHAR(255) NOT NULL DEFAULT '',
c222 CHAR(255) NOT NULL DEFAULT '',
c223 CHAR(255) NOT NULL DEFAULT '',
c224 CHAR(255) NOT NULL DEFAULT '',
c225 CHAR(255) NOT NULL DEFAULT '',
c226 CHAR(255) NOT NULL DEFAULT '',
c227 CHAR(255) NOT NULL DEFAULT '',
c228 CHAR(255) NOT NULL DEFAULT '',
c229 CHAR(255) NOT NULL DEFAULT '',
c230 CHAR(255) NOT NULL DEFAULT '',
c231 CHAR(255) NOT NULL DEFAULT '',
c232 CHAR(255) NOT NULL DEFAULT '',
c233 CHAR(255) NOT NULL DEFAULT '',
c234 CHAR(255) NOT NULL DEFAULT '',
c235 CHAR(255) NOT NULL DEFAULT '',
c236 CHAR(255) NOT NULL DEFAULT '',
c237 CHAR(255) NOT NULL DEFAULT '',
c238 CHAR(255) NOT NULL DEFAULT '',
c239 CHAR(255) NOT NULL DEFAULT '',
c240 CHAR(255) NOT NULL DEFAULT '',
c241 CHAR(255) NOT NULL DEFAULT '',
c242 CHAR(255) NOT NULL DEFAULT '',
c243 CHAR(255) NOT NULL DEFAULT '',
c244 CHAR(255) NOT NULL DEFAULT '',
c245 CHAR(255) NOT NULL DEFAULT '',
c246 CHAR(255) NOT NULL DEFAULT '',
c247 CHAR(255) NOT NULL DEFAULT '',
c248 CHAR(255) NOT NULL DEFAULT '',
c249 CHAR(255) NOT NULL DEFAULT '',
c250 CHAR(255) NOT NULL DEFAULT '',
c251 CHAR(255) NOT NULL DEFAULT '',
c252 CHAR(255) NOT NULL DEFAULT '',
c253 CHAR(255) NOT NULL DEFAULT '',
c254 CHAR(255) NOT NULL DEFAULT '',
c255 CHAR(255) NOT NULL DEFAULT '',
c256 CHAR(255) NOT NULL DEFAULT '',
c257 CHAR(254) NOT NULL DEFAULT ''
) ENGINE = INNODB ROW_FORMAT=COMPACT charset latin1;
Warnings:
Warning 139 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
SELECT * FROM t1 ORDER BY c1;
c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16 c17 c18 c19 c20 c21 c22 c23 c24 c25 c26 c27 c28 c29 c30 c31 c32 c33 c34 c35 c36 c37 c38 c39 c40 c41 c42 c43 c44 c45 c46 c47 c48 c49 c50 c51 c52 c53 c54 c55 c56 c57 c58 c59 c60 c61 c62 c63 c64 c65 c66 c67 c68 c69 c70 c71 c72 c73 c74 c75 c76 c77 c78 c79 c80 c81 c82 c83 c84 c85 c86 c87 c88 c89 c90 c91 c92 c93 c94 c95 c96 c97 c98 c99 c100 c101 c102 c103 c104 c105 c106 c107 c108 c109 c110 c111 c112 c113 c114 c115 c116 c117 c118 c119 c120 c121 c122 c123 c124 c125 c126 c127 c128 c129 c130 c131 c132 c133 c134 c135 c136 c137 c138 c139 c140 c141 c142 c143 c144 c145 c146 c147 c148 c149 c150 c151 c152 c153 c154 c155 c156 c157 c158 c159 c160 c161 c162 c163 c164 c165 c166 c167 c168 c169 c170 c171 c172 c173 c174 c175 c176 c177 c178 c179 c180 c181 c182 c183 c184 c185 c186 c187 c188 c189 c190 c191 c192 c193 c194 c195 c196 c197 c198 c199 c200 c201 c202 c203 c204 c205 c206 c207 c208 c209 c210 c211 c212 c213 c214 c215 c216 c217 c218 c219 c220 c221 c222 c223 c224 c225 c226 c227 c228 c229 c230 c231 c232 c233 c234 c235 c236 c237 c238 c239 c240 c241 c242 c243 c244 c245 c246 c247 c248 c249 c250 c251 c252 c253 c254 c255 c256 c257
SELECT * FROM information_schema.OPTIMIZER_TRACE;
QUERY TRACE MISSING_BYTES_BEYOND_MAX_MEM_SIZE INSUFFICIENT_PRIVILEGES
SELECT * FROM t1 ORDER BY c1 {
"steps": [
{
"join_preparation": {
"select#": 1,
"steps": [
{
"expanded_query": "/* select#1 */ select `t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5`,`t1`.`c6` AS `c6`,`t1`.`c7` AS `c7`,`t1`.`c8` AS `c8`,`t1`.`c9` AS `c9`,`t1`.`c10` AS `c10`,`t1`.`c11` AS `c11`,`t1`.`c12` AS `c12`,`t1`.`c13` AS `c13`,`t1`.`c14` AS `c14`,`t1`.`c15` AS `c15`,`t1`.`c16` AS `c16`,`t1`.`c17` AS `c17`,`t1`.`c18` AS `c18`,`t1`.`c19` AS `c19`,`t1`.`c20` AS `c20`,`t1`.`c21` AS `c21`,`t1`.`c22` AS `c22`,`t1`.`c23` AS `c23`,`t1`.`c24` AS `c24`,`t1`.`c25` AS `c25`,`t1`.`c26` AS `c26`,`t1`.`c27` AS `c27`,`t1`.`c28` AS `c28`,`t1`.`c29` AS `c29`,`t1`.`c30` AS `c30`,`t1`.`c31` AS `c31`,`t1`.`c32` AS `c32`,`t1`.`c33` AS `c33`,`t1`.`c34` AS `c34`,`t1`.`c35` AS `c35`,`t1`.`c36` AS `c36`,`t1`.`c37` AS `c37`,`t1`.`c38` AS `c38`,`t1`.`c39` AS `c39`,`t1`.`c40` AS `c40`,`t1`.`c41` AS `c41`,`t1`.`c42` AS `c42`,`t1`.`c43` AS `c43`,`t1`.`c44` AS `c44`,`t1`.`c45` AS `c45`,`t1`.`c46` AS `c46`,`t1`.`c47` AS `c47`,`t1`.`c48` AS `c48`,`t1`.`c49` AS `c49`,`t1`.`c50` AS `c50`,`t1`.`c51` AS `c51`,`t1`.`c52` AS `c52`,`t1`.`c53` AS `c53`,`t1`.`c54` AS `c54`,`t1`.`c55` AS `c55`,`t1`.`c56` AS `c56`,`t1`.`c57` AS `c57`,`t1`.`c58` AS `c58`,`t1`.`c59` AS `c59`,`t1`.`c60` AS `c60`,`t1`.`c61` AS `c61`,`t1`.`c62` AS `c62`,`t1`.`c63` AS `c63`,`t1`.`c64` AS `c64`,`t1`.`c65` AS `c65`,`t1`.`c66` AS `c66`,`t1`.`c67` AS `c67`,`t1`.`c68` AS `c68`,`t1`.`c69` AS `c69`,`t1`.`c70` AS `c70`,`t1`.`c71` AS `c71`,`t1`.`c72` AS `c72`,`t1`.`c73` AS `c73`,`t1`.`c74` AS `c74`,`t1`.`c75` AS `c75`,`t1`.`c76` AS `c76`,`t1`.`c77` AS `c77`,`t1`.`c78` AS `c78`,`t1`.`c79` AS `c79`,`t1`.`c80` AS `c80`,`t1`.`c81` AS `c81`,`t1`.`c82` AS `c82`,`t1`.`c83` AS `c83`,`t1`.`c84` AS `c84`,`t1`.`c85` AS `c85`,`t1`.`c86` AS `c86`,`t1`.`c87` AS `c87`,`t1`.`c88` AS `c88`,`t1`.`c89` AS `c89`,`t1`.`c90` AS `c90`,`t1`.`c91` AS `c91`,`t1`.`c92` AS `c92`,`t1`.`c93` AS `c93`,`t1`.`c94` AS `c94`,`t1`.`c95` AS `c95`,`t1`.`c96` AS `c96`,`t1`.`c97` AS `c97`,`t1`.`c98` AS `c98`,`t1`.`c99` AS `c99`,`t1`.`c100` AS `c100`,`t1`.`c101` AS `c101`,`t1`.`c102` AS `c102`,`t1`.`c103` AS `c103`,`t1`.`c104` AS `c104`,`t1`.`c105` AS `c105`,`t1`.`c106` AS `c106`,`t1`.`c107` AS `c107`,`t1`.`c108` AS `c108`,`t1`.`c109` AS `c109`,`t1`.`c110` AS `c110`,`t1`.`c111` AS `c111`,`t1`.`c112` AS `c112`,`t1`.`c113` AS `c113`,`t1`.`c114` AS `c114`,`t1`.`c115` AS `c115`,`t1`.`c116` AS `c116`,`t1`.`c117` AS `c117`,`t1`.`c118` AS `c118`,`t1`.`c119` AS `c119`,`t1`.`c120` AS `c120`,`t1`.`c121` AS `c121`,`t1`.`c122` AS `c122`,`t1`.`c123` AS `c123`,`t1`.`c124` AS `c124`,`t1`.`c125` AS `c125`,`t1`.`c126` AS `c126`,`t1`.`c127` AS `c127`,`t1`.`c128` AS `c128`,`t1`.`c129` AS `c129`,`t1`.`c130` AS `c130`,`t1`.`c131` AS `c131`,`t1`.`c132` AS `c132`,`t1`.`c133` AS `c133`,`t1`.`c134` AS `c134`,`t1`.`c135` AS `c135`,`t1`.`c136` AS `c136`,`t1`.`c137` AS `c137`,`t1`.`c138` AS `c138`,`t1`.`c139` AS `c139`,`t1`.`c140` AS `c140`,`t1`.`c141` AS `c141`,`t1`.`c142` AS `c142`,`t1`.`c143` AS `c143`,`t1`.`c144` AS `c144`,`t1`.`c145` AS `c145`,`t1`.`c146` AS `c146`,`t1`.`c147` AS `c147`,`t1`.`c148` AS `c148`,`t1`.`c149` AS `c149`,`t1`.`c150` AS `c150`,`t1`.`c151` AS `c151`,`t1`.`c152` AS `c152`,`t1`.`c153` AS `c153`,`t1`.`c154` AS `c154`,`t1`.`c155` AS `c155`,`t1`.`c156` AS `c156`,`t1`.`c157` AS `c157`,`t1`.`c158` AS `c158`,`t1`.`c159` AS `c159`,`t1`.`c160` AS `c160`,`t1`.`c161` AS `c161`,`t1`.`c162` AS `c162`,`t1`.`c163` AS `c163`,`t1`.`c164` AS `c164`,`t1`.`c165` AS `c165`,`t1`.`c166` AS `c166`,`t1`.`c167` AS `c167`,`t1`.`c168` AS `c168`,`t1`.`c169` AS `c169`,`t1`.`c170` AS `c170`,`t1`.`c171` AS `c171`,`t1`.`c172` AS `c172`,`t1`.`c173` AS `c173`,`t1`.`c174` AS `c174`,`t1`.`c175` AS `c175`,`t1`.`c176` AS `c176`,`t1`.`c177` AS `c177`,`t1`.`c178` AS `c178`,`t1`.`c179` AS `c179`,`t1`.`c180` AS `c180`,`t1`.`c181` AS `c181`,`t1`.`c182` AS `c182`,`t1`.`c183` AS `c183`,`t1`.`c184` AS `c184`,`t1`.`c185` AS `c185`,`t1`.`c186` AS `c186`,`t1`.`c187` AS `c187`,`t1`.`c188` AS `c188`,`t1`.`c189` AS `c189`,`t1`.`c190` AS `c190`,`t1`.`c191` AS `c191`,`t1`.`c192` AS `c192`,`t1`.`c193` AS `c193`,`t1`.`c194` AS `c194`,`t1`.`c195` AS `c195`,`t1`.`c196` AS `c196`,`t1`.`c197` AS `c197`,`t1`.`c198` AS `c198`,`t1`.`c199` AS `c199`,`t1`.`c200` AS `c200`,`t1`.`c201` AS `c201`,`t1`.`c202` AS `c202`,`t1`.`c203` AS `c203`,`t1`.`c204` AS `c204`,`t1`.`c205` AS `c205`,`t1`.`c206` AS `c206`,`t1`.`c207` AS `c207`,`t1`.`c208` AS `c208`,`t1`.`c209` AS `c209`,`t1`.`c210` AS `c210`,`t1`.`c211` AS `c211`,`t1`.`c212` AS `c212`,`t1`.`c213` AS `c213`,`t1`.`c214` AS `c214`,`t1`.`c215` AS `c215`,`t1`.`c216` AS `c216`,`t1`.`c217` AS `c217`,`t1`.`c218` AS `c218`,`t1`.`c219` AS `c219`,`t1`.`c220` AS `c220`,`t1`.`c221` AS `c221`,`t1`.`c222` AS `c222`,`t1`.`c223` AS `c223`,`t1`.`c224` AS `c224`,`t1`.`c225` AS `c225`,`t1`.`c226` AS `c226`,`t1`.`c227` AS `c227`,`t1`.`c228` AS `c228`,`t1`.`c229` AS `c229`,`t1`.`c230` AS `c230`,`t1`.`c231` AS `c231`,`t1`.`c232` AS `c232`,`t1`.`c233` AS `c233`,`t1`.`c234` AS `c234`,`t1`.`c235` AS `c235`,`t1`.`c236` AS `c236`,`t1`.`c237` AS `c237`,`t1`.`c238` AS `c238`,`t1`.`c239` AS `c239`,`t1`.`c240` AS `c240`,`t1`.`c241` AS `c241`,`t1`.`c242` AS `c242`,`t1`.`c243` AS `c243`,`t1`.`c244` AS `c244`,`t1`.`c245` AS `c245`,`t1`.`c246` AS `c246`,`t1`.`c247` AS `c247`,`t1`.`c248` AS `c248`,`t1`.`c249` AS `c249`,`t1`.`c250` AS `c250`,`t1`.`c251` AS `c251`,`t1`.`c252` AS `c252`,`t1`.`c253` AS `c253`,`t1`.`c254` AS `c254`,`t1`.`c255` AS `c255`,`t1`.`c256` AS `c256`,`t1`.`c257` AS `c257` from `t1` order by `t1`.`c1`"
}
]
}
},
{
"join_optimization": {
"select#": 1,
"steps": [
{
"substitute_generated_columns": {
}
},
{
"table_dependencies": [
{
"table": "`t1`",
"row_may_be_null": false,
"map_bit": 0,
"depends_on_map_bits": [
]
}
]
},
{
"rows_estimation": [
{
"table": "`t1`",
"table_scan": {
"rows": 1,
"cost": 0.25
}
}
]
},
{
"considered_execution_plans": [
{
"plan_prefix": [
],
"table": "`t1`",
"best_access_path": {
"considered_access_paths": [
{
"rows_to_scan": 1,
"access_type": "scan",
"resulting_rows": 1,
"cost": 0.35,
"chosen": true,
"use_tmp_table": true
}
]
},
"condition_filtering_pct": 100,
"rows_for_plan": 1,
"cost_for_plan": 0.35,
"sort_cost": 1,
"new_cost_for_plan": 1.35,
"chosen": true
}
]
},
{
"attaching_conditions_to_tables": {
"original_condition": null,
"attached_conditions_computation": [
],
"attached_conditions_summary": [
{
"table": "`t1`",
"attached": null
}
]
}
},
{
"optimizing_distinct_group_by_order_by": {
"simplifying_order_by": {
"original_clause": "`t1`.`c1`",
"items": [
{
"item": "`t1`.`c1`"
}
],
"resulting_clause_is_simple": true,
"resulting_clause": "`t1`.`c1`"
}
}
},
{
"finalizing_table_conditions": [
]
},
{
"refine_plan": [
{
"table": "`t1`"
}
]
},
{
"considering_tmp_tables": [
{
"adding_sort_to_table": "t1"
}
]
}
]
}
},
{
"join_execution": {
"select#": 1,
"steps": [
{
"sorting_table": "t1",
"filesort_information": [
{
"direction": "asc",
"expression": "`t1`.`c1`"
}
],
"filesort_priority_queue_optimization": {
"usable": false,
"cause": "not applicable (no LIMIT)"
},
"filesort_execution": [
],
"filesort_summary": {
"memory_available": 262144,
"key_size": 255,
"row_size": 66050,
"max_rows_per_buffer": 3,
"num_rows_estimate": 15,
"num_rows_found": 0,
"num_initial_chunks_spilled_to_disk": 0,
"peak_memory_used": 0,
"sort_algorithm": "none",
"sort_mode": "<fixed_sort_key, packed_additional_fields>"
}
}
]
}
}
]
} 0 0
DROP TABLE t1;
|
