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