1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64
|
CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'undofile.dat'
INITIAL_SIZE 16M
UNDO_BUFFER_SIZE = 1M
ENGINE NDB;
CREATE TABLESPACE ts1
ADD DATAFILE 'ts1_datafile.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 64M
ENGINE NDB;
CREATE TABLESPACE ts2
ADD DATAFILE 'ts2_datafile.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 64M
ENGINE NDB;
CREATE TABLE t1 (
a INT PRIMARY KEY
)
ENGINE NDB
PARTITION BY RANGE (a)
PARTITIONS 2 (
PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
PARTITION p2 VALUES LESS THAN MAXVALUE TABLESPACE ts2);
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` int NOT NULL,
PRIMARY KEY (`a`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY RANGE (`a`)
(PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = ndbcluster,
PARTITION p2 VALUES LESS THAN MAXVALUE TABLESPACE = `ts2` ENGINE = ndbcluster) */
INSERT INTO t1 VALUES (1),(10);
SELECT * FROM t1;
a
1
10
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` int NOT NULL,
PRIMARY KEY (`a`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY RANGE (`a`)
(PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = ndbcluster,
PARTITION p2 VALUES LESS THAN MAXVALUE TABLESPACE = `ts2` ENGINE = ndbcluster) */
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` int NOT NULL,
PRIMARY KEY (`a`)
) ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY RANGE (`a`)
(PARTITION p1 VALUES LESS THAN (2) TABLESPACE = `ts1` ENGINE = ndbcluster,
PARTITION p2 VALUES LESS THAN MAXVALUE TABLESPACE = `ts2` ENGINE = ndbcluster) */
DROP TABLE t1;
ALTER TABLESPACE ts1
DROP DATAFILE 'ts1_datafile.dat';
DROP TABLESPACE ts1;
ALTER TABLESPACE ts2
DROP DATAFILE 'ts2_datafile.dat';
DROP TABLESPACE ts2;
DROP LOGFILE GROUP lg1
ENGINE NDB;
|