Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 3.140.247.39
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
ndb /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.result
455
B
-rw-r--r--
loaddata_autocom_ndb.result
740
B
-rw-r--r--
ndb_add_partition.result
13.36
KB
-rw-r--r--
ndb_addnode_restart.result
384
B
-rw-r--r--
ndb_addnode_restart2.result
454
B
-rw-r--r--
ndb_alter_table.result
19.49
KB
-rw-r--r--
ndb_alter_table2.result
685
B
-rw-r--r--
ndb_alter_table3.result
1.48
KB
-rw-r--r--
ndb_alter_table_backup.result
1.76
KB
-rw-r--r--
ndb_alter_table_dml.result
1.83
KB
-rw-r--r--
ndb_alter_table_error.result
664
B
-rw-r--r--
ndb_alter_table_online.result
29.02
KB
-rw-r--r--
ndb_alter_table_online2.result
3.21
KB
-rw-r--r--
ndb_alter_table_online_multi.r...
2
KB
-rw-r--r--
ndb_auto_increment.result
11.49
KB
-rw-r--r--
ndb_autoinc.result
2.69
KB
-rw-r--r--
ndb_backup_rate.result
912
B
-rw-r--r--
ndb_basic.result
32.68
KB
-rw-r--r--
ndb_bitfield.result
8.39
KB
-rw-r--r--
ndb_blob.result
26.47
KB
-rw-r--r--
ndb_blob_big.result
1.24
KB
-rw-r--r--
ndb_blob_partition.result
9.03
KB
-rw-r--r--
ndb_bug13563280.result
224
B
-rw-r--r--
ndb_bug14166590.result
416
B
-rw-r--r--
ndb_bug17624736.result
1.71
KB
-rw-r--r--
ndb_bug17719439.result
439
B
-rw-r--r--
ndb_bug19390895.result
1.67
KB
-rw-r--r--
ndb_bug26793.result
286
B
-rw-r--r--
ndb_bug31477.result
1.85
KB
-rw-r--r--
ndb_bulk_delete.result
1.87
KB
-rw-r--r--
ndb_bushy_joins.result
88.95
KB
-rw-r--r--
ndb_cache.result
9.35
KB
-rw-r--r--
ndb_cache2.result
13.9
KB
-rw-r--r--
ndb_cache_multi.result
2.44
KB
-rw-r--r--
ndb_cache_multi2.result
3.04
KB
-rw-r--r--
ndb_cache_trans.result
6.65
KB
-rw-r--r--
ndb_charset.result
5.77
KB
-rw-r--r--
ndb_checksum.result
38
B
-rw-r--r--
ndb_column_properties.result
16.01
KB
-rw-r--r--
ndb_condition_pushdown.result
131.71
KB
-rw-r--r--
ndb_config.result
3.36
KB
-rw-r--r--
ndb_config2.result
475
B
-rw-r--r--
ndb_create_table.result
1.02
KB
-rw-r--r--
ndb_cursor.result
792
B
-rw-r--r--
ndb_database.result
1.25
KB
-rw-r--r--
ndb_dbug_lock.result
1.64
KB
-rw-r--r--
ndb_dbug_tc_select.result
6.71
KB
-rw-r--r--
ndb_dd_alter.result
28.43
KB
-rw-r--r--
ndb_dd_basic.result
21.17
KB
-rw-r--r--
ndb_dd_bug12581213.result
334
B
-rw-r--r--
ndb_dd_ddl.result
5.94
KB
-rw-r--r--
ndb_dd_disk2memory.result
15.44
KB
-rw-r--r--
ndb_dd_dump.result
15.97
KB
-rw-r--r--
ndb_dd_initial_lg.result
941
B
-rw-r--r--
ndb_dd_restore_check_tablespac...
8.3
KB
-rw-r--r--
ndb_dd_restore_compat.result
3.73
KB
-rw-r--r--
ndb_dd_sql_features.result
22.62
KB
-rw-r--r--
ndb_ddl_open_trans.result
1.44
KB
-rw-r--r--
ndb_disconnect_ddl.result
291
B
-rw-r--r--
ndb_discover_db.result
1.92
KB
-rw-r--r--
ndb_dist_priv.result
6.36
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.res...
248
B
-rw-r--r--
ndb_err4012.result
2.22
KB
-rw-r--r--
ndb_error_reporter.result
5.61
KB
-rw-r--r--
ndb_fired_trigger_shortage.res...
694
B
-rw-r--r--
ndb_fk_addnode.result
1.39
KB
-rw-r--r--
ndb_fk_alter.result
8.34
KB
-rw-r--r--
ndb_fk_bugs.result
27.58
KB
-rw-r--r--
ndb_fk_build.result
2.31
KB
-rw-r--r--
ndb_fk_cascade_delete.result
4.82
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.re...
2.56
KB
-rw-r--r--
ndb_fk_cascade_update.result
1.66
KB
-rw-r--r--
ndb_fk_create_drop.result
4.8
KB
-rw-r--r--
ndb_fk_db.result
7.18
KB
-rw-r--r--
ndb_fk_deferred_cascade.result
2.82
KB
-rw-r--r--
ndb_fk_disable.result
11.64
KB
-rw-r--r--
ndb_fk_is.result
8.49
KB
-rw-r--r--
ndb_fk_locase.result
2.44
KB
-rw-r--r--
ndb_fk_locking.result
1.47
KB
-rw-r--r--
ndb_fk_multi_column.result
2.04
KB
-rw-r--r--
ndb_fk_mysqldump.result
2.93
KB
-rw-r--r--
ndb_fk_mysqldump2.result
72
B
-rw-r--r--
ndb_fk_no_fk.result
30.14
KB
-rw-r--r--
ndb_fk_no_fk_legacy.result
2.77
KB
-rw-r--r--
ndb_fk_noaction.result
5.68
KB
-rw-r--r--
ndb_fk_resources.result
2.58
KB
-rw-r--r--
ndb_fk_restore.result
14.08
KB
-rw-r--r--
ndb_fk_restrict.result
6.82
KB
-rw-r--r--
ndb_fk_self_ref.result
3.74
KB
-rw-r--r--
ndb_fk_setdefault.result
1.03
KB
-rw-r--r--
ndb_fk_setnull.result
3.23
KB
-rw-r--r--
ndb_global_schema_lock.result
3.6
KB
-rw-r--r--
ndb_global_schema_lock_error.r...
1.88
KB
-rw-r--r--
ndb_grant.result
17.65
KB
-rw-r--r--
ndb_hashmap.result
624
B
-rw-r--r--
ndb_hidden_pk.result
10.55
KB
-rw-r--r--
ndb_index.result
17.84
KB
-rw-r--r--
ndb_index_ordered.result
16.73
KB
-rw-r--r--
ndb_index_stat.result
17.74
KB
-rw-r--r--
ndb_index_stat_partitions.resu...
3.82
KB
-rw-r--r--
ndb_index_stat_restart.result
2.2
KB
-rw-r--r--
ndb_index_unique.result
20.29
KB
-rw-r--r--
ndb_insert.result
36.52
KB
-rw-r--r--
ndb_join_pushdown_bka.result
949.68
KB
-rw-r--r--
ndb_join_pushdown_default.resu...
865.61
KB
-rw-r--r--
ndb_join_pushdown_nobnl.result
864.87
KB
-rw-r--r--
ndb_join_pushdown_none.result
865.08
KB
-rw-r--r--
ndb_limit.result
1.99
KB
-rw-r--r--
ndb_load.result
2.66
KB
-rw-r--r--
ndb_loaddatalocal.result
1.57
KB
-rw-r--r--
ndb_lock.result
4.17
KB
-rw-r--r--
ndb_lock_table.result
205
B
-rw-r--r--
ndb_many_fragments.result
26.72
KB
-rw-r--r--
ndb_mgm.result
5.7
KB
-rw-r--r--
ndb_mgmd.result
198
B
-rw-r--r--
ndb_minmax.result
1.47
KB
-rw-r--r--
ndb_multi.result
8.83
KB
-rw-r--r--
ndb_multi_row.result
1.33
KB
-rw-r--r--
ndb_multi_update_delete.result
1.83
KB
-rw-r--r--
ndb_native_default_support.res...
50.29
KB
-rw-r--r--
ndb_one_fragment.result
4.05
KB
-rw-r--r--
ndb_optimize_table.result
2
KB
-rw-r--r--
ndb_optimized_node_selection.r...
1017
B
-rw-r--r--
ndb_partition_error.result
1.44
KB
-rw-r--r--
ndb_partition_error2.result
150
B
-rw-r--r--
ndb_partition_hash.result
890
B
-rw-r--r--
ndb_partition_key.result
8.82
KB
-rw-r--r--
ndb_partition_list.result
2.31
KB
-rw-r--r--
ndb_partition_range.result
7.91
KB
-rw-r--r--
ndb_print_file.result
709
B
-rw-r--r--
ndb_rbwr.result
0
B
-rw-r--r--
ndb_read_multi_range.result
15
KB
-rw-r--r--
ndb_reconnect.result
1.7
KB
-rw-r--r--
ndb_rename.result
910
B
-rw-r--r--
ndb_replace.result
3.64
KB
-rw-r--r--
ndb_restore_bug17916243.result
537
B
-rw-r--r--
ndb_restore_compat_downward.re...
132.43
KB
-rw-r--r--
ndb_restore_compat_endianness....
10.97
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
15.46
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
20.72
KB
-rw-r--r--
ndb_restore_conv_more.result
56.57
KB
-rw-r--r--
ndb_restore_conv_padding.resul...
6.14
KB
-rw-r--r--
ndb_restore_conv_promotion.res...
23.26
KB
-rw-r--r--
ndb_restore_discover.result
540
B
-rw-r--r--
ndb_restore_misc.result
25.16
KB
-rw-r--r--
ndb_restore_print.result
9.8
KB
-rw-r--r--
ndb_restore_schema_blobs.resul...
6.44
KB
-rw-r--r--
ndb_restore_schema_partitions....
13.25
KB
-rw-r--r--
ndb_restore_schema_rewrites.re...
12.22
KB
-rw-r--r--
ndb_restore_schema_subsets.res...
95.9
KB
-rw-r--r--
ndb_restore_schema_tolerance.r...
4.53
KB
-rw-r--r--
ndb_restore_undolog.result
18.76
KB
-rw-r--r--
ndb_row_count.result
5.19
KB
-rw-r--r--
ndb_row_format.result
1.74
KB
-rw-r--r--
ndb_select_count.result
334
B
-rw-r--r--
ndb_share.result
11.29
KB
-rw-r--r--
ndb_short_sigs.result
2.54
KB
-rw-r--r--
ndb_single_user.result
4.01
KB
-rw-r--r--
ndb_sp.result
1.17
KB
-rw-r--r--
ndb_spj_dict.result
11.63
KB
-rw-r--r--
ndb_sql_allow_batching.result
918
B
-rw-r--r--
ndb_startup.result
358
B
-rw-r--r--
ndb_statistics0.result
16.23
KB
-rw-r--r--
ndb_statistics1.result
15.99
KB
-rw-r--r--
ndb_subquery.result
9.29
KB
-rw-r--r--
ndb_suma_handover.result
427
B
-rw-r--r--
ndb_temporary.result
949
B
-rw-r--r--
ndb_tmp_table_and_DDL.result
3.11
KB
-rw-r--r--
ndb_transaction.result
4.62
KB
-rw-r--r--
ndb_trigger.result
9.38
KB
-rw-r--r--
ndb_truncate.result
425
B
-rw-r--r--
ndb_types.result
4.91
KB
-rw-r--r--
ndb_update.result
2.97
KB
-rw-r--r--
ndb_update_no_read.result
11.23
KB
-rw-r--r--
ndb_view.result
597
B
-rw-r--r--
ndb_wait_until_ready.result
533
B
-rw-r--r--
ndb_wl946_main.result
19.39
KB
-rw-r--r--
ndb_wl946_post.result
3.7
KB
-rw-r--r--
ndb_wl946_pre.result
6.62
KB
-rw-r--r--
ndbapi-examples.result
3.34
KB
-rw-r--r--
ndbinfo.result
44.04
KB
-rw-r--r--
ndbinfo_cache.result
775
B
-rw-r--r--
ndbinfo_dump.result
95
B
-rw-r--r--
ndbinfo_upgrade.result
382
B
-rw-r--r--
ps_7ndb.result
103.05
KB
-rw-r--r--
strict_autoinc_5ndb.result
894
B
-rw-r--r--
wl10837.result
524
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_bushy_joins.result
create table parent(a int primary key, b int, c int, d int) engine=ndb; create table eq_child(a int, b int, c int, d int, primary key(a,b)) engine=ndb; create table ref_child(a int, b int, c int, d int, primary key(a,b)) engine=ndb; alter table parent partition by key(a) partitions 32; alter table eq_child partition by key(a) partitions 32; alter table ref_child partition by key(a) partitions 32; insert into parent values (1,1,1,1); insert into parent select a+1, b+1, c+1, d+1 from parent; insert into parent select a+1*2, b+1*2, c+1*2, d+1*2 from parent; insert into parent select a+1*2*2, b+1*2*2, c+1*2*2, d+1*2*2 from parent; 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; 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; 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; 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; 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; 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; 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; 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; 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; 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; select count(*) from parent; count(*) 8192 insert into eq_child select * from parent; insert into ref_child select * from parent; update ref_child set a = a-(a%16) where a > 4000; analyze table parent, eq_child, ref_child; Table Op Msg_type Msg_text test.parent analyze status OK test.eq_child analyze status OK test.ref_child analyze status OK set ndb_join_pushdown = on; call mtr.add_suppression("starting connect thread"); =============================== Run single instance of 'query1' =============================== explain select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c5 on c5.a = parent.b and c5.b = parent.b join eq_child as c6 on c6.a = parent.b and c6.b = parent.b join eq_child as c7 on c7.a = parent.b and c7.b = parent.b join eq_child as c8 on c8.a = parent.b and c8.b = parent.b join eq_child as c9 on c9.a = parent.b and c9.b = parent.b join eq_child as c10 on c10.a = parent.b and c10.b = parent.b join eq_child as c11 on c11.a = parent.b and c11.b = parent.b join eq_child as c12 on c12.a = parent.b and c12.b = parent.b join eq_child as c13 on c13.a = parent.b and c13.b = parent.b join eq_child as c14 on c14.a = parent.b and c14.b = parent.b join eq_child as c15 on c15.a = parent.b and c15.b = parent.b join eq_child as c16 on c16.a = parent.b and c16.b = parent.b ; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 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 where with pushed condition ((`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null)) 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 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 'c1' in pushed join@1 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 'c2' in pushed join@1 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 'c3' in pushed join@1 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 'c4' in pushed join@1 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 'c5' in pushed join@1 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 'c6' in pushed join@1 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 'c7' in pushed join@1 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 'c8' in pushed join@1 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 'c9' in pushed join@1 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 'c10' in pushed join@1 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 'c11' in pushed join@1 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 'c12' in pushed join@1 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 'c13' in pushed join@1 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 'c14' in pushed join@1 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 'c15' in pushed join@1 Warnings: 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`)) select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c5 on c5.a = parent.b and c5.b = parent.b join eq_child as c6 on c6.a = parent.b and c6.b = parent.b join eq_child as c7 on c7.a = parent.b and c7.b = parent.b join eq_child as c8 on c8.a = parent.b and c8.b = parent.b join eq_child as c9 on c9.a = parent.b and c9.b = parent.b join eq_child as c10 on c10.a = parent.b and c10.b = parent.b join eq_child as c11 on c11.a = parent.b and c11.b = parent.b join eq_child as c12 on c12.a = parent.b and c12.b = parent.b join eq_child as c13 on c13.a = parent.b and c13.b = parent.b join eq_child as c14 on c14.a = parent.b and c14.b = parent.b join eq_child as c15 on c15.a = parent.b and c15.b = parent.b join eq_child as c16 on c16.a = parent.b and c16.b = parent.b ; count(*) 8192 =============================== Run single instance of 'query2' =============================== explain select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c5 on c5.a = c1.c and c5.b = c1.c join eq_child as c6 on c6.a = c1.c and c6.b = c1.c join eq_child as c7 on c7.a = c1.c and c7.b = c1.c join eq_child as c8 on c8.a = c1.c and c8.b = c1.c join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c9 on c9.a = c2.c and c9.b = c2.c join eq_child as c10 on c10.a = c2.c and c10.b = c2.c join eq_child as c11 on c11.a = c2.c and c11.b = c2.c join eq_child as c12 on c12.a = c2.c and c12.b = c2.c join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c13 on c13.a = c3.c and c13.b = c3.c join eq_child as c14 on c14.a = c3.c and c14.b = c3.c join eq_child as c15 on c15.a = c3.c and c15.b = c3.c join eq_child as c16 on c16.a = c3.c and c16.b = c3.c join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c17 on c17.a = c4.c and c17.b = c4.c join eq_child as c18 on c18.a = c4.c and c18.b = c4.c join eq_child as c19 on c19.a = c4.c and c19.b = c4.c join eq_child as c20 on c20.a = c4.c and c20.b = c4.c ; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 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 where with pushed condition ((`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null)) 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 where with pushed condition ((`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null)) 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 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 'c5' in pushed join@1 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 'c6' in pushed join@1 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 'c7' in pushed join@1 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 'c1' in pushed join@1; Using where with pushed condition ((`test`.`c2`.`c` is not null) and (`test`.`c2`.`c` is not null) and (`test`.`c2`.`c` is not null)) 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 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 'c9' in pushed join@1 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 'c10' in pushed join@1 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 'c11' in pushed join@1 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 'c2' in pushed join@1; Using where with pushed condition ((`test`.`c3`.`c` is not null) and (`test`.`c3`.`c` is not null) and (`test`.`c3`.`c` is not null)) 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 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 'c13' in pushed join@1 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 'c14' in pushed join@1 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 'c15' in pushed join@1 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 'c3' in pushed join@1; Using where with pushed condition ((`test`.`c4`.`c` is not null) and (`test`.`c4`.`c` is not null) and (`test`.`c4`.`c` is not null) and (`test`.`c4`.`c` is not null)) 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 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 'c17' in pushed join@1 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 'c18' in pushed join@1 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 'c19' in pushed join@1 Warnings: 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`)) select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c5 on c5.a = c1.c and c5.b = c1.c join eq_child as c6 on c6.a = c1.c and c6.b = c1.c join eq_child as c7 on c7.a = c1.c and c7.b = c1.c join eq_child as c8 on c8.a = c1.c and c8.b = c1.c join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c9 on c9.a = c2.c and c9.b = c2.c join eq_child as c10 on c10.a = c2.c and c10.b = c2.c join eq_child as c11 on c11.a = c2.c and c11.b = c2.c join eq_child as c12 on c12.a = c2.c and c12.b = c2.c join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c13 on c13.a = c3.c and c13.b = c3.c join eq_child as c14 on c14.a = c3.c and c14.b = c3.c join eq_child as c15 on c15.a = c3.c and c15.b = c3.c join eq_child as c16 on c16.a = c3.c and c16.b = c3.c join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c17 on c17.a = c4.c and c17.b = c4.c join eq_child as c18 on c18.a = c4.c and c18.b = c4.c join eq_child as c19 on c19.a = c4.c and c19.b = c4.c join eq_child as c20 on c20.a = c4.c and c20.b = c4.c ; count(*) 8192 =============================== Run single instance of 'query3' =============================== explain select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join ref_child as c2 on c2.a = parent.b join ref_child as c3 on c3.a = parent.b join ref_child as c4 on c4.a = parent.b join ref_child as c5 on c5.a = parent.b join ref_child as c6 on c6.a = parent.b join ref_child as c7 on c7.a = parent.b join ref_child as c8 on c8.a = parent.b join ref_child as c9 on c9.a = parent.b join ref_child as c10 on c10.a = parent.b join ref_child as c11 on c11.a = parent.b join ref_child as c12 on c12.a = parent.b join ref_child as c13 on c13.a = parent.b join ref_child as c14 on c14.a = parent.b join ref_child as c15 on c15.a = parent.b join ref_child as c16 on c16.a = parent.b where parent.a < 1000 ; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 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 where with pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null)); Using MRR 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Warnings: 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)) select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join ref_child as c2 on c2.a = parent.b join ref_child as c3 on c3.a = parent.b join ref_child as c4 on c4.a = parent.b join ref_child as c5 on c5.a = parent.b join ref_child as c6 on c6.a = parent.b join ref_child as c7 on c7.a = parent.b join ref_child as c8 on c8.a = parent.b join ref_child as c9 on c9.a = parent.b join ref_child as c10 on c10.a = parent.b join ref_child as c11 on c11.a = parent.b join ref_child as c12 on c12.a = parent.b join ref_child as c13 on c13.a = parent.b join ref_child as c14 on c14.a = parent.b join ref_child as c15 on c15.a = parent.b join ref_child as c16 on c16.a = parent.b where parent.a < 1000 ; count(*) 999 =============================== Run single instance of 'query4' =============================== explain select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b join ref_child as c2 on c2.a = parent.b join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b join ref_child as c3 on c3.a = parent.b join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b join ref_child as c4 on c4.a = parent.b join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b join ref_child as c5 on c5.a = parent.b join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b join ref_child as c6 on c6.a = parent.b join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b join ref_child as c7 on c7.a = parent.b join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b join ref_child as c8 on c8.a = parent.b join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b join ref_child as c9 on c9.a = parent.b join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b join ref_child as c10 on c10.a = parent.b join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b join ref_child as c11 on c11.a = parent.b join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b join ref_child as c12 on c12.a = parent.b join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b join ref_child as c13 on c13.a = parent.b join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b join ref_child as c14 on c14.a = parent.b join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b join ref_child as c15 on c15.a = parent.b join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b join ref_child as c16 on c16.a = parent.b join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b where parent.a < 1000 ; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 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 where with pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null)); Using MRR 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Warnings: Note 1003 Cannot push table 'c16eq' as child of 'parent'. Max number of pushable tables exceeded. 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)) select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b join ref_child as c2 on c2.a = parent.b join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b join ref_child as c3 on c3.a = parent.b join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b join ref_child as c4 on c4.a = parent.b join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b join ref_child as c5 on c5.a = parent.b join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b join ref_child as c6 on c6.a = parent.b join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b join ref_child as c7 on c7.a = parent.b join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b join ref_child as c8 on c8.a = parent.b join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b join ref_child as c9 on c9.a = parent.b join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b join ref_child as c10 on c10.a = parent.b join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b join ref_child as c11 on c11.a = parent.b join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b join ref_child as c12 on c12.a = parent.b join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b join ref_child as c13 on c13.a = parent.b join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b join ref_child as c14 on c14.a = parent.b join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b join ref_child as c15 on c15.a = parent.b join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b join ref_child as c16 on c16.a = parent.b join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b where parent.a < 1000 ; count(*) 999 ================================= Run multiple 'query1' in parallel ================================= explain select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c5 on c5.a = parent.b and c5.b = parent.b join eq_child as c6 on c6.a = parent.b and c6.b = parent.b join eq_child as c7 on c7.a = parent.b and c7.b = parent.b join eq_child as c8 on c8.a = parent.b and c8.b = parent.b join eq_child as c9 on c9.a = parent.b and c9.b = parent.b join eq_child as c10 on c10.a = parent.b and c10.b = parent.b join eq_child as c11 on c11.a = parent.b and c11.b = parent.b join eq_child as c12 on c12.a = parent.b and c12.b = parent.b join eq_child as c13 on c13.a = parent.b and c13.b = parent.b join eq_child as c14 on c14.a = parent.b and c14.b = parent.b join eq_child as c15 on c15.a = parent.b and c15.b = parent.b join eq_child as c16 on c16.a = parent.b and c16.b = parent.b ; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 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 where with pushed condition ((`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null)) 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 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 'c1' in pushed join@1 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 'c2' in pushed join@1 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 'c3' in pushed join@1 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 'c4' in pushed join@1 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 'c5' in pushed join@1 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 'c6' in pushed join@1 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 'c7' in pushed join@1 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 'c8' in pushed join@1 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 'c9' in pushed join@1 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 'c10' in pushed join@1 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 'c11' in pushed join@1 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 'c12' in pushed join@1 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 'c13' in pushed join@1 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 'c14' in pushed join@1 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 'c15' in pushed join@1 Warnings: 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`)) select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c5 on c5.a = parent.b and c5.b = parent.b join eq_child as c6 on c6.a = parent.b and c6.b = parent.b join eq_child as c7 on c7.a = parent.b and c7.b = parent.b join eq_child as c8 on c8.a = parent.b and c8.b = parent.b join eq_child as c9 on c9.a = parent.b and c9.b = parent.b join eq_child as c10 on c10.a = parent.b and c10.b = parent.b join eq_child as c11 on c11.a = parent.b and c11.b = parent.b join eq_child as c12 on c12.a = parent.b and c12.b = parent.b join eq_child as c13 on c13.a = parent.b and c13.b = parent.b join eq_child as c14 on c14.a = parent.b and c14.b = parent.b join eq_child as c15 on c15.a = parent.b and c15.b = parent.b join eq_child as c16 on c16.a = parent.b and c16.b = parent.b ; select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c5 on c5.a = parent.b and c5.b = parent.b join eq_child as c6 on c6.a = parent.b and c6.b = parent.b join eq_child as c7 on c7.a = parent.b and c7.b = parent.b join eq_child as c8 on c8.a = parent.b and c8.b = parent.b join eq_child as c9 on c9.a = parent.b and c9.b = parent.b join eq_child as c10 on c10.a = parent.b and c10.b = parent.b join eq_child as c11 on c11.a = parent.b and c11.b = parent.b join eq_child as c12 on c12.a = parent.b and c12.b = parent.b join eq_child as c13 on c13.a = parent.b and c13.b = parent.b join eq_child as c14 on c14.a = parent.b and c14.b = parent.b join eq_child as c15 on c15.a = parent.b and c15.b = parent.b join eq_child as c16 on c16.a = parent.b and c16.b = parent.b ; select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c5 on c5.a = parent.b and c5.b = parent.b join eq_child as c6 on c6.a = parent.b and c6.b = parent.b join eq_child as c7 on c7.a = parent.b and c7.b = parent.b join eq_child as c8 on c8.a = parent.b and c8.b = parent.b join eq_child as c9 on c9.a = parent.b and c9.b = parent.b join eq_child as c10 on c10.a = parent.b and c10.b = parent.b join eq_child as c11 on c11.a = parent.b and c11.b = parent.b join eq_child as c12 on c12.a = parent.b and c12.b = parent.b join eq_child as c13 on c13.a = parent.b and c13.b = parent.b join eq_child as c14 on c14.a = parent.b and c14.b = parent.b join eq_child as c15 on c15.a = parent.b and c15.b = parent.b join eq_child as c16 on c16.a = parent.b and c16.b = parent.b ; Await completion or failure count(*) 8192 count(*) 8192 count(*) 8192 ================================= Run multiple 'query2' in parallel ================================= explain select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c5 on c5.a = c1.c and c5.b = c1.c join eq_child as c6 on c6.a = c1.c and c6.b = c1.c join eq_child as c7 on c7.a = c1.c and c7.b = c1.c join eq_child as c8 on c8.a = c1.c and c8.b = c1.c join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c9 on c9.a = c2.c and c9.b = c2.c join eq_child as c10 on c10.a = c2.c and c10.b = c2.c join eq_child as c11 on c11.a = c2.c and c11.b = c2.c join eq_child as c12 on c12.a = c2.c and c12.b = c2.c join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c13 on c13.a = c3.c and c13.b = c3.c join eq_child as c14 on c14.a = c3.c and c14.b = c3.c join eq_child as c15 on c15.a = c3.c and c15.b = c3.c join eq_child as c16 on c16.a = c3.c and c16.b = c3.c join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c17 on c17.a = c4.c and c17.b = c4.c join eq_child as c18 on c18.a = c4.c and c18.b = c4.c join eq_child as c19 on c19.a = c4.c and c19.b = c4.c join eq_child as c20 on c20.a = c4.c and c20.b = c4.c ; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 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 where with pushed condition ((`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null)) 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 where with pushed condition ((`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null) and (`test`.`c1`.`c` is not null)) 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 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 'c5' in pushed join@1 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 'c6' in pushed join@1 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 'c7' in pushed join@1 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 'c1' in pushed join@1; Using where with pushed condition ((`test`.`c2`.`c` is not null) and (`test`.`c2`.`c` is not null) and (`test`.`c2`.`c` is not null)) 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 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 'c9' in pushed join@1 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 'c10' in pushed join@1 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 'c11' in pushed join@1 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 'c2' in pushed join@1; Using where with pushed condition ((`test`.`c3`.`c` is not null) and (`test`.`c3`.`c` is not null) and (`test`.`c3`.`c` is not null)) 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 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 'c13' in pushed join@1 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 'c14' in pushed join@1 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 'c15' in pushed join@1 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 'c3' in pushed join@1; Using where with pushed condition ((`test`.`c4`.`c` is not null) and (`test`.`c4`.`c` is not null) and (`test`.`c4`.`c` is not null) and (`test`.`c4`.`c` is not null)) 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 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 'c17' in pushed join@1 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 'c18' in pushed join@1 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 'c19' in pushed join@1 Warnings: 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`)) select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c5 on c5.a = c1.c and c5.b = c1.c join eq_child as c6 on c6.a = c1.c and c6.b = c1.c join eq_child as c7 on c7.a = c1.c and c7.b = c1.c join eq_child as c8 on c8.a = c1.c and c8.b = c1.c join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c9 on c9.a = c2.c and c9.b = c2.c join eq_child as c10 on c10.a = c2.c and c10.b = c2.c join eq_child as c11 on c11.a = c2.c and c11.b = c2.c join eq_child as c12 on c12.a = c2.c and c12.b = c2.c join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c13 on c13.a = c3.c and c13.b = c3.c join eq_child as c14 on c14.a = c3.c and c14.b = c3.c join eq_child as c15 on c15.a = c3.c and c15.b = c3.c join eq_child as c16 on c16.a = c3.c and c16.b = c3.c join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c17 on c17.a = c4.c and c17.b = c4.c join eq_child as c18 on c18.a = c4.c and c18.b = c4.c join eq_child as c19 on c19.a = c4.c and c19.b = c4.c join eq_child as c20 on c20.a = c4.c and c20.b = c4.c ; select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c5 on c5.a = c1.c and c5.b = c1.c join eq_child as c6 on c6.a = c1.c and c6.b = c1.c join eq_child as c7 on c7.a = c1.c and c7.b = c1.c join eq_child as c8 on c8.a = c1.c and c8.b = c1.c join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c9 on c9.a = c2.c and c9.b = c2.c join eq_child as c10 on c10.a = c2.c and c10.b = c2.c join eq_child as c11 on c11.a = c2.c and c11.b = c2.c join eq_child as c12 on c12.a = c2.c and c12.b = c2.c join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c13 on c13.a = c3.c and c13.b = c3.c join eq_child as c14 on c14.a = c3.c and c14.b = c3.c join eq_child as c15 on c15.a = c3.c and c15.b = c3.c join eq_child as c16 on c16.a = c3.c and c16.b = c3.c join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c17 on c17.a = c4.c and c17.b = c4.c join eq_child as c18 on c18.a = c4.c and c18.b = c4.c join eq_child as c19 on c19.a = c4.c and c19.b = c4.c join eq_child as c20 on c20.a = c4.c and c20.b = c4.c ; select straight_join count(*) from parent join eq_child as c1 on c1.a = parent.b and c1.b = parent.b join eq_child as c5 on c5.a = c1.c and c5.b = c1.c join eq_child as c6 on c6.a = c1.c and c6.b = c1.c join eq_child as c7 on c7.a = c1.c and c7.b = c1.c join eq_child as c8 on c8.a = c1.c and c8.b = c1.c join eq_child as c2 on c2.a = parent.b and c2.b = parent.b join eq_child as c9 on c9.a = c2.c and c9.b = c2.c join eq_child as c10 on c10.a = c2.c and c10.b = c2.c join eq_child as c11 on c11.a = c2.c and c11.b = c2.c join eq_child as c12 on c12.a = c2.c and c12.b = c2.c join eq_child as c3 on c3.a = parent.b and c3.b = parent.b join eq_child as c13 on c13.a = c3.c and c13.b = c3.c join eq_child as c14 on c14.a = c3.c and c14.b = c3.c join eq_child as c15 on c15.a = c3.c and c15.b = c3.c join eq_child as c16 on c16.a = c3.c and c16.b = c3.c join eq_child as c4 on c4.a = parent.b and c4.b = parent.b join eq_child as c17 on c17.a = c4.c and c17.b = c4.c join eq_child as c18 on c18.a = c4.c and c18.b = c4.c join eq_child as c19 on c19.a = c4.c and c19.b = c4.c join eq_child as c20 on c20.a = c4.c and c20.b = c4.c ; Await completion or failure count(*) 8192 count(*) 8192 count(*) 8192 ================================= Run multiple 'query3' in parallel ================================= explain select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join ref_child as c2 on c2.a = parent.b join ref_child as c3 on c3.a = parent.b join ref_child as c4 on c4.a = parent.b join ref_child as c5 on c5.a = parent.b join ref_child as c6 on c6.a = parent.b join ref_child as c7 on c7.a = parent.b join ref_child as c8 on c8.a = parent.b join ref_child as c9 on c9.a = parent.b join ref_child as c10 on c10.a = parent.b join ref_child as c11 on c11.a = parent.b join ref_child as c12 on c12.a = parent.b join ref_child as c13 on c13.a = parent.b join ref_child as c14 on c14.a = parent.b join ref_child as c15 on c15.a = parent.b join ref_child as c16 on c16.a = parent.b where parent.a < 1000 ; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 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 where with pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null)); Using MRR 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Warnings: 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)) select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join ref_child as c2 on c2.a = parent.b join ref_child as c3 on c3.a = parent.b join ref_child as c4 on c4.a = parent.b join ref_child as c5 on c5.a = parent.b join ref_child as c6 on c6.a = parent.b join ref_child as c7 on c7.a = parent.b join ref_child as c8 on c8.a = parent.b join ref_child as c9 on c9.a = parent.b join ref_child as c10 on c10.a = parent.b join ref_child as c11 on c11.a = parent.b join ref_child as c12 on c12.a = parent.b join ref_child as c13 on c13.a = parent.b join ref_child as c14 on c14.a = parent.b join ref_child as c15 on c15.a = parent.b join ref_child as c16 on c16.a = parent.b where parent.a < 1000 ; select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join ref_child as c2 on c2.a = parent.b join ref_child as c3 on c3.a = parent.b join ref_child as c4 on c4.a = parent.b join ref_child as c5 on c5.a = parent.b join ref_child as c6 on c6.a = parent.b join ref_child as c7 on c7.a = parent.b join ref_child as c8 on c8.a = parent.b join ref_child as c9 on c9.a = parent.b join ref_child as c10 on c10.a = parent.b join ref_child as c11 on c11.a = parent.b join ref_child as c12 on c12.a = parent.b join ref_child as c13 on c13.a = parent.b join ref_child as c14 on c14.a = parent.b join ref_child as c15 on c15.a = parent.b join ref_child as c16 on c16.a = parent.b where parent.a < 1000 ; select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join ref_child as c2 on c2.a = parent.b join ref_child as c3 on c3.a = parent.b join ref_child as c4 on c4.a = parent.b join ref_child as c5 on c5.a = parent.b join ref_child as c6 on c6.a = parent.b join ref_child as c7 on c7.a = parent.b join ref_child as c8 on c8.a = parent.b join ref_child as c9 on c9.a = parent.b join ref_child as c10 on c10.a = parent.b join ref_child as c11 on c11.a = parent.b join ref_child as c12 on c12.a = parent.b join ref_child as c13 on c13.a = parent.b join ref_child as c14 on c14.a = parent.b join ref_child as c15 on c15.a = parent.b join ref_child as c16 on c16.a = parent.b where parent.a < 1000 ; Await completion or failure count(*) 999 count(*) 999 count(*) 999 ================================= Run multiple 'query4' in parallel ================================= explain select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b join ref_child as c2 on c2.a = parent.b join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b join ref_child as c3 on c3.a = parent.b join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b join ref_child as c4 on c4.a = parent.b join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b join ref_child as c5 on c5.a = parent.b join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b join ref_child as c6 on c6.a = parent.b join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b join ref_child as c7 on c7.a = parent.b join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b join ref_child as c8 on c8.a = parent.b join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b join ref_child as c9 on c9.a = parent.b join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b join ref_child as c10 on c10.a = parent.b join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b join ref_child as c11 on c11.a = parent.b join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b join ref_child as c12 on c12.a = parent.b join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b join ref_child as c13 on c13.a = parent.b join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b join ref_child as c14 on c14.a = parent.b join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b join ref_child as c15 on c15.a = parent.b join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b join ref_child as c16 on c16.a = parent.b join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b where parent.a < 1000 ; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 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 where with pushed condition ((`test`.`parent`.`a` < 1000) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null) and (`test`.`parent`.`b` is not null)); Using MRR 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 Warnings: Note 1003 Cannot push table 'c16eq' as child of 'parent'. Max number of pushable tables exceeded. 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)) select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b join ref_child as c2 on c2.a = parent.b join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b join ref_child as c3 on c3.a = parent.b join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b join ref_child as c4 on c4.a = parent.b join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b join ref_child as c5 on c5.a = parent.b join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b join ref_child as c6 on c6.a = parent.b join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b join ref_child as c7 on c7.a = parent.b join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b join ref_child as c8 on c8.a = parent.b join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b join ref_child as c9 on c9.a = parent.b join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b join ref_child as c10 on c10.a = parent.b join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b join ref_child as c11 on c11.a = parent.b join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b join ref_child as c12 on c12.a = parent.b join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b join ref_child as c13 on c13.a = parent.b join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b join ref_child as c14 on c14.a = parent.b join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b join ref_child as c15 on c15.a = parent.b join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b join ref_child as c16 on c16.a = parent.b join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b where parent.a < 1000 ; select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b join ref_child as c2 on c2.a = parent.b join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b join ref_child as c3 on c3.a = parent.b join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b join ref_child as c4 on c4.a = parent.b join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b join ref_child as c5 on c5.a = parent.b join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b join ref_child as c6 on c6.a = parent.b join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b join ref_child as c7 on c7.a = parent.b join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b join ref_child as c8 on c8.a = parent.b join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b join ref_child as c9 on c9.a = parent.b join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b join ref_child as c10 on c10.a = parent.b join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b join ref_child as c11 on c11.a = parent.b join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b join ref_child as c12 on c12.a = parent.b join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b join ref_child as c13 on c13.a = parent.b join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b join ref_child as c14 on c14.a = parent.b join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b join ref_child as c15 on c15.a = parent.b join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b join ref_child as c16 on c16.a = parent.b join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b where parent.a < 1000 ; select straight_join count(*) from parent join ref_child as c1 on c1.a = parent.b join eq_child as c1eq on c1eq.a = c1.a and c1eq.b = c1.b join ref_child as c2 on c2.a = parent.b join eq_child as c2eq on c2eq.a = c2.a and c2eq.b = c2.b join ref_child as c3 on c3.a = parent.b join eq_child as c3eq on c3eq.a = c3.a and c3eq.b = c3.b join ref_child as c4 on c4.a = parent.b join eq_child as c4eq on c4eq.a = c4.a and c4eq.b = c4.b join ref_child as c5 on c5.a = parent.b join eq_child as c5eq on c5eq.a = c5.a and c5eq.b = c5.b join ref_child as c6 on c6.a = parent.b join eq_child as c6eq on c6eq.a = c6.a and c6eq.b = c6.b join ref_child as c7 on c7.a = parent.b join eq_child as c7eq on c7eq.a = c7.a and c7eq.b = c7.b join ref_child as c8 on c8.a = parent.b join eq_child as c8eq on c8eq.a = c8.a and c8eq.b = c8.b join ref_child as c9 on c9.a = parent.b join eq_child as c9eq on c9eq.a = c9.a and c9eq.b = c9.b join ref_child as c10 on c10.a = parent.b join eq_child as c10eq on c10eq.a = c10.a and c10eq.b = c10.b join ref_child as c11 on c11.a = parent.b join eq_child as c11eq on c11eq.a = c11.a and c11eq.b = c11.b join ref_child as c12 on c12.a = parent.b join eq_child as c12eq on c12eq.a = c12.a and c12eq.b = c12.b join ref_child as c13 on c13.a = parent.b join eq_child as c13eq on c13eq.a = c13.a and c13eq.b = c13.b join ref_child as c14 on c14.a = parent.b join eq_child as c14eq on c14eq.a = c14.a and c14eq.b = c14.b join ref_child as c15 on c15.a = parent.b join eq_child as c15eq on c15eq.a = c15.a and c15eq.b = c15.b join ref_child as c16 on c16.a = parent.b join eq_child as c16eq on c16eq.a = c16.a and c16eq.b = c16.b where parent.a < 1000 ; Await completion or failure count(*) 999 count(*) 999 count(*) 999 drop table parent, eq_child, ref_child;
Close
