| 1 |
CREATE LOGFILE GROUP lg_1 |
| 2 |
ADD UNDOFILE 'undo_1.log' |
| 3 |
INITIAL_SIZE 16M |
| 4 |
UNDO_BUFFER_SIZE = 1M |
| 5 |
ENGINE NDBCLUSTER; |
| 6 |
CREATE TABLESPACE ts_1 |
| 7 |
ADD DATAFILE 'data_1.dat' |
| 8 |
USE LOGFILE GROUP lg_1 |
| 9 |
ENGINE NDBCLUSTER; |
| 10 |
CREATE DATABASE diskdb; |
| 11 |
USE diskdb; |
| 12 |
CREATE TABLE t1 |
| 13 |
(id int unsigned NOT NULL auto_increment PRIMARY KEY, |
| 14 |
value varchar(10)) ENGINE NDBCLUSTER |
| 15 |
TABLESPACE ts_1 STORAGE DISK; |
| 16 |
INSERT INTO t1 (value) VALUES |
| 17 |
('abc'), ('def'), ('ghi'), ('jkl'), |
| 18 |
('mno'), ('pqr'), ('stu'), ('vwx'), ('yz'); |
| 19 |
Filename not given |
| 20 |
Filename not given |
| 21 |
Filename not given |
| 22 |
Filename not given |
| 23 |
DROP TABLE t1; |
| 24 |
DROP DATABASE diskdb; |
| 25 |
ALTER TABLESPACE ts_1 |
| 26 |
DROP DATAFILE 'data_1.dat'; |
| 27 |
DROP TABLESPACE ts_1; |
| 28 |
DROP LOGFILE GROUP lg_1 |
| 29 |
ENGINE NDBCLUSTER; |