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.128.205.62
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_index_stat.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 -- source include/have_ndb.inc # Notes on index stats in *.test. # # Most tables here have few table rows. Index stats are not very # useful in such cases but the optimizer seems to use them anyway. # One reason may be that nested joins is only join method. # # In real production index stats are computed daily or weekly. # But tests here must compute them at once if "explain" is used. # Thus: insert (or other dml) - analyze table - explain. # # Index stats are approximate since only one replica was scanned # and values are interpolated from samples. MTR however should be # deterministic. If not use --replace column 9 # (rows). --disable_warnings DROP TABLE IF EXISTS t1, t2; --enable_warnings set @is_enable_default = @@global.ndb_index_stat_enable; let is_table_exists = `select count(*) <> 2 from information_schema.tables where table_name in ('ndb_index_stat_head', 'ndb_index_stat_sample') and table_schema='mysql'`; set @is_enable = 1; source ndb_index_stat_enable.inc; # test changing suboptions show global variables like 'ndb_index_stat_option'; set @save_option = @@global.ndb_index_stat_option; # some options set @@global.ndb_index_stat_option = 'loop_idle=3333,cache_limit=44M'; set @@global.ndb_index_stat_option = 'cache_lowpct=85,evict_delay=55'; set @@global.ndb_index_stat_option = 'check_delay=234s'; show global variables like 'ndb_index_stat_option'; set @@global.ndb_index_stat_option = @save_option; show global variables like 'ndb_index_stat_option'; # TEST: main create table t1 ( a1 int unsigned not null, b1 int unsigned not null, c1 int unsigned not null, primary key (a1), index b1x (b1), index c1x (c1) ) engine=ndb; create table t2 ( a2 int unsigned not null, b2 int unsigned not null, c2 int unsigned not null, primary key (a2), index b2x (b2), index c2x (c2) ) engine=ndb; # enough rows to make index stats more approximate --disable_query_log let $i = 1000; while ($i) { dec $i; eval insert into t1 values ($i, $i % 100, $i % 10); } let $i = 1000; while ($i) { dec $i; eval insert into t2 values ($i, $i % 10, $i % 100); } --enable_query_log analyze table t1, t2; # TEST: key equal constant --echo # must use b1x --replace_column 10 # 11 # explain select * from t1 where b1 = 5 and c1 = 5; --echo # must use c2x --replace_column 10 # 11 # explain select * from t2 where b2 = 5 and c2 = 5; # TEST: keys equal constant in join --echo # must use b1x, c2x --replace_column 10 # 11 # explain select * from t1, t2 where c1 = c2 and b1 = 5 and b2 = 5; --echo # must use c2x, b1x --replace_column 10 # 11 # explain select * from t1, t2 where b1 = b2 and c1 = 5 and c2 = 5; # TEST: join via keys of different selectivity --echo # must use t1, c2x --replace_column 10 # 11 # explain select * from t1, t2 where c1 = c2; --echo # must use t2, b1x --replace_column 10 # 11 # explain select * from t1, t2 where b1 = b2; # TEST: bug#44760 quick distinct # QUICK_GROUP_MIN_MAX_SELECT says "Using index for group-by". # Should happen only for low cardinality index. # wl4124_todo: result is wrong until HA_KEYREAD_ONLY is set --echo # should NOT say: Using index for group-by --replace_column 10 # 11 # explain select distinct (a1) from t1; --echo # must say: Using index for group by --replace_column 10 # 11 # explain select distinct (b1) from t1; --echo # must say: Using index for group by --replace_column 10 # 11 # explain select distinct (c1) from t1; # TEST: end drop table t1, t2; # turn index stats OFF in client (falls back on other methods) # code snippet moved from ndb_index_ordered.test create table t1 (a int, b int, c varchar(10) not null, primary key using hash (a), index(b,c)) engine=ndb; insert into t1 values (1,10,'aaa'),(2,10,'bbb'),(3,10,'ccc'), (4,20,'aaa'),(5,20,'bbb'),(6,20,'ccc'), (7,30,'aaa'),(8,30,'bbb'),(9,30,'ccc'); analyze table t1; let $is_loop = 4; while ($is_loop) { # 4-OFF 3-ON 2-OFF 1-ON let $is_enable = `select ($is_loop=3 or $is_loop=1)`; dec $is_loop; eval set @@local.ndb_index_stat_enable = $is_enable; select count(*) from t1 where b < 10; select count(*) from t1 where b >= 10 and c >= 'bbb'; select count(*) from t1 where b > 10; select count(*) from t1 where b <= 20 and c < 'ccc'; select count(*) from t1 where b = 20 and c = 'ccc'; select count(*) from t1 where b > 20; select count(*) from t1 where b = 30 and c > 'aaa'; select count(*) from t1 where b <= 20; select count(*) from t1 where b >= 20 and c > 'aaa'; } drop table t1; # bug#XXXXX # autocreate=false,enable=1 is now acceptable # following gives warning while "no stats" is counted as error create table t1 (a int, b int, primary key using hash (a), index x1 (b)) engine=ndb; insert into t1 values (1,11),(2,22),(3,33); # make_join_statistics() -> info() -> ndb_index_stat_set_rpk() # error 4715 - no stats select * from t1 order by a; # error 9003 suppressed - previous recent error select * from t1 order by a; # analyze clears previous error at once analyze table t1; drop table t1; # bug#XXXXX # wrong byte size from some types to NdbPack # before error fixes causes stats to be ignored silently (error 4716) # best seen with debug and export NDB_PACK_ABORT_ON_ERROR=1 # affected types: mediumint datetime date time timestamp create table t1 ( pk int not null, a tinyint not null, b tinyint unsigned not null, c smallint not null, d smallint unsigned not null, e mediumint not null, f mediumint unsigned not null, g int not null, h int unsigned not null, i bigint not null, j bigint unsigned not null, k float not null, l double not null, m decimal not null, n decimal unsigned not null, primary key using hash (pk), index (a), index (b), index (c), index (d), index (e), index (f), index (g), index (h), index (i), index (j), index (k), index (l), index (m), index (n) ) engine=ndb; insert into t1 values (1,11,11,11,11,11,11,11,11,11,11,11,11,11,11), (2,22,22,22,22,22,22,22,22,22,22,22,22,22,22), (3,33,33,33,33,33,33,33,33,33,33,33,33,33,33); let $i = 2; while ($i) { dec $i; if (!$i) { eval analyze table t1; } eval select count(*) from t1 where a > 22; eval select count(*) from t1 where b > 22; eval select count(*) from t1 where c > 22; eval select count(*) from t1 where d > 22; eval select count(*) from t1 where e > 22; eval select count(*) from t1 where f > 22; eval select count(*) from t1 where g > 22; eval select count(*) from t1 where h > 22; eval select count(*) from t1 where i > 22; eval select count(*) from t1 where j > 22; eval select count(*) from t1 where k > 22; eval select count(*) from t1 where l > 22; eval select count(*) from t1 where m > 22; eval select count(*) from t1 where n > 22; } drop table t1; create table t1 ( pk int not null, a datetime not null, b date not null, c year not null, d time not null, e timestamp not null, primary key using hash (pk), index (a), index (b), index (c), index (d), index (e) ) engine=ndb; insert into t1 values (1,'1971-01-01 01:01:01','1971-01-01','1971','01:01:01','1971-01-01 01:01:01'), (2,'1972-02-02 02:02:02','1972-02-02','1972','02:02:02','1972-02-02 02:02:02'), (3,'1973-03-03 03:03:03','1973-03-03','1973','03:03:03','1973-03-03 03:03:03'); let $i = 2; while ($i) { dec $i; if (!$i) { eval analyze table t1; } eval select count(*) from t1 where a > '1972-02-02 02:02:02'; eval select count(*) from t1 where b > '1972-02-02'; eval select count(*) from t1 where c > '1972'; eval select count(*) from t1 where d > '02:02:02'; eval select count(*) from t1 where e > '1972-02-02 02:02:02'; } drop table t1; create table t1 ( pk int not null, a char(10) not null, b varchar(10) not null, c varchar(1000) not null, d binary(10) not null, e varbinary(10) not null, f varbinary(1000) not null, primary key using hash (pk), index (a), index (b), index (c), index (d), index (e), index (f) ) engine=ndb; insert into t1 values ('1','111','111','111','111','111','111'), ('2','222','222','222','222','222','222'), ('3','333','333','333','333','333','333'); let $i = 2; while ($i) { dec $i; if (!$i) { eval analyze table t1; } eval select count(*) from t1 where a > '222'; eval select count(*) from t1 where b > '222'; eval select count(*) from t1 where c > '222'; eval select count(*) from t1 where d > '222'; eval select count(*) from t1 where e > '222'; eval select count(*) from t1 where f > '222'; } drop table t1; # # Check estimates of records per key for partial keys using unique/primary ordered index # create table t1 (a1 int, b1 int, primary key(b1), key(a1)) engine=ndbcluster partition by key() partitions 1; create table t2 (b2 int, c2 int, primary key(b2,c2)) engine=ndbcluster partition by key() partitions 1; --disable_query_log let $i = 100; while ($i) { eval insert into t1 (a1,b1) values ($i,$i); eval insert into t2 (b2,c2) values ($i mod 2, $i div 2); dec $i; } --enable_query_log --echo # table t1 is only for forcing record by key count for table t2 that should be near 50 (not 1) analyze table t1, t2; # Hide Extra column --replace_column 10 # explain select * from t1, t2 where b2 = b1 and a1 = 1; drop table t1, t2; # bugXXXXX rule b3.3 fix CREATE TABLE t1( K INT NOT NULL AUTO_INCREMENT, I INT, J INT, L INT, PRIMARY KEY(K), KEY(I,J), KEY(L) ) ENGINE=ndbcluster partition by key (K) partitions 1; INSERT INTO t1(I,J,L) VALUES (1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5), (6,6,6),(7,7,7),(8,8,8),(9,9,9),(0,0,0); INSERT INTO t1(I,J,L) SELECT I,1,I FROM t1; INSERT INTO t1(I,J,L) SELECT I,2,I FROM t1; INSERT INTO t1(I,J,L) SELECT I,3,I FROM t1; INSERT INTO t1(I,J,L) SELECT I,4,I FROM t1; INSERT INTO t1(I,J,L) SELECT I,5,I FROM t1; INSERT INTO t1(I,J,L) SELECT I,6,I FROM t1; INSERT INTO t1(I,J,L) SELECT I,7,I FROM t1; INSERT INTO t1(I,J,L) SELECT I,8,I FROM t1; select i, count(*) from t1 group by 1 order by 1; select l, count(*) from t1 group by 1 order by 1; ANALYZE TABLE t1; explain SELECT count(*) as Count FROM t1 WHERE I = 5; SELECT count(*) as Count FROM t1 WHERE I = 5; # before fix rows was 128 instead of 256 explain SELECT count(*) as Count FROM t1 WHERE L = 5; SELECT count(*) as Count FROM t1 WHERE L = 5; drop table t1; # bug#13407848 # signed char in compute length bytes caused ndbrequire in Trix.cpp create table t1 ( a int unsigned not null, b char(180) not null, primary key using hash (a), index (b) ) engine=ndb charset=binary; insert into t1 values (1,'a'),(2,'b'),(3,'c'); analyze table t1; analyze table t1; analyze table t1; drop table t1; # Bug#18715165 use test; CREATE TABLE t1 (id int unsigned NOT NULL auto_increment PRIMARY KEY, val int unsigned, UNIQUE (val)) ENGINE=NDBCluster; INSERT INTO test.t1 values (1,1), (2,2); --source suite/ndb/include/ndb_find_index_stat_tool.inc if (`select @@global.ndb_index_stat_enable`) { --exec $NDB_INDEX_STAT --update -d test t1 >> $NDB_TOOLS_OUTPUT } #clean up DROP TABLE t1; set @is_enable = @is_enable_default; source ndb_index_stat_enable.inc;
Close