Debian Codegraph @

mysql-test/suite/ndbcluster/information_schema_disk_data.result

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