Debian Codegraph @

mysql-test/suite/ndbcluster/information_schema_disk_data.test

raw
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;