CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'undofile01.dat'
INITIAL_SIZE 20M
UNDO_BUFFER_SIZE = 8M
ENGINE=NDB;
CREATE TABLESPACE ts1
ADD DATAFILE 'datafile01.dat'
USE LOGFILE GROUP lg1 
INITIAL_SIZE = 20M 
ENGINE NDB;

drop table if exists t1;
CREATE TABLE t1
     (pk1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
           word CHAR(20))
	   STORAGE DISK tablespace ts1
	   ENGINE=NDB;

--echo **** Add more rows ****
let $j= 500;
--disable_query_log
while ($j)
{
  LOAD DATA INFILE '../std_data_ln/words.dat' INTO TABLE t1 (word);
  dec $j;
}
--enable_query_log

select count(*) from t1;
select file_name, free_extents, total_extents from information_schema.files;

drop table t1;
alter tablespace ts1 drop datafile 'datafile01.dat' engine=ndb;
drop tablespace ts1 engine = ndb;
drop logfile group lg1 engine = ndb;