Gecko [ www.jdcpatala.org ]

Name	Size	Permission
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--

Code Editor : ndb_dd_dump.result

DROP TABLE IF EXISTS t1, t2, t3;
CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'undofile_lg1_01.dat'
INITIAL_SIZE 3M
UNDO_BUFFER_SIZE = 1M
ENGINE NDB;
ALTER LOGFILE GROUP lg1
ADD UNDOFILE 'undofile_lg1_02.dat'
INITIAL_SIZE = 6M 
ENGINE NDB;
CREATE TABLESPACE ts1
ADD DATAFILE 'datafile_ts1_01.dat'
USE LOGFILE GROUP lg1
EXTENT_SIZE 1M
INITIAL_SIZE 32M
ENGINE NDB;
ALTER TABLESPACE ts1
ADD DATAFILE 'datafile_ts1_02.dat'
INITIAL_SIZE = 3M 
ENGINE=NDB;
CREATE TABLESPACE ts2
ADD DATAFILE 'datafile_ts2_01.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 6M
ENGINE NDB;
CREATE TABLESPACE ts3
ADD DATAFILE 'datafile_ts3_01.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 12M
ENGINE NDB;
CREATE TABLE t1
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
TABLESPACE ts1 STORAGE DISK
ENGINE=NDB;
CREATE TABLE t2
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
TABLESPACE ts2 STORAGE DISK
ENGINE=NDB;
CREATE TABLE t3
(pk1 INT NOT NULL PRIMARY KEY, b INT NOT NULL, c INT NOT NULL)
TABLESPACE ts3 STORAGE DISK
ENGINE=NDB;
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),
(101,101,101),(102,102,102),(103,103,103),(104,104,104),(105,105,105),
(106,106,106),(107,107,107),(108,108,108),(109,109,109),(110,110,110),
(111,111,111),(112,112,112),(113,113,113),(114,114,114),(115,115,115),
(116,116,116),(117,117,117),(118,118,118),(119,119,119),(120,120,120),
(121,121,121),(122,122,122),(123,123,123),(124,124,124),(125,125,125),
(126,126,126),(127,127,127),(128,128,128),(129,129,129),(130,130,130),
(131,131,131),(132,132,132),(133,133,133),(134,134,134),(135,135,135),
(136,136,136),(137,137,137),(138,138,138),(139,139,139),(140,140,140),
(141,141,141),(142,142,142),(143,143,143),(144,144,144),(145,145,145),
(146,146,146),(147,147,147),(148,148,148),(149,149,149),(150,150,150),
(151,151,151),(152,152,152),(153,153,153),(154,154,154),(155,155,155),
(156,156,156),(157,157,157),(158,158,158),(159,159,159),(160,160,160),
(161,161,161),(162,162,162),(163,163,163),(164,164,164),(165,165,165),
(166,166,166),(167,167,167),(168,168,168),(169,169,169),(170,170,170),
(171,171,171),(172,172,172),(173,173,173),(174,174,174),(175,175,175),
(176,176,176),(177,177,177),(178,178,178),(179,179,179),(180,180,180),
(181,181,181),(182,182,182),(183,183,183),(184,184,184),(185,185,185),
(186,186,186),(187,187,187),(188,188,188),(189,189,189),(190,190,190),
(191,191,191),(192,192,192),(193,193,193),(194,194,194),(195,195,195),
(196,196,196),(197,197,197),(198,198,198),(199,199,199),(200,200,200),
(201,201,201),(202,202,202),(203,203,203),(204,204,204),(205,205,205),
(206,206,206),(207,207,207),(208,208,208),(209,209,209),(210,210,210),
(211,211,211),(212,212,212),(213,213,213),(214,214,214),(215,215,215),
(216,216,216),(217,217,217),(218,218,218),(219,219,219),(220,220,220),
(221,221,221),(222,222,222),(223,223,223),(224,224,224),(225,225,225),
(226,226,226),(227,227,227),(228,228,228),(229,229,229),(230,230,230),
(231,231,231),(232,232,232),(233,233,233),(234,234,234),(235,235,235),
(236,236,236),(237,237,237),(238,238,238),(239,239,239),(240,240,240),
(241,241,241),(242,242,242),(243,243,243),(244,244,244),(245,245,245),
(246,246,246),(247,247,247),(248,248,248),(249,249,249),(250,250,250),
(251,251,251),(252,252,252),(253,253,253),(254,254,254),(255,255,255),
(256,256,256),(257,257,257),(258,258,258),(259,259,259),(260,260,260),
(261,261,261),(262,262,262),(263,263,263),(264,264,264),(265,265,265),
(266,266,266),(267,267,267),(268,268,268),(269,269,269),(270,270,270),
(271,271,271),(272,272,272),(273,273,273),(274,274,274),(275,275,275),
(276,276,276),(277,277,277),(278,278,278),(279,279,279),(280,280,280),
(281,281,281),(282,282,282),(283,283,283),(284,284,284),(285,285,285),
(286,286,286),(287,287,287),(288,288,288),(289,289,289),(290,290,290),
(291,291,291),(292,292,292),(293,293,293),(294,294,294),(295,295,295),
(296,296,296),(297,297,297),(298,298,298),(299,299,299),(300,300,300),
(301,301,301),(302,302,302),(303,303,303),(304,304,304),(305,305,305),
(306,306,306),(307,307,307),(308,308,308),(309,309,309),(310,310,310),
(311,311,311),(312,312,312),(313,313,313),(314,314,314),(315,315,315),
(316,316,316),(317,317,317),(318,318,318),(319,319,319),(320,320,320),
(321,321,321),(322,322,322),(323,323,323),(324,324,324),(325,325,325),
(326,326,326),(327,327,327),(328,328,328),(329,329,329),(330,330,330),
(331,331,331),(332,332,332),(333,333,333),(334,334,334),(335,335,335),
(336,336,336),(337,337,337),(338,338,338),(339,339,339),(340,340,340),
(341,341,341),(342,342,342),(343,343,343),(344,344,344),(345,345,345),
(346,346,346),(347,347,347),(348,348,348),(349,349,349),(350,350,350),
(351,351,351),(352,352,352),(353,353,353),(354,354,354),(355,355,355),
(356,356,356),(357,357,357),(358,358,358),(359,359,359),(360,360,360),
(361,361,361),(362,362,362),(363,363,363),(364,364,364),(365,365,365),
(366,366,366),(367,367,367),(368,368,368),(369,369,369),(370,370,370),
(371,371,371),(372,372,372),(373,373,373),(374,374,374),(375,375,375),
(376,376,376),(377,377,377),(378,378,378),(379,379,379),(380,380,380),
(381,381,381),(382,382,382),(383,383,383),(384,384,384),(385,385,385),
(386,386,386),(387,387,387),(388,388,388),(389,389,389),(390,390,390),
(391,391,391),(392,392,392),(393,393,393),(394,394,394),(395,395,395),
(396,396,396),(397,397,397),(398,398,398),(399,399,399),(400,400,400),
(401,401,401),(402,402,402),(403,403,403),(404,404,404),(405,405,405),
(406,406,406),(407,407,407),(408,408,408),(409,409,409),(410,410,410),
(411,411,411),(412,412,412),(413,413,413),(414,414,414),(415,415,415),
(416,416,416),(417,417,417),(418,418,418),(419,419,419),(420,420,420),
(421,421,421),(422,422,422),(423,423,423),(424,424,424),(425,425,425),
(426,426,426),(427,427,427),(428,428,428),(429,429,429),(430,430,430),
(431,431,431),(432,432,432),(433,433,433),(434,434,434),(435,435,435),
(436,436,436),(437,437,437),(438,438,438),(439,439,439),(440,440,440),
(441,441,441),(442,442,442),(443,443,443),(444,444,444),(445,445,445),
(446,446,446),(447,447,447),(448,448,448),(449,449,449),(450,450,450),
(451,451,451),(452,452,452),(453,453,453),(454,454,454),(455,455,455),
(456,456,456),(457,457,457),(458,458,458),(459,459,459),(460,460,460),
(461,461,461),(462,462,462),(463,463,463),(464,464,464),(465,465,465),
(466,466,466),(467,467,467),(468,468,468),(469,469,469),(470,470,470),
(471,471,471),(472,472,472),(473,473,473),(474,474,474),(475,475,475),
(476,476,476),(477,477,477),(478,478,478),(479,479,479),(480,480,480),
(481,481,481),(482,482,482),(483,483,483),(484,484,484),(485,485,485),
(486,486,486),(487,487,487),(488,488,488),(489,489,489),(490,490,490),
(491,491,491),(492,492,492),(493,493,493),(494,494,494),(495,495,495),
(496,496,496),(497,497,497),(498,498,498),(499,499,499),(500, 500, 500);
INSERT INTO t2 VALUES 
(1,1,1),(2,2,2),(3,3,3),(4,4,4),(5,5,5);
INSERT INTO t3 VALUES 
(1,1,1);
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
ALTER TABLESPACE ts1 
DROP DATAFILE 'datafile_ts1_01.dat' 
ENGINE = NDB;
ALTER TABLESPACE ts1 
DROP DATAFILE 'datafile_ts1_02.dat' 
ENGINE = NDB;
ALTER TABLESPACE ts2 
DROP DATAFILE 'datafile_ts2_01.dat' 
ENGINE = NDB;
ALTER TABLESPACE ts3 
DROP DATAFILE 'datafile_ts3_01.dat' 
ENGINE = NDB;
DROP TABLESPACE ts1 ENGINE = NDB;
DROP TABLESPACE ts2 ENGINE = NDB;
DROP TABLESPACE ts3 ENGINE = NDB;
DROP LOGFILE GROUP lg1 ENGINE = NDB;
SELECT DISTINCT
LOGFILE_GROUP_NAME,
FILE_NAME,
TOTAL_EXTENTS,
INITIAL_SIZE,
ENGINE
FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE="UNDO LOG" ORDER BY FILE_NAME;
LOGFILE_GROUP_NAME	FILE_NAME	TOTAL_EXTENTS	INITIAL_SIZE	ENGINE
lg1	NULL	NULL	NULL	ndbcluster
lg1	undofile_lg1_01.dat	786432	3145728	ndbcluster
lg1	undofile_lg1_02.dat	1572864	6291456	ndbcluster
SELECT DISTINCT
TABLESPACE_NAME,
LOGFILE_GROUP_NAME, 
FILE_NAME,
EXTENT_SIZE,
INITIAL_SIZE,
ENGINE
FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE="DATAFILE" ORDER BY FILE_NAME;
TABLESPACE_NAME	LOGFILE_GROUP_NAME	FILE_NAME	EXTENT_SIZE	INITIAL_SIZE	ENGINE
ts1	lg1	datafile_ts1_01.dat	1048576	33554432	ndbcluster
ts1	lg1	datafile_ts1_02.dat	1048576	3145728	ndbcluster
ts2	lg1	datafile_ts2_01.dat	1048576	6291456	ndbcluster
ts3	lg1	datafile_ts3_01.dat	1048576	12582912	ndbcluster
SELECT COUNT(*) FROM t1;
COUNT(*)
500
SELECT COUNT(*) FROM t2;
COUNT(*)
5
SELECT COUNT(*) FROM t3;
COUNT(*)
1
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
CREATE TABLE test.t (
a smallint NOT NULL,
b int NOT NULL,
c bigint NOT NULL,
d char(10),
e TEXT,
f VARCHAR(255),
PRIMARY KEY(a)
) TABLESPACE ts1 STORAGE DISK ENGINE=NDB;
ALTER TABLE test.t ADD INDEX (d), ADD INDEX (f);
SHOW CREATE TABLE test.t;
Table	Create Table
t	CREATE TABLE `t` (
  `a` smallint(6) NOT NULL,
  `b` int(11) NOT NULL,
  `c` bigint(20) NOT NULL,
  `d` char(10) DEFAULT NULL,
  `e` text,
  `f` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`a`),
  KEY `d` (`d`),
  KEY `f` (`f`)
) /*!50100 TABLESPACE `ts1` STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
SELECT * FROM test.t order by a;
a	b	c	d	e	f
1	2	3	aaa1	bbb1	ccccc1
2	3	4	aaa2	bbb2	ccccc2
3	4	5	aaa3	bbb3	ccccc3
4	5	6	aaa4	bbb4	ccccc4
5	6	7	aaa5	bbb5	ccccc5
6	7	8	aaa6	bbb6	ccccc6
7	8	9	aaa7	bbb7	ccccc7
8	9	10	aaa8	bbb8	ccccc8
9	10	11	aaa9	bbb9	ccccc9
10	11	12	aaa10	bbb10	ccccc10
11	12	13	aaa11	bbb11	ccccc11
12	13	14	aaa12	bbb12	ccccc12
13	14	15	aaa13	bbb13	ccccc13
14	15	16	aaa14	bbb14	ccccc14
15	16	17	aaa15	bbb15	ccccc15
16	17	18	aaa16	bbb16	ccccc16
17	18	19	aaa17	bbb17	ccccc17
18	19	20	aaa18	bbb18	ccccc18
19	20	21	aaa19	bbb19	ccccc19
20	21	22	aaa20	bbb20	ccccc20
21	22	23	aaa21	bbb21	ccccc21
22	23	24	aaa22	bbb22	ccccc22
23	24	25	aaa23	bbb23	ccccc23
24	25	26	aaa24	bbb24	ccccc24
25	26	27	aaa25	bbb25	ccccc25
26	27	28	aaa26	bbb26	ccccc26
27	28	29	aaa27	bbb27	ccccc27
28	29	30	aaa28	bbb28	ccccc28
29	30	31	aaa29	bbb29	ccccc29
30	31	32	aaa30	bbb30	ccccc30
31	32	33	aaa31	bbb31	ccccc31
32	33	34	aaa32	bbb32	ccccc32
33	34	35	aaa33	bbb33	ccccc33
34	35	36	aaa34	bbb34	ccccc34
35	36	37	aaa35	bbb35	ccccc35
36	37	38	aaa36	bbb36	ccccc36
37	38	39	aaa37	bbb37	ccccc37
38	39	40	aaa38	bbb38	ccccc38
39	40	41	aaa39	bbb39	ccccc39
40	41	42	aaa40	bbb40	ccccc40
41	42	43	aaa41	bbb41	ccccc41
42	43	44	aaa42	bbb42	ccccc42
43	44	45	aaa43	bbb43	ccccc43
44	45	46	aaa44	bbb44	ccccc44
45	46	47	aaa45	bbb45	ccccc45
46	47	48	aaa46	bbb46	ccccc46
47	48	49	aaa47	bbb47	ccccc47
48	49	50	aaa48	bbb48	ccccc48
49	50	51	aaa49	bbb49	ccccc49
50	51	52	aaa50	bbb50	ccccc50
51	52	53	aaa51	bbb51	ccccc51
52	53	54	aaa52	bbb52	ccccc52
53	54	55	aaa53	bbb53	ccccc53
54	55	56	aaa54	bbb54	ccccc54
55	56	57	aaa55	bbb55	ccccc55
56	57	58	aaa56	bbb56	ccccc56
57	58	59	aaa57	bbb57	ccccc57
58	59	60	aaa58	bbb58	ccccc58
59	60	61	aaa59	bbb59	ccccc59
60	61	62	aaa60	bbb60	ccccc60
61	62	63	aaa61	bbb61	ccccc61
62	63	64	aaa62	bbb62	ccccc62
63	64	65	aaa63	bbb63	ccccc63
64	65	66	aaa64	bbb64	ccccc64
65	66	67	aaa65	bbb65	ccccc65
66	67	68	aaa66	bbb66	ccccc66
67	68	69	aaa67	bbb67	ccccc67
68	69	70	aaa68	bbb68	ccccc68
69	70	71	aaa69	bbb69	ccccc69
70	71	72	aaa70	bbb70	ccccc70
71	72	73	aaa71	bbb71	ccccc71
72	73	74	aaa72	bbb72	ccccc72
73	74	75	aaa73	bbb73	ccccc73
74	75	76	aaa74	bbb74	ccccc74
75	76	77	aaa75	bbb75	ccccc75
76	77	78	aaa76	bbb76	ccccc76
77	78	79	aaa77	bbb77	ccccc77
78	79	80	aaa78	bbb78	ccccc78
79	80	81	aaa79	bbb79	ccccc79
80	81	82	aaa80	bbb80	ccccc80
81	82	83	aaa81	bbb81	ccccc81
82	83	84	aaa82	bbb82	ccccc82
83	84	85	aaa83	bbb83	ccccc83
84	85	86	aaa84	bbb84	ccccc84
85	86	87	aaa85	bbb85	ccccc85
86	87	88	aaa86	bbb86	ccccc86
87	88	89	aaa87	bbb87	ccccc87
88	89	90	aaa88	bbb88	ccccc88
89	90	91	aaa89	bbb89	ccccc89
90	91	92	aaa90	bbb90	ccccc90
91	92	93	aaa91	bbb91	ccccc91
92	93	94	aaa92	bbb92	ccccc92
93	94	95	aaa93	bbb93	ccccc93
94	95	96	aaa94	bbb94	ccccc94
95	96	97	aaa95	bbb95	ccccc95
96	97	98	aaa96	bbb96	ccccc96
97	98	99	aaa97	bbb97	ccccc97
98	99	100	aaa98	bbb98	ccccc98
99	100	101	aaa99	bbb99	ccccc99
100	101	102	aaa100	bbb100	ccccc100
SELECT * INTO OUTFILE 't_backup' FROM test.t;
TRUNCATE test.t;
SELECT count(*) FROM test.t;
count(*)
0
LOAD DATA INFILE 't_backup' INTO TABLE test.t;
SELECT * FROM test.t order by a;
a	b	c	d	e	f
1	2	3	aaa1	bbb1	ccccc1
2	3	4	aaa2	bbb2	ccccc2
3	4	5	aaa3	bbb3	ccccc3
4	5	6	aaa4	bbb4	ccccc4
5	6	7	aaa5	bbb5	ccccc5
6	7	8	aaa6	bbb6	ccccc6
7	8	9	aaa7	bbb7	ccccc7
8	9	10	aaa8	bbb8	ccccc8
9	10	11	aaa9	bbb9	ccccc9
10	11	12	aaa10	bbb10	ccccc10
11	12	13	aaa11	bbb11	ccccc11
12	13	14	aaa12	bbb12	ccccc12
13	14	15	aaa13	bbb13	ccccc13
14	15	16	aaa14	bbb14	ccccc14
15	16	17	aaa15	bbb15	ccccc15
16	17	18	aaa16	bbb16	ccccc16
17	18	19	aaa17	bbb17	ccccc17
18	19	20	aaa18	bbb18	ccccc18
19	20	21	aaa19	bbb19	ccccc19
20	21	22	aaa20	bbb20	ccccc20
21	22	23	aaa21	bbb21	ccccc21
22	23	24	aaa22	bbb22	ccccc22
23	24	25	aaa23	bbb23	ccccc23
24	25	26	aaa24	bbb24	ccccc24
25	26	27	aaa25	bbb25	ccccc25
26	27	28	aaa26	bbb26	ccccc26
27	28	29	aaa27	bbb27	ccccc27
28	29	30	aaa28	bbb28	ccccc28
29	30	31	aaa29	bbb29	ccccc29
30	31	32	aaa30	bbb30	ccccc30
31	32	33	aaa31	bbb31	ccccc31
32	33	34	aaa32	bbb32	ccccc32
33	34	35	aaa33	bbb33	ccccc33
34	35	36	aaa34	bbb34	ccccc34
35	36	37	aaa35	bbb35	ccccc35
36	37	38	aaa36	bbb36	ccccc36
37	38	39	aaa37	bbb37	ccccc37
38	39	40	aaa38	bbb38	ccccc38
39	40	41	aaa39	bbb39	ccccc39
40	41	42	aaa40	bbb40	ccccc40
41	42	43	aaa41	bbb41	ccccc41
42	43	44	aaa42	bbb42	ccccc42
43	44	45	aaa43	bbb43	ccccc43
44	45	46	aaa44	bbb44	ccccc44
45	46	47	aaa45	bbb45	ccccc45
46	47	48	aaa46	bbb46	ccccc46
47	48	49	aaa47	bbb47	ccccc47
48	49	50	aaa48	bbb48	ccccc48
49	50	51	aaa49	bbb49	ccccc49
50	51	52	aaa50	bbb50	ccccc50
51	52	53	aaa51	bbb51	ccccc51
52	53	54	aaa52	bbb52	ccccc52
53	54	55	aaa53	bbb53	ccccc53
54	55	56	aaa54	bbb54	ccccc54
55	56	57	aaa55	bbb55	ccccc55
56	57	58	aaa56	bbb56	ccccc56
57	58	59	aaa57	bbb57	ccccc57
58	59	60	aaa58	bbb58	ccccc58
59	60	61	aaa59	bbb59	ccccc59
60	61	62	aaa60	bbb60	ccccc60
61	62	63	aaa61	bbb61	ccccc61
62	63	64	aaa62	bbb62	ccccc62
63	64	65	aaa63	bbb63	ccccc63
64	65	66	aaa64	bbb64	ccccc64
65	66	67	aaa65	bbb65	ccccc65
66	67	68	aaa66	bbb66	ccccc66
67	68	69	aaa67	bbb67	ccccc67
68	69	70	aaa68	bbb68	ccccc68
69	70	71	aaa69	bbb69	ccccc69
70	71	72	aaa70	bbb70	ccccc70
71	72	73	aaa71	bbb71	ccccc71
72	73	74	aaa72	bbb72	ccccc72
73	74	75	aaa73	bbb73	ccccc73
74	75	76	aaa74	bbb74	ccccc74
75	76	77	aaa75	bbb75	ccccc75
76	77	78	aaa76	bbb76	ccccc76
77	78	79	aaa77	bbb77	ccccc77
78	79	80	aaa78	bbb78	ccccc78
79	80	81	aaa79	bbb79	ccccc79
80	81	82	aaa80	bbb80	ccccc80
81	82	83	aaa81	bbb81	ccccc81
82	83	84	aaa82	bbb82	ccccc82
83	84	85	aaa83	bbb83	ccccc83
84	85	86	aaa84	bbb84	ccccc84
85	86	87	aaa85	bbb85	ccccc85
86	87	88	aaa86	bbb86	ccccc86
87	88	89	aaa87	bbb87	ccccc87
88	89	90	aaa88	bbb88	ccccc88
89	90	91	aaa89	bbb89	ccccc89
90	91	92	aaa90	bbb90	ccccc90
91	92	93	aaa91	bbb91	ccccc91
92	93	94	aaa92	bbb92	ccccc92
93	94	95	aaa93	bbb93	ccccc93
94	95	96	aaa94	bbb94	ccccc94
95	96	97	aaa95	bbb95	ccccc95
96	97	98	aaa96	bbb96	ccccc96
97	98	99	aaa97	bbb97	ccccc97
98	99	100	aaa98	bbb98	ccccc98
99	100	101	aaa99	bbb99	ccccc99
100	101	102	aaa100	bbb100	ccccc100
DROP TABLE test.t;
ALTER TABLESPACE ts1 
DROP DATAFILE 'datafile_ts1_01.dat' 
ENGINE = NDB;
ALTER TABLESPACE ts1 
DROP DATAFILE 'datafile_ts1_02.dat' 
ENGINE = NDB;
ALTER TABLESPACE ts2 
DROP DATAFILE 'datafile_ts2_01.dat' 
ENGINE = NDB;
ALTER TABLESPACE ts3 
DROP DATAFILE 'datafile_ts3_01.dat' 
ENGINE = NDB;
DROP TABLESPACE ts1 ENGINE = NDB;
DROP TABLESPACE ts2 ENGINE = NDB;
DROP TABLESPACE ts3 ENGINE = NDB;
DROP LOGFILE GROUP lg1 ENGINE = NDB;

${this.title}

Code Editor : ndb_dd_dump.result