| 1 |
SET information_schema_stats_expiry=0; |
| 2 |
CREATE LOGFILE GROUP lg_1 |
| 3 |
ADD UNDOFILE 'undofile.dat' |
| 4 |
INITIAL_SIZE 16M |
| 5 |
UNDO_BUFFER_SIZE = 1M |
| 6 |
ENGINE=NDB; |
| 7 |
SELECT id, fq_name FROM ndbinfo.dict_obj_info WHERE type = 21; |
| 8 |
id fq_name |
| 9 |
logfilegroup_objectid lg_1 |
| 10 |
|
| 11 |
SELECT id, fq_name FROM ndbinfo.dict_obj_info WHERE type = 23; |
| 12 |
id fq_name |
| 13 |
undofile_objectid undofile.dat |
| 14 |
|
| 15 |
ALTER LOGFILE GROUP lg_1 |
| 16 |
ADD UNDOFILE 'undofile1.dat' |
| 17 |
INITIAL_SIZE 16M |
| 18 |
ENGINE=NDB; |
| 19 |
SELECT FILE_NAME, FILE_TYPE, LOGFILE_GROUP_NAME, ENGINE, |
| 20 |
TOTAL_EXTENTS, EXTENT_SIZE, INITIAL_SIZE, MAXIMUM_SIZE, EXTRA |
| 21 |
FROM INFORMATION_SCHEMA.FILES |
| 22 |
WHERE ENGINE='ndbcluster' AND FILE_TYPE='UNDO LOG'; |
| 23 |
FILE_NAME ./undofile.dat |
| 24 |
FILE_TYPE UNDO LOG |
| 25 |
LOGFILE_GROUP_NAME lg_1 |
| 26 |
ENGINE ndbcluster |
| 27 |
TOTAL_EXTENTS 4194304 |
| 28 |
EXTENT_SIZE 4 |
| 29 |
INITIAL_SIZE 16777216 |
| 30 |
MAXIMUM_SIZE 16777216 |
| 31 |
EXTRA UNDO_BUFFER_SIZE=1048576 |
| 32 |
FILE_NAME ./undofile1.dat |
| 33 |
FILE_TYPE UNDO LOG |
| 34 |
LOGFILE_GROUP_NAME lg_1 |
| 35 |
ENGINE ndbcluster |
| 36 |
TOTAL_EXTENTS 4194304 |
| 37 |
EXTENT_SIZE 4 |
| 38 |
INITIAL_SIZE 16777216 |
| 39 |
MAXIMUM_SIZE 16777216 |
| 40 |
EXTRA UNDO_BUFFER_SIZE=1048576 |
| 41 |
CREATE TABLESPACE ts_1 |
| 42 |
ADD DATAFILE 'datafile.dat' |
| 43 |
USE LOGFILE GROUP lg_1 |
| 44 |
INITIAL_SIZE 2M |
| 45 |
ENGINE NDB; |
| 46 |
Check that the datafiles FILE_ID column in INFORMATION_SCHEMA.FILES |
| 47 |
is the same as its object id in NDB(as reported by ndbinfo) |
| 48 |
|
| 49 |
ALTER TABLESPACE ts_1 |
| 50 |
ADD DATAFILE 'datafile2.dat' |
| 51 |
INITIAL_SIZE = 4M; |
| 52 |
CREATE TABLE t1 ( |
| 53 |
a int PRIMARY KEY, |
| 54 |
b varchar(255) |
| 55 |
) ENGINE = NDB |
| 56 |
TABLESPACE ts_1 |
| 57 |
STORAGE DISK; |
| 58 |
INSERT INTO t1 VALUES (1, "We have got Chhetri"); |
| 59 |
SELECT FILE_NAME, FILE_TYPE, TABLESPACE_NAME, |
| 60 |
LOGFILE_GROUP_NAME, ENGINE, FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE, |
| 61 |
INITIAL_SIZE, MAXIMUM_SIZE, ROW_FORMAT |
| 62 |
FROM INFORMATION_SCHEMA.FILES |
| 63 |
WHERE ENGINE='ndbcluster' AND FILE_TYPE='DATAFILE'; |
| 64 |
FILE_NAME ./datafile.dat |
| 65 |
FILE_TYPE DATAFILE |
| 66 |
TABLESPACE_NAME ts_1 |
| 67 |
LOGFILE_GROUP_NAME lg_1 |
| 68 |
ENGINE ndbcluster |
| 69 |
FREE_EXTENTS 2 |
| 70 |
TOTAL_EXTENTS 2 |
| 71 |
EXTENT_SIZE 1048576 |
| 72 |
INITIAL_SIZE 2097152 |
| 73 |
MAXIMUM_SIZE 2097152 |
| 74 |
ROW_FORMAT FIXED |
| 75 |
FILE_NAME ./datafile2.dat |
| 76 |
FILE_TYPE DATAFILE |
| 77 |
TABLESPACE_NAME ts_1 |
| 78 |
LOGFILE_GROUP_NAME lg_1 |
| 79 |
ENGINE ndbcluster |
| 80 |
FREE_EXTENTS 3 |
| 81 |
TOTAL_EXTENTS 4 |
| 82 |
EXTENT_SIZE 1048576 |
| 83 |
INITIAL_SIZE 4194304 |
| 84 |
MAXIMUM_SIZE 4194304 |
| 85 |
ROW_FORMAT FIXED |
| 86 |
DROP TABLE t1; |
| 87 |
SELECT FILE_NAME, FREE_EXTENTS, TOTAL_EXTENTS |
| 88 |
FROM information_schema.files |
| 89 |
WHERE ENGINE='ndbcluster' AND FILE_TYPE='DATAFILE'; |
| 90 |
FILE_NAME ./datafile.dat |
| 91 |
FREE_EXTENTS 2 |
| 92 |
TOTAL_EXTENTS 2 |
| 93 |
FILE_NAME ./datafile2.dat |
| 94 |
FREE_EXTENTS 4 |
| 95 |
TOTAL_EXTENTS 4 |
| 96 |
ALTER TABLESPACE ts_1 |
| 97 |
DROP DATAFILE 'datafile.dat'; |
| 98 |
ALTER TABLESPACE ts_1 |
| 99 |
DROP DATAFILE 'datafile2.dat'; |
| 100 |
DROP TABLESPACE ts_1; |
| 101 |
DROP LOGFILE GROUP lg_1 |
| 102 |
ENGINE=NDB; |