Debian Codegraph @

mysql-test/suite/ndb/r/ndb_read_balance.result

raw
1
2
3
4 *******************************************************
5 ndb_read_balance.inc
6 Table comment : NDB_TABLE=READ_BACKUP=0,FULLY_REPLICATED=0
7 Keys : 40
8 Test_step : 5
9 Expect : Classic distribution, always PRIMARY
10 *******************************************************
11
12 Create table with int pk, unique secondary int and key int columns
13 Expect that secondary unique is distributed in the same way as main table
14 CREATE TABLE test.t1 (a int, b int, c int, d int, primary key (a), unique(b) using hash, key(c)) comment='NDB_TABLE=READ_BACKUP=0,FULLY_REPLICATED=0' engine=ndb;;
15 Warnings:
16 Warning 1121 Ndb does not support unique index on NULL valued attributes, index access with NULL value will become full table scan
17 Check that all fragments are in-use, else raise key count
18 select count(1) from ndbinfo.memory_per_fragment where fq_name='test/def/t1' and fixed_elem_count=0;
19 count(1)
20 0
21 Build fragment identity table
22 Test lock free pk reads to show fragment types read
23 select distinct obj_type, fragment_type from min_baseline_diff_type order by obj_type, fragment_type;
24 obj_type fragment_type
25 TABLE PRIMARY
26 Test a number of scenarios repeatedly to show read routing variants
27
28 ****
29 Row with key : 40
30
31 Unhinted PK read, no lock
32 obj_type fragment_type
33 TABLE PRIMARY
34
35 Hinted PK read, no lock
36 obj_type fragment_type
37 TABLE PRIMARY
38
39 Unhinted PK read, shared lock
40 obj_type fragment_type
41 TABLE PRIMARY
42
43 Unhinted PK read, exclusive lock
44 obj_type fragment_type
45 TABLE PRIMARY
46
47 Unhinted UI read, no lock
48 obj_type fragment_type
49 TABLE PRIMARY
50 UI_B PRIMARY
51
52 Unhinted UI read, shared lock
53 obj_type fragment_type
54 TABLE PRIMARY
55 UI_B PRIMARY
56
57 Unhinted UI read, exclusive lock
58 obj_type fragment_type
59 TABLE PRIMARY
60 UI_B PRIMARY
61
62 ****
63 Row with key : 35
64
65 Unhinted PK read, no lock
66 obj_type fragment_type
67 TABLE PRIMARY
68
69 Hinted PK read, no lock
70 obj_type fragment_type
71 TABLE PRIMARY
72
73 Unhinted PK read, shared lock
74 obj_type fragment_type
75 TABLE PRIMARY
76
77 Unhinted PK read, exclusive lock
78 obj_type fragment_type
79 TABLE PRIMARY
80
81 Unhinted UI read, no lock
82 obj_type fragment_type
83 TABLE PRIMARY
84 UI_B PRIMARY
85
86 Unhinted UI read, shared lock
87 obj_type fragment_type
88 TABLE PRIMARY
89 UI_B PRIMARY
90
91 Unhinted UI read, exclusive lock
92 obj_type fragment_type
93 TABLE PRIMARY
94 UI_B PRIMARY
95
96 ****
97 Row with key : 30
98
99 Unhinted PK read, no lock
100 obj_type fragment_type
101 TABLE PRIMARY
102
103 Hinted PK read, no lock
104 obj_type fragment_type
105 TABLE PRIMARY
106
107 Unhinted PK read, shared lock
108 obj_type fragment_type
109 TABLE PRIMARY
110
111 Unhinted PK read, exclusive lock
112 obj_type fragment_type
113 TABLE PRIMARY
114
115 Unhinted UI read, no lock
116 obj_type fragment_type
117 TABLE PRIMARY
118 UI_B PRIMARY
119
120 Unhinted UI read, shared lock
121 obj_type fragment_type
122 TABLE PRIMARY
123 UI_B PRIMARY
124
125 Unhinted UI read, exclusive lock
126 obj_type fragment_type
127 TABLE PRIMARY
128 UI_B PRIMARY
129
130 ****
131 Row with key : 25
132
133 Unhinted PK read, no lock
134 obj_type fragment_type
135 TABLE PRIMARY
136
137 Hinted PK read, no lock
138 obj_type fragment_type
139 TABLE PRIMARY
140
141 Unhinted PK read, shared lock
142 obj_type fragment_type
143 TABLE PRIMARY
144
145 Unhinted PK read, exclusive lock
146 obj_type fragment_type
147 TABLE PRIMARY
148
149 Unhinted UI read, no lock
150 obj_type fragment_type
151 TABLE PRIMARY
152 UI_B PRIMARY
153
154 Unhinted UI read, shared lock
155 obj_type fragment_type
156 TABLE PRIMARY
157 UI_B PRIMARY
158
159 Unhinted UI read, exclusive lock
160 obj_type fragment_type
161 TABLE PRIMARY
162 UI_B PRIMARY
163
164 ****
165 Row with key : 20
166
167 Unhinted PK read, no lock
168 obj_type fragment_type
169 TABLE PRIMARY
170
171 Hinted PK read, no lock
172 obj_type fragment_type
173 TABLE PRIMARY
174
175 Unhinted PK read, shared lock
176 obj_type fragment_type
177 TABLE PRIMARY
178
179 Unhinted PK read, exclusive lock
180 obj_type fragment_type
181 TABLE PRIMARY
182
183 Unhinted UI read, no lock
184 obj_type fragment_type
185 TABLE PRIMARY
186 UI_B PRIMARY
187
188 Unhinted UI read, shared lock
189 obj_type fragment_type
190 TABLE PRIMARY
191 UI_B PRIMARY
192
193 Unhinted UI read, exclusive lock
194 obj_type fragment_type
195 TABLE PRIMARY
196 UI_B PRIMARY
197
198 ****
199 Row with key : 15
200
201 Unhinted PK read, no lock
202 obj_type fragment_type
203 TABLE PRIMARY
204
205 Hinted PK read, no lock
206 obj_type fragment_type
207 TABLE PRIMARY
208
209 Unhinted PK read, shared lock
210 obj_type fragment_type
211 TABLE PRIMARY
212
213 Unhinted PK read, exclusive lock
214 obj_type fragment_type
215 TABLE PRIMARY
216
217 Unhinted UI read, no lock
218 obj_type fragment_type
219 TABLE PRIMARY
220 UI_B PRIMARY
221
222 Unhinted UI read, shared lock
223 obj_type fragment_type
224 TABLE PRIMARY
225 UI_B PRIMARY
226
227 Unhinted UI read, exclusive lock
228 obj_type fragment_type
229 TABLE PRIMARY
230 UI_B PRIMARY
231
232 ****
233 Row with key : 10
234
235 Unhinted PK read, no lock
236 obj_type fragment_type
237 TABLE PRIMARY
238
239 Hinted PK read, no lock
240 obj_type fragment_type
241 TABLE PRIMARY
242
243 Unhinted PK read, shared lock
244 obj_type fragment_type
245 TABLE PRIMARY
246
247 Unhinted PK read, exclusive lock
248 obj_type fragment_type
249 TABLE PRIMARY
250
251 Unhinted UI read, no lock
252 obj_type fragment_type
253 TABLE PRIMARY
254 UI_B PRIMARY
255
256 Unhinted UI read, shared lock
257 obj_type fragment_type
258 TABLE PRIMARY
259 UI_B PRIMARY
260
261 Unhinted UI read, exclusive lock
262 obj_type fragment_type
263 TABLE PRIMARY
264 UI_B PRIMARY
265
266 ****
267 Row with key : 5
268
269 Unhinted PK read, no lock
270 obj_type fragment_type
271 TABLE PRIMARY
272
273 Hinted PK read, no lock
274 obj_type fragment_type
275 TABLE PRIMARY
276
277 Unhinted PK read, shared lock
278 obj_type fragment_type
279 TABLE PRIMARY
280
281 Unhinted PK read, exclusive lock
282 obj_type fragment_type
283 TABLE PRIMARY
284
285 Unhinted UI read, no lock
286 obj_type fragment_type
287 TABLE PRIMARY
288 UI_B PRIMARY
289
290 Unhinted UI read, shared lock
291 obj_type fragment_type
292 TABLE PRIMARY
293 UI_B PRIMARY
294
295 Unhinted UI read, exclusive lock
296 obj_type fragment_type
297 TABLE PRIMARY
298 UI_B PRIMARY
299
300 *********
301 Scans
302
303 Unhinted PK OI read, no lock
304 obj_type fragment_type
305 OI_PRIMARY PRIMARY
306
307 Unhinted PK OI read, shared lock
308 obj_type fragment_type
309 OI_PRIMARY PRIMARY
310 TABLE PRIMARY
311
312 Unhinted PK OI read, exclusive lock
313 obj_type fragment_type
314 OI_PRIMARY PRIMARY
315 TABLE PRIMARY
316
317 Table scan, no lock
318 obj_type fragment_type
319 TABLE PRIMARY
320
321 Table scan, shared lock
322 obj_type fragment_type
323 TABLE PRIMARY
324
325 Table scan, exclusive lock
326 obj_type fragment_type
327 TABLE PRIMARY
328
329
330
331 *******************************************************
332 ndb_read_balance.inc
333 Table comment : NDB_TABLE=READ_BACKUP=1,PARTITION_BALANCE=FOR_RP_BY_LDM
334 Keys : 40
335 Test_step : 5
336 Expect : Read Backup, Mix of Primary + Backup, except where locks are used
337 *******************************************************
338
339 Create table with int pk, unique secondary int and key int columns
340 Expect that secondary unique is distributed in the same way as main table
341 CREATE TABLE test.t1 (a int, b int, c int, d int, primary key (a), unique(b) using hash, key(c)) comment='NDB_TABLE=READ_BACKUP=1,PARTITION_BALANCE=FOR_RP_BY_LDM' engine=ndb;;
342 Warnings:
343 Warning 1121 Ndb does not support unique index on NULL valued attributes, index access with NULL value will become full table scan
344 Check that all fragments are in-use, else raise key count
345 select count(1) from ndbinfo.memory_per_fragment where fq_name='test/def/t1' and fixed_elem_count=0;
346 count(1)
347 0
348 Build fragment identity table
349 Test lock free pk reads to show fragment types read
350 select distinct obj_type, fragment_type from min_baseline_diff_type order by obj_type, fragment_type;
351 obj_type fragment_type
352 TABLE BACKUP
353 TABLE PRIMARY
354 Test a number of scenarios repeatedly to show read routing variants
355
356 ****
357 Row with key : 40
358
359 Unhinted PK read, no lock
360 obj_type fragment_type
361 TABLE BACKUP
362 TABLE PRIMARY
363
364 Hinted PK read, no lock
365 obj_type fragment_type
366 TABLE BACKUP
367 TABLE PRIMARY
368
369 Unhinted PK read, shared lock
370 obj_type fragment_type
371 TABLE PRIMARY
372
373 Unhinted PK read, exclusive lock
374 obj_type fragment_type
375 TABLE PRIMARY
376
377 Unhinted UI read, no lock
378 obj_type fragment_type
379 TABLE BACKUP
380 TABLE PRIMARY
381 UI_B BACKUP
382 UI_B PRIMARY
383
384 Unhinted UI read, shared lock
385 obj_type fragment_type
386 TABLE PRIMARY
387 UI_B PRIMARY
388
389 Unhinted UI read, exclusive lock
390 obj_type fragment_type
391 TABLE PRIMARY
392 UI_B PRIMARY
393
394 ****
395 Row with key : 35
396
397 Unhinted PK read, no lock
398 obj_type fragment_type
399 TABLE BACKUP
400 TABLE PRIMARY
401
402 Hinted PK read, no lock
403 obj_type fragment_type
404 TABLE BACKUP
405 TABLE PRIMARY
406
407 Unhinted PK read, shared lock
408 obj_type fragment_type
409 TABLE PRIMARY
410
411 Unhinted PK read, exclusive lock
412 obj_type fragment_type
413 TABLE PRIMARY
414
415 Unhinted UI read, no lock
416 obj_type fragment_type
417 TABLE BACKUP
418 TABLE PRIMARY
419 UI_B BACKUP
420 UI_B PRIMARY
421
422 Unhinted UI read, shared lock
423 obj_type fragment_type
424 TABLE PRIMARY
425 UI_B PRIMARY
426
427 Unhinted UI read, exclusive lock
428 obj_type fragment_type
429 TABLE PRIMARY
430 UI_B PRIMARY
431
432 ****
433 Row with key : 30
434
435 Unhinted PK read, no lock
436 obj_type fragment_type
437 TABLE BACKUP
438 TABLE PRIMARY
439
440 Hinted PK read, no lock
441 obj_type fragment_type
442 TABLE BACKUP
443 TABLE PRIMARY
444
445 Unhinted PK read, shared lock
446 obj_type fragment_type
447 TABLE PRIMARY
448
449 Unhinted PK read, exclusive lock
450 obj_type fragment_type
451 TABLE PRIMARY
452
453 Unhinted UI read, no lock
454 obj_type fragment_type
455 TABLE BACKUP
456 TABLE PRIMARY
457 UI_B BACKUP
458 UI_B PRIMARY
459
460 Unhinted UI read, shared lock
461 obj_type fragment_type
462 TABLE PRIMARY
463 UI_B PRIMARY
464
465 Unhinted UI read, exclusive lock
466 obj_type fragment_type
467 TABLE PRIMARY
468 UI_B PRIMARY
469
470 ****
471 Row with key : 25
472
473 Unhinted PK read, no lock
474 obj_type fragment_type
475 TABLE BACKUP
476 TABLE PRIMARY
477
478 Hinted PK read, no lock
479 obj_type fragment_type
480 TABLE BACKUP
481 TABLE PRIMARY
482
483 Unhinted PK read, shared lock
484 obj_type fragment_type
485 TABLE PRIMARY
486
487 Unhinted PK read, exclusive lock
488 obj_type fragment_type
489 TABLE PRIMARY
490
491 Unhinted UI read, no lock
492 obj_type fragment_type
493 TABLE BACKUP
494 TABLE PRIMARY
495 UI_B BACKUP
496 UI_B PRIMARY
497
498 Unhinted UI read, shared lock
499 obj_type fragment_type
500 TABLE PRIMARY
501 UI_B PRIMARY
502
503 Unhinted UI read, exclusive lock
504 obj_type fragment_type
505 TABLE PRIMARY
506 UI_B PRIMARY
507
508 ****
509 Row with key : 20
510
511 Unhinted PK read, no lock
512 obj_type fragment_type
513 TABLE BACKUP
514 TABLE PRIMARY
515
516 Hinted PK read, no lock
517 obj_type fragment_type
518 TABLE BACKUP
519 TABLE PRIMARY
520
521 Unhinted PK read, shared lock
522 obj_type fragment_type
523 TABLE PRIMARY
524
525 Unhinted PK read, exclusive lock
526 obj_type fragment_type
527 TABLE PRIMARY
528
529 Unhinted UI read, no lock
530 obj_type fragment_type
531 TABLE BACKUP
532 TABLE PRIMARY
533 UI_B BACKUP
534 UI_B PRIMARY
535
536 Unhinted UI read, shared lock
537 obj_type fragment_type
538 TABLE PRIMARY
539 UI_B PRIMARY
540
541 Unhinted UI read, exclusive lock
542 obj_type fragment_type
543 TABLE PRIMARY
544 UI_B PRIMARY
545
546 ****
547 Row with key : 15
548
549 Unhinted PK read, no lock
550 obj_type fragment_type
551 TABLE BACKUP
552 TABLE PRIMARY
553
554 Hinted PK read, no lock
555 obj_type fragment_type
556 TABLE BACKUP
557 TABLE PRIMARY
558
559 Unhinted PK read, shared lock
560 obj_type fragment_type
561 TABLE PRIMARY
562
563 Unhinted PK read, exclusive lock
564 obj_type fragment_type
565 TABLE PRIMARY
566
567 Unhinted UI read, no lock
568 obj_type fragment_type
569 TABLE BACKUP
570 TABLE PRIMARY
571 UI_B BACKUP
572 UI_B PRIMARY
573
574 Unhinted UI read, shared lock
575 obj_type fragment_type
576 TABLE PRIMARY
577 UI_B PRIMARY
578
579 Unhinted UI read, exclusive lock
580 obj_type fragment_type
581 TABLE PRIMARY
582 UI_B PRIMARY
583
584 ****
585 Row with key : 10
586
587 Unhinted PK read, no lock
588 obj_type fragment_type
589 TABLE BACKUP
590 TABLE PRIMARY
591
592 Hinted PK read, no lock
593 obj_type fragment_type
594 TABLE BACKUP
595 TABLE PRIMARY
596
597 Unhinted PK read, shared lock
598 obj_type fragment_type
599 TABLE PRIMARY
600
601 Unhinted PK read, exclusive lock
602 obj_type fragment_type
603 TABLE PRIMARY
604
605 Unhinted UI read, no lock
606 obj_type fragment_type
607 TABLE BACKUP
608 TABLE PRIMARY
609 UI_B BACKUP
610 UI_B PRIMARY
611
612 Unhinted UI read, shared lock
613 obj_type fragment_type
614 TABLE PRIMARY
615 UI_B PRIMARY
616
617 Unhinted UI read, exclusive lock
618 obj_type fragment_type
619 TABLE PRIMARY
620 UI_B PRIMARY
621
622 ****
623 Row with key : 5
624
625 Unhinted PK read, no lock
626 obj_type fragment_type
627 TABLE BACKUP
628 TABLE PRIMARY
629
630 Hinted PK read, no lock
631 obj_type fragment_type
632 TABLE BACKUP
633 TABLE PRIMARY
634
635 Unhinted PK read, shared lock
636 obj_type fragment_type
637 TABLE PRIMARY
638
639 Unhinted PK read, exclusive lock
640 obj_type fragment_type
641 TABLE PRIMARY
642
643 Unhinted UI read, no lock
644 obj_type fragment_type
645 TABLE BACKUP
646 TABLE PRIMARY
647 UI_B BACKUP
648 UI_B PRIMARY
649
650 Unhinted UI read, shared lock
651 obj_type fragment_type
652 TABLE PRIMARY
653 UI_B PRIMARY
654
655 Unhinted UI read, exclusive lock
656 obj_type fragment_type
657 TABLE PRIMARY
658 UI_B PRIMARY
659
660 *********
661 Scans
662
663 Unhinted PK OI read, no lock
664 obj_type fragment_type
665 OI_PRIMARY BACKUP
666 OI_PRIMARY PRIMARY
667
668 Unhinted PK OI read, shared lock
669 obj_type fragment_type
670 OI_PRIMARY PRIMARY
671 TABLE PRIMARY
672
673 Unhinted PK OI read, exclusive lock
674 obj_type fragment_type
675 OI_PRIMARY PRIMARY
676 TABLE PRIMARY
677
678 Table scan, no lock
679 obj_type fragment_type
680 TABLE BACKUP
681 TABLE PRIMARY
682
683 Table scan, shared lock
684 obj_type fragment_type
685 TABLE PRIMARY
686
687 Table scan, exclusive lock
688 obj_type fragment_type
689 TABLE PRIMARY
690
691
692
693 *******************************************************
694 ndb_read_balance.inc
695 Table comment : NDB_TABLE=FULLY_REPLICATED=1
696 Keys : 40
697 Test_step : 5
698 Expect : Fully replicated, Mix of Primary + Backup, except where locks are used
699 *******************************************************
700
701 Create table with int pk, unique secondary int and key int columns
702 Expect that secondary unique is distributed in the same way as main table
703 CREATE TABLE test.t1 (a int, b int, c int, d int, primary key (a), unique(b) using hash, key(c)) comment='NDB_TABLE=FULLY_REPLICATED=1' engine=ndb;;
704 Warnings:
705 Warning 1121 Ndb does not support unique index on NULL valued attributes, index access with NULL value will become full table scan
706 Check that all fragments are in-use, else raise key count
707 select count(1) from ndbinfo.memory_per_fragment where fq_name='test/def/t1' and fixed_elem_count=0;
708 count(1)
709 0
710 Build fragment identity table
711 Test lock free pk reads to show fragment types read
712 select distinct obj_type, fragment_type from min_baseline_diff_type order by obj_type, fragment_type;
713 obj_type fragment_type
714 TABLE BACKUP
715 TABLE PRIMARY
716 Test a number of scenarios repeatedly to show read routing variants
717
718 ****
719 Row with key : 40
720
721 Unhinted PK read, no lock
722 obj_type fragment_type
723 TABLE BACKUP
724 TABLE PRIMARY
725
726 Hinted PK read, no lock
727 obj_type fragment_type
728 TABLE BACKUP
729 TABLE PRIMARY
730
731 Unhinted PK read, shared lock
732 obj_type fragment_type
733 TABLE PRIMARY
734
735 Unhinted PK read, exclusive lock
736 obj_type fragment_type
737 TABLE PRIMARY
738
739 Unhinted UI read, no lock
740 obj_type fragment_type
741 TABLE BACKUP
742 TABLE PRIMARY
743 UI_B BACKUP
744 UI_B PRIMARY
745
746 Unhinted UI read, shared lock
747 obj_type fragment_type
748 TABLE PRIMARY
749 UI_B PRIMARY
750
751 Unhinted UI read, exclusive lock
752 obj_type fragment_type
753 TABLE PRIMARY
754 UI_B PRIMARY
755
756 ****
757 Row with key : 35
758
759 Unhinted PK read, no lock
760 obj_type fragment_type
761 TABLE BACKUP
762 TABLE PRIMARY
763
764 Hinted PK read, no lock
765 obj_type fragment_type
766 TABLE BACKUP
767 TABLE PRIMARY
768
769 Unhinted PK read, shared lock
770 obj_type fragment_type
771 TABLE PRIMARY
772
773 Unhinted PK read, exclusive lock
774 obj_type fragment_type
775 TABLE PRIMARY
776
777 Unhinted UI read, no lock
778 obj_type fragment_type
779 TABLE BACKUP
780 TABLE PRIMARY
781 UI_B BACKUP
782 UI_B PRIMARY
783
784 Unhinted UI read, shared lock
785 obj_type fragment_type
786 TABLE PRIMARY
787 UI_B PRIMARY
788
789 Unhinted UI read, exclusive lock
790 obj_type fragment_type
791 TABLE PRIMARY
792 UI_B PRIMARY
793
794 ****
795 Row with key : 30
796
797 Unhinted PK read, no lock
798 obj_type fragment_type
799 TABLE BACKUP
800 TABLE PRIMARY
801
802 Hinted PK read, no lock
803 obj_type fragment_type
804 TABLE BACKUP
805 TABLE PRIMARY
806
807 Unhinted PK read, shared lock
808 obj_type fragment_type
809 TABLE PRIMARY
810
811 Unhinted PK read, exclusive lock
812 obj_type fragment_type
813 TABLE PRIMARY
814
815 Unhinted UI read, no lock
816 obj_type fragment_type
817 TABLE BACKUP
818 TABLE PRIMARY
819 UI_B BACKUP
820 UI_B PRIMARY
821
822 Unhinted UI read, shared lock
823 obj_type fragment_type
824 TABLE PRIMARY
825 UI_B PRIMARY
826
827 Unhinted UI read, exclusive lock
828 obj_type fragment_type
829 TABLE PRIMARY
830 UI_B PRIMARY
831
832 ****
833 Row with key : 25
834
835 Unhinted PK read, no lock
836 obj_type fragment_type
837 TABLE BACKUP
838 TABLE PRIMARY
839
840 Hinted PK read, no lock
841 obj_type fragment_type
842 TABLE BACKUP
843 TABLE PRIMARY
844
845 Unhinted PK read, shared lock
846 obj_type fragment_type
847 TABLE PRIMARY
848
849 Unhinted PK read, exclusive lock
850 obj_type fragment_type
851 TABLE PRIMARY
852
853 Unhinted UI read, no lock
854 obj_type fragment_type
855 TABLE BACKUP
856 TABLE PRIMARY
857 UI_B BACKUP
858 UI_B PRIMARY
859
860 Unhinted UI read, shared lock
861 obj_type fragment_type
862 TABLE PRIMARY
863 UI_B PRIMARY
864
865 Unhinted UI read, exclusive lock
866 obj_type fragment_type
867 TABLE PRIMARY
868 UI_B PRIMARY
869
870 ****
871 Row with key : 20
872
873 Unhinted PK read, no lock
874 obj_type fragment_type
875 TABLE BACKUP
876 TABLE PRIMARY
877
878 Hinted PK read, no lock
879 obj_type fragment_type
880 TABLE BACKUP
881 TABLE PRIMARY
882
883 Unhinted PK read, shared lock
884 obj_type fragment_type
885 TABLE PRIMARY
886
887 Unhinted PK read, exclusive lock
888 obj_type fragment_type
889 TABLE PRIMARY
890
891 Unhinted UI read, no lock
892 obj_type fragment_type
893 TABLE BACKUP
894 TABLE PRIMARY
895 UI_B BACKUP
896 UI_B PRIMARY
897
898 Unhinted UI read, shared lock
899 obj_type fragment_type
900 TABLE PRIMARY
901 UI_B PRIMARY
902
903 Unhinted UI read, exclusive lock
904 obj_type fragment_type
905 TABLE PRIMARY
906 UI_B PRIMARY
907
908 ****
909 Row with key : 15
910
911 Unhinted PK read, no lock
912 obj_type fragment_type
913 TABLE BACKUP
914 TABLE PRIMARY
915
916 Hinted PK read, no lock
917 obj_type fragment_type
918 TABLE BACKUP
919 TABLE PRIMARY
920
921 Unhinted PK read, shared lock
922 obj_type fragment_type
923 TABLE PRIMARY
924
925 Unhinted PK read, exclusive lock
926 obj_type fragment_type
927 TABLE PRIMARY
928
929 Unhinted UI read, no lock
930 obj_type fragment_type
931 TABLE BACKUP
932 TABLE PRIMARY
933 UI_B BACKUP
934 UI_B PRIMARY
935
936 Unhinted UI read, shared lock
937 obj_type fragment_type
938 TABLE PRIMARY
939 UI_B PRIMARY
940
941 Unhinted UI read, exclusive lock
942 obj_type fragment_type
943 TABLE PRIMARY
944 UI_B PRIMARY
945
946 ****
947 Row with key : 10
948
949 Unhinted PK read, no lock
950 obj_type fragment_type
951 TABLE BACKUP
952 TABLE PRIMARY
953
954 Hinted PK read, no lock
955 obj_type fragment_type
956 TABLE BACKUP
957 TABLE PRIMARY
958
959 Unhinted PK read, shared lock
960 obj_type fragment_type
961 TABLE PRIMARY
962
963 Unhinted PK read, exclusive lock
964 obj_type fragment_type
965 TABLE PRIMARY
966
967 Unhinted UI read, no lock
968 obj_type fragment_type
969 TABLE BACKUP
970 TABLE PRIMARY
971 UI_B BACKUP
972 UI_B PRIMARY
973
974 Unhinted UI read, shared lock
975 obj_type fragment_type
976 TABLE PRIMARY
977 UI_B PRIMARY
978
979 Unhinted UI read, exclusive lock
980 obj_type fragment_type
981 TABLE PRIMARY
982 UI_B PRIMARY
983
984 ****
985 Row with key : 5
986
987 Unhinted PK read, no lock
988 obj_type fragment_type
989 TABLE BACKUP
990 TABLE PRIMARY
991
992 Hinted PK read, no lock
993 obj_type fragment_type
994 TABLE BACKUP
995 TABLE PRIMARY
996
997 Unhinted PK read, shared lock
998 obj_type fragment_type
999 TABLE PRIMARY
1000
1001 Unhinted PK read, exclusive lock
1002 obj_type fragment_type
1003 TABLE PRIMARY
1004
1005 Unhinted UI read, no lock
1006 obj_type fragment_type
1007 TABLE BACKUP
1008 TABLE PRIMARY
1009 UI_B BACKUP
1010 UI_B PRIMARY
1011
1012 Unhinted UI read, shared lock
1013 obj_type fragment_type
1014 TABLE PRIMARY
1015 UI_B PRIMARY
1016
1017 Unhinted UI read, exclusive lock
1018 obj_type fragment_type
1019 TABLE PRIMARY
1020 UI_B PRIMARY
1021
1022 *********
1023 Scans
1024
1025 Unhinted PK OI read, no lock
1026 obj_type fragment_type
1027 OI_PRIMARY BACKUP
1028 OI_PRIMARY PRIMARY
1029
1030 Unhinted PK OI read, shared lock
1031 obj_type fragment_type
1032 OI_PRIMARY PRIMARY
1033 TABLE PRIMARY
1034
1035 Unhinted PK OI read, exclusive lock
1036 obj_type fragment_type
1037 OI_PRIMARY PRIMARY
1038 TABLE PRIMARY
1039
1040 Table scan, no lock
1041 obj_type fragment_type
1042 TABLE BACKUP
1043 TABLE PRIMARY
1044
1045 Table scan, shared lock
1046 obj_type fragment_type
1047 TABLE PRIMARY
1048
1049 Table scan, exclusive lock
1050 obj_type fragment_type
1051 TABLE PRIMARY