Debian Codegraph @

mysql-test/suite/ndb_opt/bushy_joins.result

raw
1 Sending dump signal with data:
2 0x000003e9 0x00000001
3 Sending dump signal with data:
4 0x000003e9 0x00000001
5
6 create table parent(a int primary key, b int, c int, d int) engine=ndb;
7 create table eq_child(a int, b int, c int, d int, primary key(a,b)) engine=ndb;
8 create table ref_child(a int, b int, c int, d int, primary key(a,b)) engine=ndb;
9 alter table parent partition by key(a) partitions 32;
10 alter table eq_child partition by key(a) partitions 32;
11 alter table ref_child partition by key(a) partitions 32;
12 insert into parent values (1,1,1,1);
13 insert into parent select a+1, b+1, c+1, d+1 from parent;
14 insert into parent select a+1*2, b+1*2, c+1*2, d+1*2 from parent;
15 insert into parent select a+1*2*2, b+1*2*2, c+1*2*2, d+1*2*2 from parent;
16 insert into parent select a+1*2*2*2, b+1*2*2*2, c+1*2*2*2, d+1*2*2*2 from parent;
17 insert into parent select a+1*2*2*2*2, b+1*2*2*2*2, c+1*2*2*2*2, d+1*2*2*2*2 from parent;
18 insert into parent select a+1*2*2*2*2*2, b+1*2*2*2*2*2, c+1*2*2*2*2*2, d+1*2*2*2*2*2 from parent;
19 insert into parent select a+1*2*2*2*2*2*2, b+1*2*2*2*2*2*2, c+1*2*2*2*2*2*2, d+1*2*2*2*2*2*2 from parent;
20 insert into parent select a+1*2*2*2*2*2*2*2, b+1*2*2*2*2*2*2*2, c+1*2*2*2*2*2*2*2, d+1*2*2*2*2*2*2*2 from parent;
21 insert into parent select a+1*2*2*2*2*2*2*2*2, b+1*2*2*2*2*2*2*2*2, c+1*2*2*2*2*2*2*2*2, d+1*2*2*2*2*2*2*2*2 from parent;
22 insert into parent select a+1*2*2*2*2*2*2*2*2*2, b+1*2*2*2*2*2*2*2*2*2, c+1*2*2*2*2*2*2*2*2*2, d+1*2*2*2*2*2*2*2*2*2 from parent;
23 insert into parent select a+1*2*2*2*2*2*2*2*2*2*2, b+1*2*2*2*2*2*2*2*2*2*2, c+1*2*2*2*2*2*2*2*2*2*2, d+1*2*2*2*2*2*2*2*2*2*2 from parent;
24 insert into parent select a+1*2*2*2*2*2*2*2*2*2*2*2, b+1*2*2*2*2*2*2*2*2*2*2*2, c+1*2*2*2*2*2*2*2*2*2*2*2, d+1*2*2*2*2*2*2*2*2*2*2*2 from parent;
25 insert into parent select a+1*2*2*2*2*2*2*2*2*2*2*2*2, b+1*2*2*2*2*2*2*2*2*2*2*2*2, c+1*2*2*2*2*2*2*2*2*2*2*2*2, d+1*2*2*2*2*2*2*2*2*2*2*2*2 from parent;
26 select count(*) from parent;
27 count(*)
28 8192
29 insert into eq_child select * from parent;
30 insert into ref_child select * from parent;
31 update ref_child set a = a-(a%16) where a > 4000;
32 analyze table parent, eq_child, ref_child;
33 Table Op Msg_type Msg_text
34 test.parent analyze status OK
35 test.eq_child analyze status OK
36 test.ref_child analyze status OK
37 set ndb_join_pushdown = on;
38 ===============================
39 Run single instance of 'query1'
40 ===============================
41 explain select straight_join count(*) from parent
42 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
43 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
44 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
45 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
46 join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
47 join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
48 join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
49 join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
50 join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
51 join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
52 join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
53 join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
54 join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
55 join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
56 join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
57 join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
58 ;
59 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
60 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ALL NULL NULL NULL NULL 8192 100.00 Parent of 17 pushed join@1; Using pushed condition (`test`.`parent`.`b` is not null)
61 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
62 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
63 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
64 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
65 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
66 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
67 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
68 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
69 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
70 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
71 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
72 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
73 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
74 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
75 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
76 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
77 Warnings:
78 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`eq_child` `c1` join `test`.`eq_child` `c2` join `test`.`eq_child` `c3` join `test`.`eq_child` `c4` join `test`.`eq_child` `c5` join `test`.`eq_child` `c6` join `test`.`eq_child` `c7` join `test`.`eq_child` `c8` join `test`.`eq_child` `c9` join `test`.`eq_child` `c10` join `test`.`eq_child` `c11` join `test`.`eq_child` `c12` join `test`.`eq_child` `c13` join `test`.`eq_child` `c14` join `test`.`eq_child` `c15` join `test`.`eq_child` `c16` where ((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1`.`b` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`b` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`b` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`b` = `test`.`parent`.`b`) and (`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`b` = `test`.`parent`.`b`) and (`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`b` = `test`.`parent`.`b`) and (`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`b` = `test`.`parent`.`b`) and (`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`b` = `test`.`parent`.`b`) and (`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`b` = `test`.`parent`.`b`) and (`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`b` = `test`.`parent`.`b`) and (`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`b` = `test`.`parent`.`b`) and (`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`b` = `test`.`parent`.`b`) and (`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`b` = `test`.`parent`.`b`) and (`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`b` = `test`.`parent`.`b`) and (`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`b` = `test`.`parent`.`b`) and (`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`b` = `test`.`parent`.`b`))
79 select straight_join count(*) from parent
80 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
81 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
82 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
83 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
84 join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
85 join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
86 join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
87 join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
88 join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
89 join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
90 join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
91 join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
92 join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
93 join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
94 join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
95 join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
96 ;
97 count(*)
98 8192
99 ===============================
100 Run single instance of 'query2'
101 ===============================
102 explain select straight_join count(*) from parent
103 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
104 join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
105 join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
106 join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
107 join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
108 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
109 join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
110 join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
111 join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
112 join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
113 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
114 join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
115 join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
116 join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
117 join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
118 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
119 join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
120 join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
121 join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
122 join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
123 ;
124 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
125 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ALL NULL NULL NULL NULL 8192 100.00 Parent of 21 pushed join@1; Using pushed condition (`test`.`parent`.`b` is not null)
126 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1; Using pushed condition (`test`.`c1`.`c` is not null)
127 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
128 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
129 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
130 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
131 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1; Using pushed condition (`test`.`c2`.`c` is not null)
132 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
133 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
134 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
135 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
136 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1; Using pushed condition (`test`.`c3`.`c` is not null)
137 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
138 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
139 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
140 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
141 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1; Using pushed condition (`test`.`c4`.`c` is not null)
142 1 SIMPLE c17 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
143 1 SIMPLE c18 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
144 1 SIMPLE c19 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
145 1 SIMPLE c20 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
146 Warnings:
147 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`eq_child` `c1` join `test`.`eq_child` `c5` join `test`.`eq_child` `c6` join `test`.`eq_child` `c7` join `test`.`eq_child` `c8` join `test`.`eq_child` `c2` join `test`.`eq_child` `c9` join `test`.`eq_child` `c10` join `test`.`eq_child` `c11` join `test`.`eq_child` `c12` join `test`.`eq_child` `c3` join `test`.`eq_child` `c13` join `test`.`eq_child` `c14` join `test`.`eq_child` `c15` join `test`.`eq_child` `c16` join `test`.`eq_child` `c4` join `test`.`eq_child` `c17` join `test`.`eq_child` `c18` join `test`.`eq_child` `c19` join `test`.`eq_child` `c20` where ((`test`.`c5`.`a` = `test`.`c1`.`c`) and (`test`.`c5`.`b` = `test`.`c1`.`c`) and (`test`.`c6`.`a` = `test`.`c1`.`c`) and (`test`.`c6`.`b` = `test`.`c1`.`c`) and (`test`.`c7`.`a` = `test`.`c1`.`c`) and (`test`.`c7`.`b` = `test`.`c1`.`c`) and (`test`.`c8`.`a` = `test`.`c1`.`c`) and (`test`.`c8`.`b` = `test`.`c1`.`c`) and (`test`.`c9`.`a` = `test`.`c2`.`c`) and (`test`.`c9`.`b` = `test`.`c2`.`c`) and (`test`.`c10`.`a` = `test`.`c2`.`c`) and (`test`.`c10`.`b` = `test`.`c2`.`c`) and (`test`.`c11`.`a` = `test`.`c2`.`c`) and (`test`.`c11`.`b` = `test`.`c2`.`c`) and (`test`.`c12`.`a` = `test`.`c2`.`c`) and (`test`.`c12`.`b` = `test`.`c2`.`c`) and (`test`.`c13`.`a` = `test`.`c3`.`c`) and (`test`.`c13`.`b` = `test`.`c3`.`c`) and (`test`.`c14`.`a` = `test`.`c3`.`c`) and (`test`.`c14`.`b` = `test`.`c3`.`c`) and (`test`.`c15`.`a` = `test`.`c3`.`c`) and (`test`.`c15`.`b` = `test`.`c3`.`c`) and (`test`.`c16`.`a` = `test`.`c3`.`c`) and (`test`.`c16`.`b` = `test`.`c3`.`c`) and (`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1`.`b` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`b` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`b` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`b` = `test`.`parent`.`b`) and (`test`.`c17`.`a` = `test`.`c4`.`c`) and (`test`.`c17`.`b` = `test`.`c4`.`c`) and (`test`.`c18`.`a` = `test`.`c4`.`c`) and (`test`.`c18`.`b` = `test`.`c4`.`c`) and (`test`.`c19`.`a` = `test`.`c4`.`c`) and (`test`.`c19`.`b` = `test`.`c4`.`c`) and (`test`.`c20`.`a` = `test`.`c4`.`c`) and (`test`.`c20`.`b` = `test`.`c4`.`c`))
148 select straight_join count(*) from parent
149 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
150 join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
151 join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
152 join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
153 join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
154 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
155 join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
156 join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
157 join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
158 join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
159 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
160 join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
161 join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
162 join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
163 join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
164 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
165 join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
166 join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
167 join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
168 join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
169 ;
170 count(*)
171 8192
172 ===============================
173 Run single instance of 'query3'
174 ===============================
175 explain select straight_join count(*) from parent
176 join ref_child as c1 on c1.a = parent.b
177 join ref_child as c2 on c2.a = parent.b
178 join ref_child as c3 on c3.a = parent.b
179 join ref_child as c4 on c4.a = parent.b
180 join ref_child as c5 on c5.a = parent.b
181 join ref_child as c6 on c6.a = parent.b
182 join ref_child as c7 on c7.a = parent.b
183 join ref_child as c8 on c8.a = parent.b
184 join ref_child as c9 on c9.a = parent.b
185 join ref_child as c10 on c10.a = parent.b
186 join ref_child as c11 on c11.a = parent.b
187 join ref_child as c12 on c12.a = parent.b
188 join ref_child as c13 on c13.a = parent.b
189 join ref_child as c14 on c14.a = parent.b
190 join ref_child as c15 on c15.a = parent.b
191 join ref_child as c16 on c16.a = parent.b
192 where parent.a < 1000
193 ;
194 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
195 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 range PRIMARY PRIMARY 4 NULL ### ### Parent of 17 pushed join@1; Using pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null)); Using MRR
196 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
197 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
198 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
199 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
200 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
201 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
202 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
203 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
204 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
205 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
206 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
207 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
208 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
209 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
210 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
211 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
212 Warnings:
213 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`ref_child` `c1` join `test`.`ref_child` `c2` join `test`.`ref_child` `c3` join `test`.`ref_child` `c4` join `test`.`ref_child` `c5` join `test`.`ref_child` `c6` join `test`.`ref_child` `c7` join `test`.`ref_child` `c8` join `test`.`ref_child` `c9` join `test`.`ref_child` `c10` join `test`.`ref_child` `c11` join `test`.`ref_child` `c12` join `test`.`ref_child` `c13` join `test`.`ref_child` `c14` join `test`.`ref_child` `c15` join `test`.`ref_child` `c16` where ((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`parent`.`a` < 1000))
214 select straight_join count(*) from parent
215 join ref_child as c1 on c1.a = parent.b
216 join ref_child as c2 on c2.a = parent.b
217 join ref_child as c3 on c3.a = parent.b
218 join ref_child as c4 on c4.a = parent.b
219 join ref_child as c5 on c5.a = parent.b
220 join ref_child as c6 on c6.a = parent.b
221 join ref_child as c7 on c7.a = parent.b
222 join ref_child as c8 on c8.a = parent.b
223 join ref_child as c9 on c9.a = parent.b
224 join ref_child as c10 on c10.a = parent.b
225 join ref_child as c11 on c11.a = parent.b
226 join ref_child as c12 on c12.a = parent.b
227 join ref_child as c13 on c13.a = parent.b
228 join ref_child as c14 on c14.a = parent.b
229 join ref_child as c15 on c15.a = parent.b
230 join ref_child as c16 on c16.a = parent.b
231 where parent.a < 1000
232 ;
233 count(*)
234 999
235 ===============================
236 Run single instance of 'query4'
237 ===============================
238 explain select straight_join count(*) from parent
239 join ref_child as c1 on c1.a = parent.b
240 join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
241 join ref_child as c2 on c2.a = parent.b
242 join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
243 join ref_child as c3 on c3.a = parent.b
244 join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
245 join ref_child as c4 on c4.a = parent.b
246 join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
247 join ref_child as c5 on c5.a = parent.b
248 join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
249 join ref_child as c6 on c6.a = parent.b
250 join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
251 join ref_child as c7 on c7.a = parent.b
252 join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
253 join ref_child as c8 on c8.a = parent.b
254 join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
255 join ref_child as c9 on c9.a = parent.b
256 join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
257 join ref_child as c10 on c10.a = parent.b
258 join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
259 join ref_child as c11 on c11.a = parent.b
260 join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
261 join ref_child as c12 on c12.a = parent.b
262 join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
263 join ref_child as c13 on c13.a = parent.b
264 join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
265 join ref_child as c14 on c14.a = parent.b
266 join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
267 join ref_child as c15 on c15.a = parent.b
268 join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
269 join ref_child as c16 on c16.a = parent.b
270 join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
271 where parent.a < 1000
272 ;
273 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
274 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 range PRIMARY PRIMARY 4 NULL ### ### Parent of 32 pushed join@1; Using pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null)); Using MRR
275 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
276 1 SIMPLE c1eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c1.b ### ### Child of 'c1' in pushed join@1
277 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
278 1 SIMPLE c2eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c2.b ### ### Child of 'c2' in pushed join@1
279 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
280 1 SIMPLE c3eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c3.b ### ### Child of 'c3' in pushed join@1
281 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
282 1 SIMPLE c4eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c4.b ### ### Child of 'c4' in pushed join@1
283 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
284 1 SIMPLE c5eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c5.b ### ### Child of 'c5' in pushed join@1
285 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
286 1 SIMPLE c6eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c6.b ### ### Child of 'c6' in pushed join@1
287 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
288 1 SIMPLE c7eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c7.b ### ### Child of 'c7' in pushed join@1
289 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
290 1 SIMPLE c8eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c8.b ### ### Child of 'c8' in pushed join@1
291 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
292 1 SIMPLE c9eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c9.b ### ### Child of 'c9' in pushed join@1
293 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
294 1 SIMPLE c10eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c10.b ### ### Child of 'c10' in pushed join@1
295 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
296 1 SIMPLE c11eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c11.b ### ### Child of 'c11' in pushed join@1
297 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
298 1 SIMPLE c12eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c12.b ### ### Child of 'c12' in pushed join@1
299 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
300 1 SIMPLE c13eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c13.b ### ### Child of 'c13' in pushed join@1
301 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
302 1 SIMPLE c14eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c14.b ### ### Child of 'c14' in pushed join@1
303 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
304 1 SIMPLE c15eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c15.b ### ### Child of 'c15' in pushed join@1
305 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
306 1 SIMPLE c16eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c16.b ### ### NULL
307 Warnings:
308 Note 1003 Can't push table 'c16eq' as child of 'parent'. Max number of pushable tables exceeded.
309 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`ref_child` `c1` join `test`.`eq_child` `c1eq` join `test`.`ref_child` `c2` join `test`.`eq_child` `c2eq` join `test`.`ref_child` `c3` join `test`.`eq_child` `c3eq` join `test`.`ref_child` `c4` join `test`.`eq_child` `c4eq` join `test`.`ref_child` `c5` join `test`.`eq_child` `c5eq` join `test`.`ref_child` `c6` join `test`.`eq_child` `c6eq` join `test`.`ref_child` `c7` join `test`.`eq_child` `c7eq` join `test`.`ref_child` `c8` join `test`.`eq_child` `c8eq` join `test`.`ref_child` `c9` join `test`.`eq_child` `c9eq` join `test`.`ref_child` `c10` join `test`.`eq_child` `c10eq` join `test`.`ref_child` `c11` join `test`.`eq_child` `c11eq` join `test`.`ref_child` `c12` join `test`.`eq_child` `c12eq` join `test`.`ref_child` `c13` join `test`.`eq_child` `c13eq` join `test`.`ref_child` `c14` join `test`.`eq_child` `c14eq` join `test`.`ref_child` `c15` join `test`.`eq_child` `c15eq` join `test`.`ref_child` `c16` join `test`.`eq_child` `c16eq` where ((`test`.`c1eq`.`b` = `test`.`c1`.`b`) and (`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1eq`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2eq`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3eq`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4eq`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c5eq`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c6eq`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c7eq`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c8eq`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c9eq`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c10eq`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c11eq`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c12eq`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c13eq`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c14eq`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c15eq`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`c16eq`.`a` = `test`.`parent`.`b`) and (`test`.`c2eq`.`b` = `test`.`c2`.`b`) and (`test`.`c3eq`.`b` = `test`.`c3`.`b`) and (`test`.`c4eq`.`b` = `test`.`c4`.`b`) and (`test`.`c5eq`.`b` = `test`.`c5`.`b`) and (`test`.`c6eq`.`b` = `test`.`c6`.`b`) and (`test`.`c7eq`.`b` = `test`.`c7`.`b`) and (`test`.`c8eq`.`b` = `test`.`c8`.`b`) and (`test`.`c9eq`.`b` = `test`.`c9`.`b`) and (`test`.`c10eq`.`b` = `test`.`c10`.`b`) and (`test`.`c11eq`.`b` = `test`.`c11`.`b`) and (`test`.`c12eq`.`b` = `test`.`c12`.`b`) and (`test`.`c13eq`.`b` = `test`.`c13`.`b`) and (`test`.`c14eq`.`b` = `test`.`c14`.`b`) and (`test`.`c15eq`.`b` = `test`.`c15`.`b`) and (`test`.`c16eq`.`b` = `test`.`c16`.`b`) and (`test`.`parent`.`a` < 1000))
310 select straight_join count(*) from parent
311 join ref_child as c1 on c1.a = parent.b
312 join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
313 join ref_child as c2 on c2.a = parent.b
314 join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
315 join ref_child as c3 on c3.a = parent.b
316 join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
317 join ref_child as c4 on c4.a = parent.b
318 join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
319 join ref_child as c5 on c5.a = parent.b
320 join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
321 join ref_child as c6 on c6.a = parent.b
322 join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
323 join ref_child as c7 on c7.a = parent.b
324 join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
325 join ref_child as c8 on c8.a = parent.b
326 join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
327 join ref_child as c9 on c9.a = parent.b
328 join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
329 join ref_child as c10 on c10.a = parent.b
330 join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
331 join ref_child as c11 on c11.a = parent.b
332 join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
333 join ref_child as c12 on c12.a = parent.b
334 join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
335 join ref_child as c13 on c13.a = parent.b
336 join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
337 join ref_child as c14 on c14.a = parent.b
338 join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
339 join ref_child as c15 on c15.a = parent.b
340 join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
341 join ref_child as c16 on c16.a = parent.b
342 join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
343 where parent.a < 1000
344 ;
345 count(*)
346 999
347 =================================
348 Run multiple 'query1' in parallel
349 =================================
350 explain select straight_join count(*) from parent
351 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
352 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
353 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
354 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
355 join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
356 join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
357 join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
358 join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
359 join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
360 join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
361 join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
362 join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
363 join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
364 join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
365 join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
366 join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
367 ;
368 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
369 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ALL NULL NULL NULL NULL 8192 100.00 Parent of 17 pushed join@1; Using pushed condition (`test`.`parent`.`b` is not null)
370 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
371 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
372 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
373 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
374 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
375 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
376 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
377 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
378 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
379 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
380 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
381 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
382 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
383 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
384 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
385 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
386 Warnings:
387 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`eq_child` `c1` join `test`.`eq_child` `c2` join `test`.`eq_child` `c3` join `test`.`eq_child` `c4` join `test`.`eq_child` `c5` join `test`.`eq_child` `c6` join `test`.`eq_child` `c7` join `test`.`eq_child` `c8` join `test`.`eq_child` `c9` join `test`.`eq_child` `c10` join `test`.`eq_child` `c11` join `test`.`eq_child` `c12` join `test`.`eq_child` `c13` join `test`.`eq_child` `c14` join `test`.`eq_child` `c15` join `test`.`eq_child` `c16` where ((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1`.`b` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`b` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`b` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`b` = `test`.`parent`.`b`) and (`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`b` = `test`.`parent`.`b`) and (`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`b` = `test`.`parent`.`b`) and (`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`b` = `test`.`parent`.`b`) and (`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`b` = `test`.`parent`.`b`) and (`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`b` = `test`.`parent`.`b`) and (`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`b` = `test`.`parent`.`b`) and (`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`b` = `test`.`parent`.`b`) and (`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`b` = `test`.`parent`.`b`) and (`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`b` = `test`.`parent`.`b`) and (`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`b` = `test`.`parent`.`b`) and (`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`b` = `test`.`parent`.`b`) and (`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`b` = `test`.`parent`.`b`))
388 select straight_join count(*) from parent
389 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
390 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
391 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
392 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
393 join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
394 join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
395 join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
396 join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
397 join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
398 join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
399 join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
400 join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
401 join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
402 join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
403 join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
404 join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
405 ;
406 select straight_join count(*) from parent
407 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
408 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
409 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
410 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
411 join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
412 join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
413 join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
414 join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
415 join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
416 join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
417 join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
418 join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
419 join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
420 join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
421 join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
422 join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
423 ;
424 select straight_join count(*) from parent
425 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
426 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
427 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
428 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
429 join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
430 join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
431 join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
432 join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
433 join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
434 join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
435 join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
436 join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
437 join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
438 join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
439 join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
440 join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
441 ;
442 Await completion or failure
443 count(*)
444 8192
445 count(*)
446 8192
447 count(*)
448 8192
449 =================================
450 Run multiple 'query2' in parallel
451 =================================
452 explain select straight_join count(*) from parent
453 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
454 join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
455 join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
456 join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
457 join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
458 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
459 join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
460 join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
461 join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
462 join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
463 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
464 join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
465 join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
466 join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
467 join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
468 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
469 join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
470 join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
471 join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
472 join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
473 ;
474 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
475 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ALL NULL NULL NULL NULL 8192 100.00 Parent of 21 pushed join@1; Using pushed condition (`test`.`parent`.`b` is not null)
476 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1; Using pushed condition (`test`.`c1`.`c` is not null)
477 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
478 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
479 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
480 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
481 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1; Using pushed condition (`test`.`c2`.`c` is not null)
482 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
483 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
484 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
485 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
486 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1; Using pushed condition (`test`.`c3`.`c` is not null)
487 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
488 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
489 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
490 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
491 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1; Using pushed condition (`test`.`c4`.`c` is not null)
492 1 SIMPLE c17 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
493 1 SIMPLE c18 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
494 1 SIMPLE c19 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
495 1 SIMPLE c20 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
496 Warnings:
497 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`eq_child` `c1` join `test`.`eq_child` `c5` join `test`.`eq_child` `c6` join `test`.`eq_child` `c7` join `test`.`eq_child` `c8` join `test`.`eq_child` `c2` join `test`.`eq_child` `c9` join `test`.`eq_child` `c10` join `test`.`eq_child` `c11` join `test`.`eq_child` `c12` join `test`.`eq_child` `c3` join `test`.`eq_child` `c13` join `test`.`eq_child` `c14` join `test`.`eq_child` `c15` join `test`.`eq_child` `c16` join `test`.`eq_child` `c4` join `test`.`eq_child` `c17` join `test`.`eq_child` `c18` join `test`.`eq_child` `c19` join `test`.`eq_child` `c20` where ((`test`.`c5`.`a` = `test`.`c1`.`c`) and (`test`.`c5`.`b` = `test`.`c1`.`c`) and (`test`.`c6`.`a` = `test`.`c1`.`c`) and (`test`.`c6`.`b` = `test`.`c1`.`c`) and (`test`.`c7`.`a` = `test`.`c1`.`c`) and (`test`.`c7`.`b` = `test`.`c1`.`c`) and (`test`.`c8`.`a` = `test`.`c1`.`c`) and (`test`.`c8`.`b` = `test`.`c1`.`c`) and (`test`.`c9`.`a` = `test`.`c2`.`c`) and (`test`.`c9`.`b` = `test`.`c2`.`c`) and (`test`.`c10`.`a` = `test`.`c2`.`c`) and (`test`.`c10`.`b` = `test`.`c2`.`c`) and (`test`.`c11`.`a` = `test`.`c2`.`c`) and (`test`.`c11`.`b` = `test`.`c2`.`c`) and (`test`.`c12`.`a` = `test`.`c2`.`c`) and (`test`.`c12`.`b` = `test`.`c2`.`c`) and (`test`.`c13`.`a` = `test`.`c3`.`c`) and (`test`.`c13`.`b` = `test`.`c3`.`c`) and (`test`.`c14`.`a` = `test`.`c3`.`c`) and (`test`.`c14`.`b` = `test`.`c3`.`c`) and (`test`.`c15`.`a` = `test`.`c3`.`c`) and (`test`.`c15`.`b` = `test`.`c3`.`c`) and (`test`.`c16`.`a` = `test`.`c3`.`c`) and (`test`.`c16`.`b` = `test`.`c3`.`c`) and (`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1`.`b` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`b` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`b` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`b` = `test`.`parent`.`b`) and (`test`.`c17`.`a` = `test`.`c4`.`c`) and (`test`.`c17`.`b` = `test`.`c4`.`c`) and (`test`.`c18`.`a` = `test`.`c4`.`c`) and (`test`.`c18`.`b` = `test`.`c4`.`c`) and (`test`.`c19`.`a` = `test`.`c4`.`c`) and (`test`.`c19`.`b` = `test`.`c4`.`c`) and (`test`.`c20`.`a` = `test`.`c4`.`c`) and (`test`.`c20`.`b` = `test`.`c4`.`c`))
498 select straight_join count(*) from parent
499 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
500 join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
501 join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
502 join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
503 join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
504 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
505 join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
506 join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
507 join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
508 join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
509 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
510 join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
511 join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
512 join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
513 join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
514 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
515 join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
516 join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
517 join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
518 join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
519 ;
520 select straight_join count(*) from parent
521 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
522 join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
523 join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
524 join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
525 join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
526 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
527 join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
528 join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
529 join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
530 join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
531 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
532 join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
533 join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
534 join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
535 join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
536 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
537 join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
538 join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
539 join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
540 join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
541 ;
542 select straight_join count(*) from parent
543 join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
544 join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
545 join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
546 join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
547 join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
548 join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
549 join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
550 join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
551 join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
552 join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
553 join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
554 join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
555 join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
556 join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
557 join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
558 join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
559 join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
560 join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
561 join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
562 join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
563 ;
564 Await completion or failure
565 count(*)
566 8192
567 count(*)
568 8192
569 count(*)
570 8192
571 =================================
572 Run multiple 'query3' in parallel
573 =================================
574 explain select straight_join count(*) from parent
575 join ref_child as c1 on c1.a = parent.b
576 join ref_child as c2 on c2.a = parent.b
577 join ref_child as c3 on c3.a = parent.b
578 join ref_child as c4 on c4.a = parent.b
579 join ref_child as c5 on c5.a = parent.b
580 join ref_child as c6 on c6.a = parent.b
581 join ref_child as c7 on c7.a = parent.b
582 join ref_child as c8 on c8.a = parent.b
583 join ref_child as c9 on c9.a = parent.b
584 join ref_child as c10 on c10.a = parent.b
585 join ref_child as c11 on c11.a = parent.b
586 join ref_child as c12 on c12.a = parent.b
587 join ref_child as c13 on c13.a = parent.b
588 join ref_child as c14 on c14.a = parent.b
589 join ref_child as c15 on c15.a = parent.b
590 join ref_child as c16 on c16.a = parent.b
591 where parent.a < 1000
592 ;
593 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
594 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 range PRIMARY PRIMARY 4 NULL ### ### Parent of 17 pushed join@1; Using pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null)); Using MRR
595 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
596 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
597 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
598 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
599 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
600 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
601 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
602 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
603 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
604 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
605 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
606 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
607 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
608 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
609 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
610 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
611 Warnings:
612 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`ref_child` `c1` join `test`.`ref_child` `c2` join `test`.`ref_child` `c3` join `test`.`ref_child` `c4` join `test`.`ref_child` `c5` join `test`.`ref_child` `c6` join `test`.`ref_child` `c7` join `test`.`ref_child` `c8` join `test`.`ref_child` `c9` join `test`.`ref_child` `c10` join `test`.`ref_child` `c11` join `test`.`ref_child` `c12` join `test`.`ref_child` `c13` join `test`.`ref_child` `c14` join `test`.`ref_child` `c15` join `test`.`ref_child` `c16` where ((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`parent`.`a` < 1000))
613 select straight_join count(*) from parent
614 join ref_child as c1 on c1.a = parent.b
615 join ref_child as c2 on c2.a = parent.b
616 join ref_child as c3 on c3.a = parent.b
617 join ref_child as c4 on c4.a = parent.b
618 join ref_child as c5 on c5.a = parent.b
619 join ref_child as c6 on c6.a = parent.b
620 join ref_child as c7 on c7.a = parent.b
621 join ref_child as c8 on c8.a = parent.b
622 join ref_child as c9 on c9.a = parent.b
623 join ref_child as c10 on c10.a = parent.b
624 join ref_child as c11 on c11.a = parent.b
625 join ref_child as c12 on c12.a = parent.b
626 join ref_child as c13 on c13.a = parent.b
627 join ref_child as c14 on c14.a = parent.b
628 join ref_child as c15 on c15.a = parent.b
629 join ref_child as c16 on c16.a = parent.b
630 where parent.a < 1000
631 ;
632 select straight_join count(*) from parent
633 join ref_child as c1 on c1.a = parent.b
634 join ref_child as c2 on c2.a = parent.b
635 join ref_child as c3 on c3.a = parent.b
636 join ref_child as c4 on c4.a = parent.b
637 join ref_child as c5 on c5.a = parent.b
638 join ref_child as c6 on c6.a = parent.b
639 join ref_child as c7 on c7.a = parent.b
640 join ref_child as c8 on c8.a = parent.b
641 join ref_child as c9 on c9.a = parent.b
642 join ref_child as c10 on c10.a = parent.b
643 join ref_child as c11 on c11.a = parent.b
644 join ref_child as c12 on c12.a = parent.b
645 join ref_child as c13 on c13.a = parent.b
646 join ref_child as c14 on c14.a = parent.b
647 join ref_child as c15 on c15.a = parent.b
648 join ref_child as c16 on c16.a = parent.b
649 where parent.a < 1000
650 ;
651 select straight_join count(*) from parent
652 join ref_child as c1 on c1.a = parent.b
653 join ref_child as c2 on c2.a = parent.b
654 join ref_child as c3 on c3.a = parent.b
655 join ref_child as c4 on c4.a = parent.b
656 join ref_child as c5 on c5.a = parent.b
657 join ref_child as c6 on c6.a = parent.b
658 join ref_child as c7 on c7.a = parent.b
659 join ref_child as c8 on c8.a = parent.b
660 join ref_child as c9 on c9.a = parent.b
661 join ref_child as c10 on c10.a = parent.b
662 join ref_child as c11 on c11.a = parent.b
663 join ref_child as c12 on c12.a = parent.b
664 join ref_child as c13 on c13.a = parent.b
665 join ref_child as c14 on c14.a = parent.b
666 join ref_child as c15 on c15.a = parent.b
667 join ref_child as c16 on c16.a = parent.b
668 where parent.a < 1000
669 ;
670 Await completion or failure
671 count(*)
672 999
673 count(*)
674 999
675 count(*)
676 999
677 =================================
678 Run multiple 'query4' in parallel
679 =================================
680 explain select straight_join count(*) from parent
681 join ref_child as c1 on c1.a = parent.b
682 join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
683 join ref_child as c2 on c2.a = parent.b
684 join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
685 join ref_child as c3 on c3.a = parent.b
686 join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
687 join ref_child as c4 on c4.a = parent.b
688 join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
689 join ref_child as c5 on c5.a = parent.b
690 join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
691 join ref_child as c6 on c6.a = parent.b
692 join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
693 join ref_child as c7 on c7.a = parent.b
694 join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
695 join ref_child as c8 on c8.a = parent.b
696 join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
697 join ref_child as c9 on c9.a = parent.b
698 join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
699 join ref_child as c10 on c10.a = parent.b
700 join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
701 join ref_child as c11 on c11.a = parent.b
702 join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
703 join ref_child as c12 on c12.a = parent.b
704 join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
705 join ref_child as c13 on c13.a = parent.b
706 join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
707 join ref_child as c14 on c14.a = parent.b
708 join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
709 join ref_child as c15 on c15.a = parent.b
710 join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
711 join ref_child as c16 on c16.a = parent.b
712 join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
713 where parent.a < 1000
714 ;
715 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
716 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 range PRIMARY PRIMARY 4 NULL ### ### Parent of 32 pushed join@1; Using pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null)); Using MRR
717 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
718 1 SIMPLE c1eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c1.b ### ### Child of 'c1' in pushed join@1
719 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
720 1 SIMPLE c2eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c2.b ### ### Child of 'c2' in pushed join@1
721 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
722 1 SIMPLE c3eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c3.b ### ### Child of 'c3' in pushed join@1
723 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
724 1 SIMPLE c4eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c4.b ### ### Child of 'c4' in pushed join@1
725 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
726 1 SIMPLE c5eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c5.b ### ### Child of 'c5' in pushed join@1
727 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
728 1 SIMPLE c6eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c6.b ### ### Child of 'c6' in pushed join@1
729 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
730 1 SIMPLE c7eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c7.b ### ### Child of 'c7' in pushed join@1
731 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
732 1 SIMPLE c8eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c8.b ### ### Child of 'c8' in pushed join@1
733 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
734 1 SIMPLE c9eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c9.b ### ### Child of 'c9' in pushed join@1
735 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
736 1 SIMPLE c10eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c10.b ### ### Child of 'c10' in pushed join@1
737 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
738 1 SIMPLE c11eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c11.b ### ### Child of 'c11' in pushed join@1
739 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
740 1 SIMPLE c12eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c12.b ### ### Child of 'c12' in pushed join@1
741 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
742 1 SIMPLE c13eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c13.b ### ### Child of 'c13' in pushed join@1
743 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
744 1 SIMPLE c14eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c14.b ### ### Child of 'c14' in pushed join@1
745 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
746 1 SIMPLE c15eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c15.b ### ### Child of 'c15' in pushed join@1
747 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
748 1 SIMPLE c16eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c16.b ### ### NULL
749 Warnings:
750 Note 1003 Can't push table 'c16eq' as child of 'parent'. Max number of pushable tables exceeded.
751 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`ref_child` `c1` join `test`.`eq_child` `c1eq` join `test`.`ref_child` `c2` join `test`.`eq_child` `c2eq` join `test`.`ref_child` `c3` join `test`.`eq_child` `c3eq` join `test`.`ref_child` `c4` join `test`.`eq_child` `c4eq` join `test`.`ref_child` `c5` join `test`.`eq_child` `c5eq` join `test`.`ref_child` `c6` join `test`.`eq_child` `c6eq` join `test`.`ref_child` `c7` join `test`.`eq_child` `c7eq` join `test`.`ref_child` `c8` join `test`.`eq_child` `c8eq` join `test`.`ref_child` `c9` join `test`.`eq_child` `c9eq` join `test`.`ref_child` `c10` join `test`.`eq_child` `c10eq` join `test`.`ref_child` `c11` join `test`.`eq_child` `c11eq` join `test`.`ref_child` `c12` join `test`.`eq_child` `c12eq` join `test`.`ref_child` `c13` join `test`.`eq_child` `c13eq` join `test`.`ref_child` `c14` join `test`.`eq_child` `c14eq` join `test`.`ref_child` `c15` join `test`.`eq_child` `c15eq` join `test`.`ref_child` `c16` join `test`.`eq_child` `c16eq` where ((`test`.`c1eq`.`b` = `test`.`c1`.`b`) and (`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1eq`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2eq`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3eq`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4eq`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c5eq`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c6eq`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c7eq`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c8eq`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c9eq`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c10eq`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c11eq`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c12eq`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c13eq`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c14eq`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c15eq`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`c16eq`.`a` = `test`.`parent`.`b`) and (`test`.`c2eq`.`b` = `test`.`c2`.`b`) and (`test`.`c3eq`.`b` = `test`.`c3`.`b`) and (`test`.`c4eq`.`b` = `test`.`c4`.`b`) and (`test`.`c5eq`.`b` = `test`.`c5`.`b`) and (`test`.`c6eq`.`b` = `test`.`c6`.`b`) and (`test`.`c7eq`.`b` = `test`.`c7`.`b`) and (`test`.`c8eq`.`b` = `test`.`c8`.`b`) and (`test`.`c9eq`.`b` = `test`.`c9`.`b`) and (`test`.`c10eq`.`b` = `test`.`c10`.`b`) and (`test`.`c11eq`.`b` = `test`.`c11`.`b`) and (`test`.`c12eq`.`b` = `test`.`c12`.`b`) and (`test`.`c13eq`.`b` = `test`.`c13`.`b`) and (`test`.`c14eq`.`b` = `test`.`c14`.`b`) and (`test`.`c15eq`.`b` = `test`.`c15`.`b`) and (`test`.`c16eq`.`b` = `test`.`c16`.`b`) and (`test`.`parent`.`a` < 1000))
752 select straight_join count(*) from parent
753 join ref_child as c1 on c1.a = parent.b
754 join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
755 join ref_child as c2 on c2.a = parent.b
756 join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
757 join ref_child as c3 on c3.a = parent.b
758 join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
759 join ref_child as c4 on c4.a = parent.b
760 join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
761 join ref_child as c5 on c5.a = parent.b
762 join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
763 join ref_child as c6 on c6.a = parent.b
764 join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
765 join ref_child as c7 on c7.a = parent.b
766 join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
767 join ref_child as c8 on c8.a = parent.b
768 join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
769 join ref_child as c9 on c9.a = parent.b
770 join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
771 join ref_child as c10 on c10.a = parent.b
772 join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
773 join ref_child as c11 on c11.a = parent.b
774 join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
775 join ref_child as c12 on c12.a = parent.b
776 join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
777 join ref_child as c13 on c13.a = parent.b
778 join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
779 join ref_child as c14 on c14.a = parent.b
780 join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
781 join ref_child as c15 on c15.a = parent.b
782 join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
783 join ref_child as c16 on c16.a = parent.b
784 join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
785 where parent.a < 1000
786 ;
787 select straight_join count(*) from parent
788 join ref_child as c1 on c1.a = parent.b
789 join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
790 join ref_child as c2 on c2.a = parent.b
791 join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
792 join ref_child as c3 on c3.a = parent.b
793 join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
794 join ref_child as c4 on c4.a = parent.b
795 join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
796 join ref_child as c5 on c5.a = parent.b
797 join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
798 join ref_child as c6 on c6.a = parent.b
799 join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
800 join ref_child as c7 on c7.a = parent.b
801 join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
802 join ref_child as c8 on c8.a = parent.b
803 join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
804 join ref_child as c9 on c9.a = parent.b
805 join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
806 join ref_child as c10 on c10.a = parent.b
807 join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
808 join ref_child as c11 on c11.a = parent.b
809 join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
810 join ref_child as c12 on c12.a = parent.b
811 join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
812 join ref_child as c13 on c13.a = parent.b
813 join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
814 join ref_child as c14 on c14.a = parent.b
815 join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
816 join ref_child as c15 on c15.a = parent.b
817 join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
818 join ref_child as c16 on c16.a = parent.b
819 join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
820 where parent.a < 1000
821 ;
822 select straight_join count(*) from parent
823 join ref_child as c1 on c1.a = parent.b
824 join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
825 join ref_child as c2 on c2.a = parent.b
826 join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
827 join ref_child as c3 on c3.a = parent.b
828 join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
829 join ref_child as c4 on c4.a = parent.b
830 join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
831 join ref_child as c5 on c5.a = parent.b
832 join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
833 join ref_child as c6 on c6.a = parent.b
834 join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
835 join ref_child as c7 on c7.a = parent.b
836 join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
837 join ref_child as c8 on c8.a = parent.b
838 join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
839 join ref_child as c9 on c9.a = parent.b
840 join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
841 join ref_child as c10 on c10.a = parent.b
842 join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
843 join ref_child as c11 on c11.a = parent.b
844 join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
845 join ref_child as c12 on c12.a = parent.b
846 join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
847 join ref_child as c13 on c13.a = parent.b
848 join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
849 join ref_child as c14 on c14.a = parent.b
850 join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
851 join ref_child as c15 on c15.a = parent.b
852 join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
853 join ref_child as c16 on c16.a = parent.b
854 join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
855 where parent.a < 1000
856 ;
857 Await completion or failure
858 count(*)
859 999
860 count(*)
861 999
862 count(*)
863 999
864 =================================
865 Repeat most of testing with
866 outer join variants of the query.
867 =================================
868 set ndb_join_pushdown = on;
869 ===============================
870 Run single instance of 'query1'
871 ===============================
872 explain select straight_join count(*) from parent
873 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
874 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
875 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
876 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
877 left join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
878 left join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
879 left join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
880 left join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
881 left join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
882 left join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
883 left join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
884 left join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
885 left join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
886 left join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
887 left join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
888 left join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
889 ;
890 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
891 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ALL NULL NULL NULL NULL 8192 100.00 Parent of 17 pushed join@1
892 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
893 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
894 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
895 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
896 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
897 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
898 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
899 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
900 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
901 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
902 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
903 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
904 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
905 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
906 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
907 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
908 Warnings:
909 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` left join `test`.`eq_child` `c1` on(((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c2` on(((`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c3` on(((`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c4` on(((`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c5` on(((`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c6` on(((`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c7` on(((`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c8` on(((`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c9` on(((`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c10` on(((`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c11` on(((`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c12` on(((`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c13` on(((`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c14` on(((`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c15` on(((`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c16` on(((`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`b` = `test`.`parent`.`b`))) where true
910 select straight_join count(*) from parent
911 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
912 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
913 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
914 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
915 left join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
916 left join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
917 left join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
918 left join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
919 left join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
920 left join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
921 left join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
922 left join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
923 left join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
924 left join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
925 left join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
926 left join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
927 ;
928 count(*)
929 8192
930 ===============================
931 Run single instance of 'query2'
932 ===============================
933 explain select straight_join count(*) from parent
934 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
935 left join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
936 left join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
937 left join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
938 left join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
939 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
940 left join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
941 left join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
942 left join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
943 left join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
944 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
945 left join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
946 left join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
947 left join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
948 left join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
949 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
950 left join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
951 left join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
952 left join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
953 left join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
954 ;
955 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
956 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ALL NULL NULL NULL NULL 8192 100.00 Parent of 21 pushed join@1
957 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
958 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
959 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
960 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
961 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
962 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
963 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
964 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
965 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
966 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
967 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
968 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
969 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
970 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
971 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
972 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
973 1 SIMPLE c17 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
974 1 SIMPLE c18 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
975 1 SIMPLE c19 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
976 1 SIMPLE c20 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
977 Warnings:
978 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` left join `test`.`eq_child` `c1` on(((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c5` on(((`test`.`c5`.`a` = `test`.`c1`.`c`) and (`test`.`c5`.`b` = `test`.`c1`.`c`))) left join `test`.`eq_child` `c6` on(((`test`.`c6`.`a` = `test`.`c1`.`c`) and (`test`.`c6`.`b` = `test`.`c1`.`c`))) left join `test`.`eq_child` `c7` on(((`test`.`c7`.`a` = `test`.`c1`.`c`) and (`test`.`c7`.`b` = `test`.`c1`.`c`))) left join `test`.`eq_child` `c8` on(((`test`.`c8`.`a` = `test`.`c1`.`c`) and (`test`.`c8`.`b` = `test`.`c1`.`c`))) left join `test`.`eq_child` `c2` on(((`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c9` on(((`test`.`c9`.`a` = `test`.`c2`.`c`) and (`test`.`c9`.`b` = `test`.`c2`.`c`))) left join `test`.`eq_child` `c10` on(((`test`.`c10`.`a` = `test`.`c2`.`c`) and (`test`.`c10`.`b` = `test`.`c2`.`c`))) left join `test`.`eq_child` `c11` on(((`test`.`c11`.`a` = `test`.`c2`.`c`) and (`test`.`c11`.`b` = `test`.`c2`.`c`))) left join `test`.`eq_child` `c12` on(((`test`.`c12`.`a` = `test`.`c2`.`c`) and (`test`.`c12`.`b` = `test`.`c2`.`c`))) left join `test`.`eq_child` `c3` on(((`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c13` on(((`test`.`c13`.`a` = `test`.`c3`.`c`) and (`test`.`c13`.`b` = `test`.`c3`.`c`))) left join `test`.`eq_child` `c14` on(((`test`.`c14`.`a` = `test`.`c3`.`c`) and (`test`.`c14`.`b` = `test`.`c3`.`c`))) left join `test`.`eq_child` `c15` on(((`test`.`c15`.`a` = `test`.`c3`.`c`) and (`test`.`c15`.`b` = `test`.`c3`.`c`))) left join `test`.`eq_child` `c16` on(((`test`.`c16`.`a` = `test`.`c3`.`c`) and (`test`.`c16`.`b` = `test`.`c3`.`c`))) left join `test`.`eq_child` `c4` on(((`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c17` on(((`test`.`c17`.`a` = `test`.`c4`.`c`) and (`test`.`c17`.`b` = `test`.`c4`.`c`))) left join `test`.`eq_child` `c18` on(((`test`.`c18`.`a` = `test`.`c4`.`c`) and (`test`.`c18`.`b` = `test`.`c4`.`c`))) left join `test`.`eq_child` `c19` on(((`test`.`c19`.`a` = `test`.`c4`.`c`) and (`test`.`c19`.`b` = `test`.`c4`.`c`))) left join `test`.`eq_child` `c20` on(((`test`.`c20`.`a` = `test`.`c4`.`c`) and (`test`.`c20`.`b` = `test`.`c4`.`c`))) where true
979 select straight_join count(*) from parent
980 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
981 left join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
982 left join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
983 left join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
984 left join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
985 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
986 left join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
987 left join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
988 left join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
989 left join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
990 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
991 left join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
992 left join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
993 left join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
994 left join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
995 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
996 left join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
997 left join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
998 left join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
999 left join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
1000 ;
1001 count(*)
1002 8192
1003 ===============================
1004 Run single instance of 'query4'
1005 ===============================
1006 explain select straight_join count(*) from parent
1007 join ref_child as c1 on c1.a = parent.b
1008 left join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
1009 join ref_child as c2 on c2.a = parent.b
1010 left join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
1011 join ref_child as c3 on c3.a = parent.b
1012 left join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
1013 join ref_child as c4 on c4.a = parent.b
1014 left join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
1015 join ref_child as c5 on c5.a = parent.b
1016 left join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
1017 join ref_child as c6 on c6.a = parent.b
1018 left join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
1019 join ref_child as c7 on c7.a = parent.b
1020 left join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
1021 join ref_child as c8 on c8.a = parent.b
1022 left join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
1023 join ref_child as c9 on c9.a = parent.b
1024 left join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
1025 join ref_child as c10 on c10.a = parent.b
1026 left join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
1027 join ref_child as c11 on c11.a = parent.b
1028 left join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
1029 join ref_child as c12 on c12.a = parent.b
1030 left join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
1031 join ref_child as c13 on c13.a = parent.b
1032 left join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
1033 join ref_child as c14 on c14.a = parent.b
1034 left join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
1035 join ref_child as c15 on c15.a = parent.b
1036 left join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
1037 join ref_child as c16 on c16.a = parent.b
1038 left join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
1039 where parent.a < 1000
1040 ;
1041 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1042 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 range PRIMARY PRIMARY 4 NULL ### ### Parent of 32 pushed join@1; Using pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null)); Using MRR
1043 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1044 1 SIMPLE c1eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c1.b ### ### Child of 'c1' in pushed join@1
1045 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1046 1 SIMPLE c2eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c2.b ### ### Child of 'c2' in pushed join@1
1047 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1048 1 SIMPLE c3eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c3.b ### ### Child of 'c3' in pushed join@1
1049 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1050 1 SIMPLE c4eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c4.b ### ### Child of 'c4' in pushed join@1
1051 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1052 1 SIMPLE c5eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c5.b ### ### Child of 'c5' in pushed join@1
1053 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1054 1 SIMPLE c6eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c6.b ### ### Child of 'c6' in pushed join@1
1055 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1056 1 SIMPLE c7eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c7.b ### ### Child of 'c7' in pushed join@1
1057 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1058 1 SIMPLE c8eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c8.b ### ### Child of 'c8' in pushed join@1
1059 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1060 1 SIMPLE c9eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c9.b ### ### Child of 'c9' in pushed join@1
1061 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1062 1 SIMPLE c10eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c10.b ### ### Child of 'c10' in pushed join@1
1063 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1064 1 SIMPLE c11eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c11.b ### ### Child of 'c11' in pushed join@1
1065 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1066 1 SIMPLE c12eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c12.b ### ### Child of 'c12' in pushed join@1
1067 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1068 1 SIMPLE c13eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c13.b ### ### Child of 'c13' in pushed join@1
1069 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1070 1 SIMPLE c14eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c14.b ### ### Child of 'c14' in pushed join@1
1071 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1072 1 SIMPLE c15eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c15.b ### ### Child of 'c15' in pushed join@1
1073 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1074 1 SIMPLE c16eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c16.b ### ### NULL
1075 Warnings:
1076 Note 1003 Can't push table 'c16eq' as child of 'parent'. Max number of pushable tables exceeded.
1077 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`ref_child` `c1` left join `test`.`eq_child` `c1eq` on(((`test`.`c1eq`.`b` = `test`.`c1`.`b`) and (`test`.`c1eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c2` left join `test`.`eq_child` `c2eq` on(((`test`.`c2eq`.`b` = `test`.`c2`.`b`) and (`test`.`c2eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c3` left join `test`.`eq_child` `c3eq` on(((`test`.`c3eq`.`b` = `test`.`c3`.`b`) and (`test`.`c3eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c4` left join `test`.`eq_child` `c4eq` on(((`test`.`c4eq`.`b` = `test`.`c4`.`b`) and (`test`.`c4eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c5` left join `test`.`eq_child` `c5eq` on(((`test`.`c5eq`.`b` = `test`.`c5`.`b`) and (`test`.`c5eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c6` left join `test`.`eq_child` `c6eq` on(((`test`.`c6eq`.`b` = `test`.`c6`.`b`) and (`test`.`c6eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c7` left join `test`.`eq_child` `c7eq` on(((`test`.`c7eq`.`b` = `test`.`c7`.`b`) and (`test`.`c7eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c8` left join `test`.`eq_child` `c8eq` on(((`test`.`c8eq`.`b` = `test`.`c8`.`b`) and (`test`.`c8eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c9` left join `test`.`eq_child` `c9eq` on(((`test`.`c9eq`.`b` = `test`.`c9`.`b`) and (`test`.`c9eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c10` left join `test`.`eq_child` `c10eq` on(((`test`.`c10eq`.`b` = `test`.`c10`.`b`) and (`test`.`c10eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c11` left join `test`.`eq_child` `c11eq` on(((`test`.`c11eq`.`b` = `test`.`c11`.`b`) and (`test`.`c11eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c12` left join `test`.`eq_child` `c12eq` on(((`test`.`c12eq`.`b` = `test`.`c12`.`b`) and (`test`.`c12eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c13` left join `test`.`eq_child` `c13eq` on(((`test`.`c13eq`.`b` = `test`.`c13`.`b`) and (`test`.`c13eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c14` left join `test`.`eq_child` `c14eq` on(((`test`.`c14eq`.`b` = `test`.`c14`.`b`) and (`test`.`c14eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c15` left join `test`.`eq_child` `c15eq` on(((`test`.`c15eq`.`b` = `test`.`c15`.`b`) and (`test`.`c15eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c16` left join `test`.`eq_child` `c16eq` on(((`test`.`c16eq`.`b` = `test`.`c16`.`b`) and (`test`.`c16eq`.`a` = `test`.`parent`.`b`))) where ((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`parent`.`a` < 1000))
1078 select straight_join count(*) from parent
1079 join ref_child as c1 on c1.a = parent.b
1080 left join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
1081 join ref_child as c2 on c2.a = parent.b
1082 left join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
1083 join ref_child as c3 on c3.a = parent.b
1084 left join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
1085 join ref_child as c4 on c4.a = parent.b
1086 left join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
1087 join ref_child as c5 on c5.a = parent.b
1088 left join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
1089 join ref_child as c6 on c6.a = parent.b
1090 left join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
1091 join ref_child as c7 on c7.a = parent.b
1092 left join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
1093 join ref_child as c8 on c8.a = parent.b
1094 left join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
1095 join ref_child as c9 on c9.a = parent.b
1096 left join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
1097 join ref_child as c10 on c10.a = parent.b
1098 left join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
1099 join ref_child as c11 on c11.a = parent.b
1100 left join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
1101 join ref_child as c12 on c12.a = parent.b
1102 left join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
1103 join ref_child as c13 on c13.a = parent.b
1104 left join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
1105 join ref_child as c14 on c14.a = parent.b
1106 left join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
1107 join ref_child as c15 on c15.a = parent.b
1108 left join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
1109 join ref_child as c16 on c16.a = parent.b
1110 left join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
1111 where parent.a < 1000
1112 ;
1113 count(*)
1114 999
1115 =================================
1116 Run multiple 'query1' in parallel
1117 =================================
1118 explain select straight_join count(*) from parent
1119 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1120 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1121 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1122 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1123 left join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
1124 left join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
1125 left join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
1126 left join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
1127 left join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
1128 left join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
1129 left join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
1130 left join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
1131 left join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
1132 left join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
1133 left join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
1134 left join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
1135 ;
1136 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1137 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ALL NULL NULL NULL NULL 8192 100.00 Parent of 17 pushed join@1
1138 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1139 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1140 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1141 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1142 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1143 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1144 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1145 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1146 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1147 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1148 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1149 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1150 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1151 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1152 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1153 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1154 Warnings:
1155 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` left join `test`.`eq_child` `c1` on(((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c2` on(((`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c3` on(((`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c4` on(((`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c5` on(((`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c6` on(((`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c7` on(((`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c8` on(((`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c9` on(((`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c10` on(((`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c11` on(((`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c12` on(((`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c13` on(((`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c14` on(((`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c15` on(((`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c16` on(((`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`b` = `test`.`parent`.`b`))) where true
1156 select straight_join count(*) from parent
1157 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1158 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1159 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1160 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1161 left join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
1162 left join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
1163 left join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
1164 left join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
1165 left join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
1166 left join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
1167 left join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
1168 left join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
1169 left join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
1170 left join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
1171 left join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
1172 left join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
1173 ;
1174 select straight_join count(*) from parent
1175 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1176 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1177 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1178 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1179 left join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
1180 left join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
1181 left join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
1182 left join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
1183 left join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
1184 left join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
1185 left join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
1186 left join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
1187 left join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
1188 left join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
1189 left join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
1190 left join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
1191 ;
1192 select straight_join count(*) from parent
1193 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1194 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1195 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1196 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1197 left join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
1198 left join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
1199 left join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
1200 left join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
1201 left join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
1202 left join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
1203 left join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
1204 left join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
1205 left join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
1206 left join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
1207 left join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
1208 left join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
1209 ;
1210 Await completion or failure
1211 count(*)
1212 8192
1213 count(*)
1214 8192
1215 count(*)
1216 8192
1217 =================================
1218 Run multiple 'query2' in parallel
1219 =================================
1220 explain select straight_join count(*) from parent
1221 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1222 left join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
1223 left join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
1224 left join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
1225 left join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
1226 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1227 left join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
1228 left join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
1229 left join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
1230 left join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
1231 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1232 left join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
1233 left join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
1234 left join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
1235 left join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
1236 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1237 left join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
1238 left join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
1239 left join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
1240 left join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
1241 ;
1242 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1243 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ALL NULL NULL NULL NULL 8192 100.00 Parent of 21 pushed join@1
1244 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1245 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
1246 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
1247 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
1248 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c1.c,test.c1.c 1 100.00 Child of 'c1' in pushed join@1
1249 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1250 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
1251 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
1252 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
1253 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c2.c,test.c2.c 1 100.00 Child of 'c2' in pushed join@1
1254 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1255 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
1256 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
1257 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
1258 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c3.c,test.c3.c 1 100.00 Child of 'c3' in pushed join@1
1259 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.parent.b 1 100.00 Child of 'parent' in pushed join@1
1260 1 SIMPLE c17 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
1261 1 SIMPLE c18 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
1262 1 SIMPLE c19 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
1263 1 SIMPLE c20 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.c4.c,test.c4.c 1 100.00 Child of 'c4' in pushed join@1
1264 Warnings:
1265 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` left join `test`.`eq_child` `c1` on(((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c1`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c5` on(((`test`.`c5`.`a` = `test`.`c1`.`c`) and (`test`.`c5`.`b` = `test`.`c1`.`c`))) left join `test`.`eq_child` `c6` on(((`test`.`c6`.`a` = `test`.`c1`.`c`) and (`test`.`c6`.`b` = `test`.`c1`.`c`))) left join `test`.`eq_child` `c7` on(((`test`.`c7`.`a` = `test`.`c1`.`c`) and (`test`.`c7`.`b` = `test`.`c1`.`c`))) left join `test`.`eq_child` `c8` on(((`test`.`c8`.`a` = `test`.`c1`.`c`) and (`test`.`c8`.`b` = `test`.`c1`.`c`))) left join `test`.`eq_child` `c2` on(((`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c9` on(((`test`.`c9`.`a` = `test`.`c2`.`c`) and (`test`.`c9`.`b` = `test`.`c2`.`c`))) left join `test`.`eq_child` `c10` on(((`test`.`c10`.`a` = `test`.`c2`.`c`) and (`test`.`c10`.`b` = `test`.`c2`.`c`))) left join `test`.`eq_child` `c11` on(((`test`.`c11`.`a` = `test`.`c2`.`c`) and (`test`.`c11`.`b` = `test`.`c2`.`c`))) left join `test`.`eq_child` `c12` on(((`test`.`c12`.`a` = `test`.`c2`.`c`) and (`test`.`c12`.`b` = `test`.`c2`.`c`))) left join `test`.`eq_child` `c3` on(((`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c13` on(((`test`.`c13`.`a` = `test`.`c3`.`c`) and (`test`.`c13`.`b` = `test`.`c3`.`c`))) left join `test`.`eq_child` `c14` on(((`test`.`c14`.`a` = `test`.`c3`.`c`) and (`test`.`c14`.`b` = `test`.`c3`.`c`))) left join `test`.`eq_child` `c15` on(((`test`.`c15`.`a` = `test`.`c3`.`c`) and (`test`.`c15`.`b` = `test`.`c3`.`c`))) left join `test`.`eq_child` `c16` on(((`test`.`c16`.`a` = `test`.`c3`.`c`) and (`test`.`c16`.`b` = `test`.`c3`.`c`))) left join `test`.`eq_child` `c4` on(((`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`b` = `test`.`parent`.`b`))) left join `test`.`eq_child` `c17` on(((`test`.`c17`.`a` = `test`.`c4`.`c`) and (`test`.`c17`.`b` = `test`.`c4`.`c`))) left join `test`.`eq_child` `c18` on(((`test`.`c18`.`a` = `test`.`c4`.`c`) and (`test`.`c18`.`b` = `test`.`c4`.`c`))) left join `test`.`eq_child` `c19` on(((`test`.`c19`.`a` = `test`.`c4`.`c`) and (`test`.`c19`.`b` = `test`.`c4`.`c`))) left join `test`.`eq_child` `c20` on(((`test`.`c20`.`a` = `test`.`c4`.`c`) and (`test`.`c20`.`b` = `test`.`c4`.`c`))) where true
1266 select straight_join count(*) from parent
1267 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1268 left join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
1269 left join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
1270 left join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
1271 left join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
1272 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1273 left join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
1274 left join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
1275 left join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
1276 left join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
1277 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1278 left join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
1279 left join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
1280 left join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
1281 left join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
1282 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1283 left join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
1284 left join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
1285 left join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
1286 left join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
1287 ;
1288 select straight_join count(*) from parent
1289 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1290 left join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
1291 left join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
1292 left join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
1293 left join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
1294 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1295 left join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
1296 left join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
1297 left join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
1298 left join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
1299 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1300 left join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
1301 left join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
1302 left join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
1303 left join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
1304 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1305 left join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
1306 left join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
1307 left join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
1308 left join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
1309 ;
1310 select straight_join count(*) from parent
1311 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1312 left join eq_child as c5 on c5.a = c1.c and c5.b = c1.c
1313 left join eq_child as c6 on c6.a = c1.c and c6.b = c1.c
1314 left join eq_child as c7 on c7.a = c1.c and c7.b = c1.c
1315 left join eq_child as c8 on c8.a = c1.c and c8.b = c1.c
1316 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1317 left join eq_child as c9 on c9.a = c2.c and c9.b = c2.c
1318 left join eq_child as c10 on c10.a = c2.c and c10.b = c2.c
1319 left join eq_child as c11 on c11.a = c2.c and c11.b = c2.c
1320 left join eq_child as c12 on c12.a = c2.c and c12.b = c2.c
1321 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1322 left join eq_child as c13 on c13.a = c3.c and c13.b = c3.c
1323 left join eq_child as c14 on c14.a = c3.c and c14.b = c3.c
1324 left join eq_child as c15 on c15.a = c3.c and c15.b = c3.c
1325 left join eq_child as c16 on c16.a = c3.c and c16.b = c3.c
1326 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1327 left join eq_child as c17 on c17.a = c4.c and c17.b = c4.c
1328 left join eq_child as c18 on c18.a = c4.c and c18.b = c4.c
1329 left join eq_child as c19 on c19.a = c4.c and c19.b = c4.c
1330 left join eq_child as c20 on c20.a = c4.c and c20.b = c4.c
1331 ;
1332 Await completion or failure
1333 count(*)
1334 8192
1335 count(*)
1336 8192
1337 count(*)
1338 8192
1339 =================================
1340 Run multiple 'query4' in parallel
1341 =================================
1342 explain select straight_join count(*) from parent
1343 join ref_child as c1 on c1.a = parent.b
1344 left join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
1345 join ref_child as c2 on c2.a = parent.b
1346 left join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
1347 join ref_child as c3 on c3.a = parent.b
1348 left join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
1349 join ref_child as c4 on c4.a = parent.b
1350 left join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
1351 join ref_child as c5 on c5.a = parent.b
1352 left join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
1353 join ref_child as c6 on c6.a = parent.b
1354 left join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
1355 join ref_child as c7 on c7.a = parent.b
1356 left join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
1357 join ref_child as c8 on c8.a = parent.b
1358 left join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
1359 join ref_child as c9 on c9.a = parent.b
1360 left join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
1361 join ref_child as c10 on c10.a = parent.b
1362 left join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
1363 join ref_child as c11 on c11.a = parent.b
1364 left join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
1365 join ref_child as c12 on c12.a = parent.b
1366 left join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
1367 join ref_child as c13 on c13.a = parent.b
1368 left join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
1369 join ref_child as c14 on c14.a = parent.b
1370 left join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
1371 join ref_child as c15 on c15.a = parent.b
1372 left join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
1373 join ref_child as c16 on c16.a = parent.b
1374 left join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
1375 where parent.a < 1000
1376 ;
1377 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1378 1 SIMPLE parent p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 range PRIMARY PRIMARY 4 NULL ### ### Parent of 32 pushed join@1; Using pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null)); Using MRR
1379 1 SIMPLE c1 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1380 1 SIMPLE c1eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c1.b ### ### Child of 'c1' in pushed join@1
1381 1 SIMPLE c2 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1382 1 SIMPLE c2eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c2.b ### ### Child of 'c2' in pushed join@1
1383 1 SIMPLE c3 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1384 1 SIMPLE c3eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c3.b ### ### Child of 'c3' in pushed join@1
1385 1 SIMPLE c4 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1386 1 SIMPLE c4eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c4.b ### ### Child of 'c4' in pushed join@1
1387 1 SIMPLE c5 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1388 1 SIMPLE c5eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c5.b ### ### Child of 'c5' in pushed join@1
1389 1 SIMPLE c6 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1390 1 SIMPLE c6eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c6.b ### ### Child of 'c6' in pushed join@1
1391 1 SIMPLE c7 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1392 1 SIMPLE c7eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c7.b ### ### Child of 'c7' in pushed join@1
1393 1 SIMPLE c8 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1394 1 SIMPLE c8eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c8.b ### ### Child of 'c8' in pushed join@1
1395 1 SIMPLE c9 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1396 1 SIMPLE c9eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c9.b ### ### Child of 'c9' in pushed join@1
1397 1 SIMPLE c10 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1398 1 SIMPLE c10eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c10.b ### ### Child of 'c10' in pushed join@1
1399 1 SIMPLE c11 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1400 1 SIMPLE c11eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c11.b ### ### Child of 'c11' in pushed join@1
1401 1 SIMPLE c12 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1402 1 SIMPLE c12eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c12.b ### ### Child of 'c12' in pushed join@1
1403 1 SIMPLE c13 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1404 1 SIMPLE c13eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c13.b ### ### Child of 'c13' in pushed join@1
1405 1 SIMPLE c14 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1406 1 SIMPLE c14eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c14.b ### ### Child of 'c14' in pushed join@1
1407 1 SIMPLE c15 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1408 1 SIMPLE c15eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c15.b ### ### Child of 'c15' in pushed join@1
1409 1 SIMPLE c16 p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 ref PRIMARY PRIMARY 4 test.parent.b ### ### Child of 'parent' in pushed join@1
1410 1 SIMPLE c16eq p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16,p17,p18,p19,p20,p21,p22,p23,p24,p25,p26,p27,p28,p29,p30,p31 eq_ref PRIMARY PRIMARY 8 test.parent.b,test.c16.b ### ### NULL
1411 Warnings:
1412 Note 1003 Can't push table 'c16eq' as child of 'parent'. Max number of pushable tables exceeded.
1413 Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`ref_child` `c1` left join `test`.`eq_child` `c1eq` on(((`test`.`c1eq`.`b` = `test`.`c1`.`b`) and (`test`.`c1eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c2` left join `test`.`eq_child` `c2eq` on(((`test`.`c2eq`.`b` = `test`.`c2`.`b`) and (`test`.`c2eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c3` left join `test`.`eq_child` `c3eq` on(((`test`.`c3eq`.`b` = `test`.`c3`.`b`) and (`test`.`c3eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c4` left join `test`.`eq_child` `c4eq` on(((`test`.`c4eq`.`b` = `test`.`c4`.`b`) and (`test`.`c4eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c5` left join `test`.`eq_child` `c5eq` on(((`test`.`c5eq`.`b` = `test`.`c5`.`b`) and (`test`.`c5eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c6` left join `test`.`eq_child` `c6eq` on(((`test`.`c6eq`.`b` = `test`.`c6`.`b`) and (`test`.`c6eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c7` left join `test`.`eq_child` `c7eq` on(((`test`.`c7eq`.`b` = `test`.`c7`.`b`) and (`test`.`c7eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c8` left join `test`.`eq_child` `c8eq` on(((`test`.`c8eq`.`b` = `test`.`c8`.`b`) and (`test`.`c8eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c9` left join `test`.`eq_child` `c9eq` on(((`test`.`c9eq`.`b` = `test`.`c9`.`b`) and (`test`.`c9eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c10` left join `test`.`eq_child` `c10eq` on(((`test`.`c10eq`.`b` = `test`.`c10`.`b`) and (`test`.`c10eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c11` left join `test`.`eq_child` `c11eq` on(((`test`.`c11eq`.`b` = `test`.`c11`.`b`) and (`test`.`c11eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c12` left join `test`.`eq_child` `c12eq` on(((`test`.`c12eq`.`b` = `test`.`c12`.`b`) and (`test`.`c12eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c13` left join `test`.`eq_child` `c13eq` on(((`test`.`c13eq`.`b` = `test`.`c13`.`b`) and (`test`.`c13eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c14` left join `test`.`eq_child` `c14eq` on(((`test`.`c14eq`.`b` = `test`.`c14`.`b`) and (`test`.`c14eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c15` left join `test`.`eq_child` `c15eq` on(((`test`.`c15eq`.`b` = `test`.`c15`.`b`) and (`test`.`c15eq`.`a` = `test`.`parent`.`b`))) join `test`.`ref_child` `c16` left join `test`.`eq_child` `c16eq` on(((`test`.`c16eq`.`b` = `test`.`c16`.`b`) and (`test`.`c16eq`.`a` = `test`.`parent`.`b`))) where ((`test`.`c1`.`a` = `test`.`parent`.`b`) and (`test`.`c2`.`a` = `test`.`parent`.`b`) and (`test`.`c3`.`a` = `test`.`parent`.`b`) and (`test`.`c4`.`a` = `test`.`parent`.`b`) and (`test`.`c5`.`a` = `test`.`parent`.`b`) and (`test`.`c6`.`a` = `test`.`parent`.`b`) and (`test`.`c7`.`a` = `test`.`parent`.`b`) and (`test`.`c8`.`a` = `test`.`parent`.`b`) and (`test`.`c9`.`a` = `test`.`parent`.`b`) and (`test`.`c10`.`a` = `test`.`parent`.`b`) and (`test`.`c11`.`a` = `test`.`parent`.`b`) and (`test`.`c12`.`a` = `test`.`parent`.`b`) and (`test`.`c13`.`a` = `test`.`parent`.`b`) and (`test`.`c14`.`a` = `test`.`parent`.`b`) and (`test`.`c15`.`a` = `test`.`parent`.`b`) and (`test`.`c16`.`a` = `test`.`parent`.`b`) and (`test`.`parent`.`a` < 1000))
1414 select straight_join count(*) from parent
1415 join ref_child as c1 on c1.a = parent.b
1416 left join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
1417 join ref_child as c2 on c2.a = parent.b
1418 left join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
1419 join ref_child as c3 on c3.a = parent.b
1420 left join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
1421 join ref_child as c4 on c4.a = parent.b
1422 left join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
1423 join ref_child as c5 on c5.a = parent.b
1424 left join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
1425 join ref_child as c6 on c6.a = parent.b
1426 left join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
1427 join ref_child as c7 on c7.a = parent.b
1428 left join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
1429 join ref_child as c8 on c8.a = parent.b
1430 left join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
1431 join ref_child as c9 on c9.a = parent.b
1432 left join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
1433 join ref_child as c10 on c10.a = parent.b
1434 left join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
1435 join ref_child as c11 on c11.a = parent.b
1436 left join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
1437 join ref_child as c12 on c12.a = parent.b
1438 left join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
1439 join ref_child as c13 on c13.a = parent.b
1440 left join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
1441 join ref_child as c14 on c14.a = parent.b
1442 left join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
1443 join ref_child as c15 on c15.a = parent.b
1444 left join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
1445 join ref_child as c16 on c16.a = parent.b
1446 left join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
1447 where parent.a < 1000
1448 ;
1449 select straight_join count(*) from parent
1450 join ref_child as c1 on c1.a = parent.b
1451 left join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
1452 join ref_child as c2 on c2.a = parent.b
1453 left join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
1454 join ref_child as c3 on c3.a = parent.b
1455 left join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
1456 join ref_child as c4 on c4.a = parent.b
1457 left join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
1458 join ref_child as c5 on c5.a = parent.b
1459 left join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
1460 join ref_child as c6 on c6.a = parent.b
1461 left join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
1462 join ref_child as c7 on c7.a = parent.b
1463 left join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
1464 join ref_child as c8 on c8.a = parent.b
1465 left join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
1466 join ref_child as c9 on c9.a = parent.b
1467 left join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
1468 join ref_child as c10 on c10.a = parent.b
1469 left join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
1470 join ref_child as c11 on c11.a = parent.b
1471 left join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
1472 join ref_child as c12 on c12.a = parent.b
1473 left join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
1474 join ref_child as c13 on c13.a = parent.b
1475 left join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
1476 join ref_child as c14 on c14.a = parent.b
1477 left join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
1478 join ref_child as c15 on c15.a = parent.b
1479 left join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
1480 join ref_child as c16 on c16.a = parent.b
1481 left join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
1482 where parent.a < 1000
1483 ;
1484 select straight_join count(*) from parent
1485 join ref_child as c1 on c1.a = parent.b
1486 left join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b
1487 join ref_child as c2 on c2.a = parent.b
1488 left join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b
1489 join ref_child as c3 on c3.a = parent.b
1490 left join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b
1491 join ref_child as c4 on c4.a = parent.b
1492 left join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b
1493 join ref_child as c5 on c5.a = parent.b
1494 left join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b
1495 join ref_child as c6 on c6.a = parent.b
1496 left join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b
1497 join ref_child as c7 on c7.a = parent.b
1498 left join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b
1499 join ref_child as c8 on c8.a = parent.b
1500 left join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b
1501 join ref_child as c9 on c9.a = parent.b
1502 left join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b
1503 join ref_child as c10 on c10.a = parent.b
1504 left join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b
1505 join ref_child as c11 on c11.a = parent.b
1506 left join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b
1507 join ref_child as c12 on c12.a = parent.b
1508 left join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b
1509 join ref_child as c13 on c13.a = parent.b
1510 left join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b
1511 join ref_child as c14 on c14.a = parent.b
1512 left join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b
1513 join ref_child as c15 on c15.a = parent.b
1514 left join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b
1515 join ref_child as c16 on c16.a = parent.b
1516 left join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b
1517 where parent.a < 1000
1518 ;
1519 Await completion or failure
1520 count(*)
1521 999
1522 count(*)
1523 999
1524 count(*)
1525 999
1526 ========================================================
1527 Bug#31343524: 'Job buffer full' reintroduced by WL#10234
1528 Even a non-bushy query could fail due to this.
1529 ========================================================
1530 update parent set b = 1;
1531 ==========================================
1532 Run multiple 'non_bushy_query' in parallel
1533 ==========================================
1534 select straight_join count(*) from parent
1535 left join eq_child as c on c.a = parent.b and c.b = parent.b
1536 ;
1537 select straight_join count(*) from parent
1538 left join eq_child as c on c.a = parent.b and c.b = parent.b
1539 ;
1540 select straight_join count(*) from parent
1541 left join eq_child as c on c.a = parent.b and c.b = parent.b
1542 ;
1543 Await completion or failure
1544 count(*)
1545 8192
1546 count(*)
1547 8192
1548 count(*)
1549 8192
1550 =========================================
1551 Run multiple 'query1' (bushy) in parallel
1552 =========================================
1553 select straight_join count(*) from parent
1554 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1555 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1556 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1557 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1558 left join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
1559 left join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
1560 left join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
1561 left join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
1562 left join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
1563 left join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
1564 left join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
1565 left join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
1566 left join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
1567 left join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
1568 left join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
1569 left join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
1570 ;
1571 select straight_join count(*) from parent
1572 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1573 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1574 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1575 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1576 left join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
1577 left join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
1578 left join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
1579 left join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
1580 left join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
1581 left join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
1582 left join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
1583 left join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
1584 left join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
1585 left join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
1586 left join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
1587 left join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
1588 ;
1589 select straight_join count(*) from parent
1590 left join eq_child as c1 on c1.a = parent.b and c1.b = parent.b
1591 left join eq_child as c2 on c2.a = parent.b and c2.b = parent.b
1592 left join eq_child as c3 on c3.a = parent.b and c3.b = parent.b
1593 left join eq_child as c4 on c4.a = parent.b and c4.b = parent.b
1594 left join eq_child as c5 on c5.a = parent.b and c5.b = parent.b
1595 left join eq_child as c6 on c6.a = parent.b and c6.b = parent.b
1596 left join eq_child as c7 on c7.a = parent.b and c7.b = parent.b
1597 left join eq_child as c8 on c8.a = parent.b and c8.b = parent.b
1598 left join eq_child as c9 on c9.a = parent.b and c9.b = parent.b
1599 left join eq_child as c10 on c10.a = parent.b and c10.b = parent.b
1600 left join eq_child as c11 on c11.a = parent.b and c11.b = parent.b
1601 left join eq_child as c12 on c12.a = parent.b and c12.b = parent.b
1602 left join eq_child as c13 on c13.a = parent.b and c13.b = parent.b
1603 left join eq_child as c14 on c14.a = parent.b and c14.b = parent.b
1604 left join eq_child as c15 on c15.a = parent.b and c15.b = parent.b
1605 left join eq_child as c16 on c16.a = parent.b and c16.b = parent.b
1606 ;
1607 Await completion or failure
1608 count(*)
1609 8192
1610 count(*)
1611 8192
1612 count(*)
1613 8192
1614 drop table parent, eq_child, ref_child;
1615 Sending dump signal with data:
1616 0x000003e9 0x00000000
1617 Sending dump signal with data:
1618 0x000003e9 0x00000000
1619