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.23.92.44
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_add_partition.result
DROP TABLE IF EXISTS t1,t2; CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' INITIAL_SIZE 16M UNDO_BUFFER_SIZE = 1M ENGINE=NDB; CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP lg1 INITIAL_SIZE 64M ENGINE NDB; CREATE TABLE t1 (a int unsigned not null, b int unsigned not null, c int unsigned not null, primary key(a,c), unique (b)) ENGINE = NDB partition by key(a); CREATE TABLE t2 (a int unsigned not null, b int unsigned not null, c int unsigned not null, primary key(a,b), unique (b)) ENGINE = NDB STORAGE DISK TABLESPACE ts1 partition by key(a); CREATE TABLE t3 (a int unsigned not null, b int unsigned not null, c int unsigned not null, primary key(a,b), unique (b)) MAX_ROWS=50000000 ENGINE = NDB; CREATE TABLE t4 (a int unsigned not null, b int unsigned not null, c int unsigned not null, primary key(a,b), unique (b)) ENGINE = NDB; CREATE TABLE t5 (a int unsigned not null, b int unsigned not null, c int unsigned null, primary key(a,b), unique (b), unique (c)) ENGINE = NDB partition by key(a) partitions 3; Table: test.t1 FragmentCount: 2 b$unique(b) - UniqueHashIndex FragmentCount: 2 Table: test.t2 FragmentCount: 2 b$unique(b) - UniqueHashIndex FragmentCount: 2 Table: test.t3 FragmentCount: 4 b$unique(b) - UniqueHashIndex FragmentCount: 4 Table: test.t4 FragmentCount: 2 b$unique(b) - UniqueHashIndex FragmentCount: 2 Table: test.t5 FragmentCount: 3 b$unique(b) - UniqueHashIndex FragmentCount: 3 c$unique(c) - UniqueHashIndex FragmentCount: 3 INSERT INTO t1 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),(10,10,10), (11,11,11),(12,12,12),(13,13,13),(14,14,14),(15,15,15), (16,16,16),(17,17,17),(18,18,18),(19,19,19),(20,20,20), (21,21,21),(22,22,22),(23,23,23),(24,24,24),(25,25,25), (26,26,26),(27,27,27),(28,28,28),(29,29,29),(30,30,30), (31,31,31),(32,32,32),(33,33,33),(34,34,34),(35,35,35), (36,36,36),(37,37,37),(38,38,38),(39,39,39),(40,40,40), (41,41,41),(42,42,42),(43,43,43),(44,44,44),(45,45,45), (46,46,46),(47,47,47),(48,48,48),(49,49,49),(50,50,50), (51,51,51),(52,52,52),(53,53,53),(54,54,54),(55,55,55), (56,56,56),(57,57,57),(58,58,58),(59,59,59),(60,60,60), (61,61,61),(62,62,62),(63,63,63),(64,64,64),(65,65,65), (66,66,66),(67,67,67),(68,68,68),(69,69,69),(70,70,70), (71,71,71),(72,72,72),(73,73,73),(74,74,74),(75,75,75), (76,76,76),(77,77,77),(78,78,78),(79,79,79),(80,80,80), (81,81,81),(82,82,82),(83,83,83),(84,84,84),(85,85,85), (86,86,86),(87,87,87),(88,88,88),(89,89,89),(90,90,90), (91,91,91),(92,92,92),(93,93,93),(94,94,94),(95,95,95), (96,96,96),(97,97,97),(98,98,98),(99,99,99),(100,100,100); insert into t2 select * from t1; insert into t3 select * from t1; insert into t4 select * from t1; insert into t5 (a,b,c) select a,b,if(a%2,b,NULL) as c from t1; select count(*) from t1; count(*) 100 select count(*) from t2; count(*) 100 select count(*) from t3; count(*) 100 select count(*) from t4; count(*) 100 select count(*) from t5; count(*) 100 select * from t1 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t1 where a = 20; a b c 20 20 20 select * from t1 where a = 30; a b c 30 30 30 select * from t1 where a = 40; a b c 40 40 40 select * from t1 where a = 50; a b c 50 50 50 select * from t1 where b = 20; a b c 20 20 20 select * from t1 where b = 30; a b c 30 30 30 select * from t1 where b = 40; a b c 40 40 40 select * from t1 where b = 50; a b c 50 50 50 select * from t2 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t2 where a = 20; a b c 20 20 20 select * from t2 where a = 30; a b c 30 30 30 select * from t2 where a = 40; a b c 40 40 40 select * from t2 where a = 50; a b c 50 50 50 select * from t2 where b = 20; a b c 20 20 20 select * from t2 where b = 30; a b c 30 30 30 select * from t2 where b = 40; a b c 40 40 40 select * from t2 where b = 50; a b c 50 50 50 select * from t3 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t3 where a = 20; a b c 20 20 20 select * from t3 where a = 30; a b c 30 30 30 select * from t3 where a = 40; a b c 40 40 40 select * from t3 where a = 50; a b c 50 50 50 select * from t3 where b = 20; a b c 20 20 20 select * from t3 where b = 30; a b c 30 30 30 select * from t3 where b = 40; a b c 40 40 40 select * from t3 where b = 50; a b c 50 50 50 select * from t4 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t4 where a = 20; a b c 20 20 20 select * from t4 where a = 30; a b c 30 30 30 select * from t4 where a = 40; a b c 40 40 40 select * from t4 where a = 50; a b c 50 50 50 select * from t4 where b = 20; a b c 20 20 20 select * from t4 where b = 30; a b c 30 30 30 select * from t4 where b = 40; a b c 40 40 40 select * from t4 where b = 50; a b c 50 50 50 alter online table t1 reorganize partition; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead alter online table t2 reorganize partition; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead Cannot use normal reorganize partition on t3 as it has explicit MAX_ROWS set alter online table t3 reorganize partition; ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY. show warnings; Level Code Message Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead Warning 1105 Cannot online REORGANIZE a table with Max_Rows set. Use ALTER TABLE ... MAX_ROWS=<new_val> or offline REORGANIZE to redistribute this table. Error 1845 ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY. alter online table t3 max_rows=50000000; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead alter online table t4 reorganize partition; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead alter online table t5 partition by key() partitions 6; ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY. Check partitions added, expect 0 in all cases partitions added to t1 t1_added 0 partitions added to t2 t2_added 0 partitions added to t3 t3_added 0 partitions added to t4 t4_added 0 alter online table t1 add partition partitions 1; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead alter online table t2 add partition partitions 4; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead alter online table t3 max_rows=100000000; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead alter online table t4 max_rows=100000000; ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY. partitions added to t1 (expect 1) t1_added 1 partitions added to t2 (expect 4) t2_added 4 partitions added to t3 (expect 2) t3_added 2 partitions added to t4 (expect 0) t4_added 0 alter online table t1 reorganize partition; ERROR HY000: REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs alter online table t3 reorganize partition; ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY. show warnings; Level Code Message Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead Warning 1105 Cannot online REORGANIZE a table with Max_Rows set. Use ALTER TABLE ... MAX_ROWS=<new_val> or offline REORGANIZE to redistribute this table. Error 1845 ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY. alter online table t4 reorganize partition; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead select count(*) from t1; count(*) 100 select count(*) from t2; count(*) 100 select * from t1 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t1 where a = 20; a b c 20 20 20 select * from t1 where a = 30; a b c 30 30 30 select * from t1 where a = 40; a b c 40 40 40 select * from t1 where a = 50; a b c 50 50 50 select * from t1 where b = 20; a b c 20 20 20 select * from t1 where b = 30; a b c 30 30 30 select * from t1 where b = 40; a b c 40 40 40 select * from t1 where b = 50; a b c 50 50 50 select * from t2 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t2 where a = 20; a b c 20 20 20 select * from t2 where a = 30; a b c 30 30 30 select * from t2 where a = 40; a b c 40 40 40 select * from t2 where a = 50; a b c 50 50 50 select * from t2 where b = 20; a b c 20 20 20 select * from t2 where b = 30; a b c 30 30 30 select * from t2 where b = 40; a b c 40 40 40 select * from t2 where b = 50; a b c 50 50 50 select * from t3 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t3 where a = 20; a b c 20 20 20 select * from t3 where a = 30; a b c 30 30 30 select * from t3 where a = 40; a b c 40 40 40 select * from t3 where a = 50; a b c 50 50 50 select * from t3 where b = 20; a b c 20 20 20 select * from t3 where b = 30; a b c 30 30 30 select * from t3 where b = 40; a b c 40 40 40 select * from t3 where b = 50; a b c 50 50 50 select * from t4 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t4 where a = 20; a b c 20 20 20 select * from t4 where a = 30; a b c 30 30 30 select * from t4 where a = 40; a b c 40 40 40 select * from t4 where a = 50; a b c 50 50 50 select * from t4 where b = 20; a b c 20 20 20 select * from t4 where b = 30; a b c 30 30 30 select * from t4 where b = 40; a b c 40 40 40 select * from t4 where b = 50; a b c 50 50 50 Table: test.t4 FragmentCount: 2 b$unique(b) - UniqueHashIndex FragmentCount: 2 drop table t4; alter online table t1 add partition partitions 2; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead alter online table t2 add partition partitions 1; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead alter online table t3 max_rows=150000000; Warnings: Warning 1287 'ONLINE' is deprecated and will be removed in a future release. Please use ALGORITHM=INPLACE instead partitions added to t1 (expect 3) t1_added 3 partitions added to t2 (expect 5) t2_added 5 partitions added to t3 (expect 4) t3_added 4 select count(*) from t1; count(*) 100 select count(*) from t2; count(*) 100 select * from t1 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t1 where a = 20; a b c 20 20 20 select * from t1 where a = 30; a b c 30 30 30 select * from t1 where a = 40; a b c 40 40 40 select * from t1 where a = 50; a b c 50 50 50 select * from t1 where b = 20; a b c 20 20 20 select * from t1 where b = 30; a b c 30 30 30 select * from t1 where b = 40; a b c 40 40 40 select * from t1 where b = 50; a b c 50 50 50 select * from t2 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t2 where a = 20; a b c 20 20 20 select * from t2 where a = 30; a b c 30 30 30 select * from t2 where a = 40; a b c 40 40 40 select * from t2 where a = 50; a b c 50 50 50 select * from t2 where b = 20; a b c 20 20 20 select * from t2 where b = 30; a b c 30 30 30 select * from t2 where b = 40; a b c 40 40 40 select * from t2 where b = 50; a b c 50 50 50 select * from t3 where a < 20; a b c 1 1 1 10 10 10 11 11 11 12 12 12 13 13 13 14 14 14 15 15 15 16 16 16 17 17 17 18 18 18 19 19 19 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 8 8 8 9 9 9 select * from t3 where a = 20; a b c 20 20 20 select * from t3 where a = 30; a b c 30 30 30 select * from t3 where a = 40; a b c 40 40 40 select * from t3 where a = 50; a b c 50 50 50 select * from t3 where b = 20; a b c 20 20 20 select * from t3 where b = 30; a b c 30 30 30 select * from t3 where b = 40; a b c 40 40 40 select * from t3 where b = 50; a b c 50 50 50 Table: test.t1 FragmentCount: 5 b$unique(b) - UniqueHashIndex FragmentCount: 2 Table: test.t2 FragmentCount: 7 b$unique(b) - UniqueHashIndex FragmentCount: 2 Table: test.t3 FragmentCount: 8 b$unique(b) - UniqueHashIndex FragmentCount: 4 Table: test.t5 FragmentCount: 3 b$unique(b) - UniqueHashIndex FragmentCount: 3 c$unique(c) - UniqueHashIndex FragmentCount: 3 drop table t1,t2,t3,t5; alter tablespace ts1 drop datafile 'datafile.dat' engine = ndb; drop tablespace ts1 engine = ndb; drop logfile group lg1 engine = ndb;
Close