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 | : 13.59.196.41
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_spj_dict.result
use test; create table parent(a int primary key, b int not null, key(b)) engine=myisam; create table child(a int, b int, primary key(a,b), key(b)) engine=myisam; insert into parent values (1,1), (2,2), (3,3), (4,4); insert into parent select a+4, b+4 from parent; insert into parent select a+8, b+8 from parent; insert into parent select a+16, b+16 from parent; insert into parent select a+32, b+32 from parent; insert into parent select a+64, b+64 from parent; insert into parent select a+128, b+128 from parent; insert into parent select a+256, b+256 from parent; insert into parent select a+512, b+512 from parent; insert into parent select a+1024, b+1024 from parent; insert into parent select a+(2*1024), b+(2*1024) from parent; insert into parent select a+(4*1024), b+(4*1024) from parent; insert into parent select a+(8*1024), b+(8*1024) from parent; insert into parent select a+(16*1024), b+(16*1024) from parent; insert into child select * from parent; alter table parent engine=ndb; alter table child engine=ndb; show variables like 'server_id'; Variable_name Value server_id 1 set ndb_join_pushdown = true; ============================================ Early 'online' drop of REF'ed child's KEY b. ============================================ explain select straight_join count(*) from parent join child on child.b = parent.a where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 ref b b 4 test.parent.a ### ### Child of 'parent' in pushed join@1 Warnings: Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table child algorithm=inplace, drop key b; commit; alter table child add key(b); ============================================ Late 'online' drop of REF'ed child's KEY b. ============================================ explain select straight_join count(*) from parent join child on child.b = parent.a where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 ref b b 4 test.parent.a ### ### Child of 'parent' in pushed join@1 Warnings: Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table child algorithm=inplace, drop key b; commit; alter table child add key(b); ============================================ Early drop of EQ_REF'ed child's PRIMARY KEY. ============================================ explain select straight_join count(*) from parent join child on child.a = parent.a and child.b = parent.b where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 eq_ref PRIMARY,b PRIMARY 8 test.parent.a,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`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`b`) and (`test`.`child`.`a` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table child drop primary key; commit; alter table child add primary key(a,b); ============================================================= Drop of EQ_REF'ed child's PRIMARY KEY after executed a while. ============================================================= explain select straight_join count(*) from parent join child on child.a = parent.a and child.b = parent.b where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 eq_ref PRIMARY,b PRIMARY 8 test.parent.a,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`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`b`) and (`test`.`child`.`a` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table child drop primary key; commit; alter table child add primary key(a,b); =========================================================== ONLINE ALTER: Rename table to make it go away - temporarily =========================================================== explain select straight_join count(*) from parent join child on child.a = parent.a and child.b = parent.b where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 eq_ref PRIMARY,b PRIMARY 8 test.parent.a,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`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`b`) and (`test`.`child`.`a` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table child algorithm=inplace, rename to child_orig; commit; alter table child_orig rename to child; ======================================*===================== OFFLINE ALTER: Rename table to make it go away - temporarily ==========================================*================= explain select straight_join count(*) from parent join child on child.a = parent.a and child.b = parent.b where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 eq_ref PRIMARY,b PRIMARY 8 test.parent.a,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`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`b`) and (`test`.`child`.`a` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table child algorithm=copy, rename to child_orig; commit; alter table child_orig rename to child; ================================================================= ONLINE ALTER: drop + recreate table 'child' key b in use by query ================================================================= explain select straight_join count(*) from parent join child on child.b = parent.a where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 ref b b 4 test.parent.a ### ### Child of 'parent' in pushed join@1 Warnings: Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table child algorithm=inplace, drop key b; alter table child add key(b); ================================================================== ONLINE ALTER: drop + recreate table 'parent' key b in use by query ================================================================== explain select straight_join count(*) from parent join child on child.a = parent.a and child.b = parent.b where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 eq_ref PRIMARY,b PRIMARY 8 test.parent.a,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`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`b`) and (`test`.`child`.`a` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table parent algorithm=inplace, drop key b; alter table parent add key(b); =============================================== OFFLINE ALTER: add + drop column c from 'child' =============================================== explain select straight_join count(*) from parent join child on child.a = parent.a and child.b = parent.b where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 eq_ref PRIMARY,b PRIMARY 8 test.parent.a,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`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`b`) and (`test`.`child`.`a` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table child algorithm=copy, add column c int; alter table child drop column c; ========================================================== OFFLINE ALTER: drop + recreate primary key(a,b) for 'child' ========================================================== explain select straight_join count(*) from parent join child on child.a = parent.a where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 ref PRIMARY PRIMARY 4 test.parent.a ### ### Child of 'parent' in pushed join@1 Warnings: Note 1003 /* select#1 */ select straight_join count(0) AS `count(*)` from `test`.`parent` join `test`.`child` where ((`test`.`child`.`a` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) alter table child algorithm=copy, drop primary key; alter table child add primary key(a,b); ================== DROP TABLE 'child' ================== explain select straight_join count(*) from parent join child on child.a = parent.a and child.b = parent.b where parent.b > 5; 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 range PRIMARY,b b 4 NULL ### ### Parent of 2 pushed join@1; Using where with pushed condition (`test`.`parent`.`b` > 5); Using MRR 1 SIMPLE child p0,p1,p2,p3,p4,p5,p6,p7 eq_ref PRIMARY,b PRIMARY 8 test.parent.a,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`.`child` where ((`test`.`child`.`b` = `test`.`parent`.`b`) and (`test`.`child`.`a` = `test`.`parent`.`a`) and (`test`.`parent`.`b` > 5)) drop table child; =========== Cleaning up =========== drop table if exists parent;
Close