107 lines
2.7 KiB
Plaintext
107 lines
2.7 KiB
Plaintext
SET information_schema_stats_expiry=0;
|
|
CREATE LOGFILE GROUP lg_1
|
|
ADD UNDOFILE 'undofile.dat'
|
|
INITIAL_SIZE 16M
|
|
UNDO_BUFFER_SIZE = 1M
|
|
ENGINE=NDB;
|
|
id type state logging database schema name
|
|
logfilegroup_objectid LogfileGroup Online - lg_1
|
|
|
|
NDBT_ProgramExit: 0 - OK
|
|
|
|
id type state logging database schema name
|
|
undofile_objectid Undofile Online - undofile.dat
|
|
|
|
NDBT_ProgramExit: 0 - OK
|
|
|
|
ALTER LOGFILE GROUP lg_1
|
|
ADD UNDOFILE 'undofile1.dat'
|
|
INITIAL_SIZE 16M
|
|
ENGINE=NDB;
|
|
SELECT FILE_NAME, FILE_TYPE, LOGFILE_GROUP_NAME, ENGINE,
|
|
TOTAL_EXTENTS, EXTENT_SIZE, INITIAL_SIZE, MAXIMUM_SIZE, EXTRA
|
|
FROM INFORMATION_SCHEMA.FILES
|
|
WHERE ENGINE='ndbcluster' AND FILE_TYPE='UNDO LOG';
|
|
FILE_NAME ./undofile.dat
|
|
FILE_TYPE UNDO LOG
|
|
LOGFILE_GROUP_NAME lg_1
|
|
ENGINE ndbcluster
|
|
TOTAL_EXTENTS 4194304
|
|
EXTENT_SIZE 4
|
|
INITIAL_SIZE 16777216
|
|
MAXIMUM_SIZE 16777216
|
|
EXTRA UNDO_BUFFER_SIZE=1048576
|
|
FILE_NAME ./undofile1.dat
|
|
FILE_TYPE UNDO LOG
|
|
LOGFILE_GROUP_NAME lg_1
|
|
ENGINE ndbcluster
|
|
TOTAL_EXTENTS 4194304
|
|
EXTENT_SIZE 4
|
|
INITIAL_SIZE 16777216
|
|
MAXIMUM_SIZE 16777216
|
|
EXTRA UNDO_BUFFER_SIZE=1048576
|
|
CREATE TABLESPACE ts_1
|
|
ADD DATAFILE 'datafile.dat'
|
|
USE LOGFILE GROUP lg_1
|
|
INITIAL_SIZE 2M
|
|
ENGINE NDB;
|
|
id type state logging database schema name
|
|
datafile_objectid Datafile Online - datafile.dat
|
|
|
|
NDBT_ProgramExit: 0 - OK
|
|
|
|
ALTER TABLESPACE ts_1
|
|
ADD DATAFILE 'datafile2.dat'
|
|
INITIAL_SIZE = 4M;
|
|
CREATE TABLE t1 (
|
|
a int PRIMARY KEY,
|
|
b varchar(255)
|
|
) ENGINE = NDB
|
|
TABLESPACE ts_1
|
|
STORAGE DISK;
|
|
INSERT INTO t1 VALUES (1, "We have got Chhetri");
|
|
SELECT FILE_NAME, FILE_TYPE, TABLESPACE_NAME,
|
|
LOGFILE_GROUP_NAME, ENGINE, FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE,
|
|
INITIAL_SIZE, MAXIMUM_SIZE, ROW_FORMAT
|
|
FROM INFORMATION_SCHEMA.FILES
|
|
WHERE ENGINE='ndbcluster' AND FILE_TYPE='DATAFILE';
|
|
FILE_NAME ./datafile.dat
|
|
FILE_TYPE DATAFILE
|
|
TABLESPACE_NAME ts_1
|
|
LOGFILE_GROUP_NAME lg_1
|
|
ENGINE ndbcluster
|
|
FREE_EXTENTS 2
|
|
TOTAL_EXTENTS 2
|
|
EXTENT_SIZE 1048576
|
|
INITIAL_SIZE 2097152
|
|
MAXIMUM_SIZE 2097152
|
|
ROW_FORMAT FIXED
|
|
FILE_NAME ./datafile2.dat
|
|
FILE_TYPE DATAFILE
|
|
TABLESPACE_NAME ts_1
|
|
LOGFILE_GROUP_NAME lg_1
|
|
ENGINE ndbcluster
|
|
FREE_EXTENTS 3
|
|
TOTAL_EXTENTS 4
|
|
EXTENT_SIZE 1048576
|
|
INITIAL_SIZE 4194304
|
|
MAXIMUM_SIZE 4194304
|
|
ROW_FORMAT FIXED
|
|
DROP TABLE t1;
|
|
SELECT FILE_NAME, FREE_EXTENTS, TOTAL_EXTENTS
|
|
FROM information_schema.files
|
|
WHERE ENGINE='ndbcluster' AND FILE_TYPE='DATAFILE';
|
|
FILE_NAME ./datafile.dat
|
|
FREE_EXTENTS 2
|
|
TOTAL_EXTENTS 2
|
|
FILE_NAME ./datafile2.dat
|
|
FREE_EXTENTS 4
|
|
TOTAL_EXTENTS 4
|
|
ALTER TABLESPACE ts_1
|
|
DROP DATAFILE 'datafile.dat';
|
|
ALTER TABLESPACE ts_1
|
|
DROP DATAFILE 'datafile2.dat';
|
|
DROP TABLESPACE ts_1;
|
|
DROP LOGFILE GROUP lg_1
|
|
ENGINE=NDB;
|