Debian Codegraph @

mysql-test/suite/innodb_undo/r/i_s_files_16k.result

raw
1 #
2 # WL7943 Implement INFORMATION_SCHEMA.FILES
3 #
4 # Mysqld is initialized in this test with with:
5 # --innodb_rollback_segments=1
6 # --bootstrap --innodb_page_size=16k
7 # 2 implicit and 30 explicit undo tablespaces
8 CREATE UNDO TABLESPACE undo_3 ADD DATAFILE 'undo_3.ibu';
9 CREATE UNDO TABLESPACE undo_4 ADD DATAFILE 'undo_4.ibu';
10 CREATE UNDO TABLESPACE undo_5 ADD DATAFILE 'undo_5.ibu';
11 CREATE UNDO TABLESPACE undo_6 ADD DATAFILE 'undo_6.ibu';
12 CREATE UNDO TABLESPACE undo_7 ADD DATAFILE 'undo_7.ibu';
13 CREATE UNDO TABLESPACE undo_8 ADD DATAFILE 'undo_8.ibu';
14 CREATE UNDO TABLESPACE undo_9 ADD DATAFILE 'undo_9.ibu';
15 CREATE UNDO TABLESPACE undo_10 ADD DATAFILE 'undo_10.ibu';
16 CREATE UNDO TABLESPACE undo_11 ADD DATAFILE 'undo_11.ibu';
17 CREATE UNDO TABLESPACE undo_12 ADD DATAFILE 'undo_12.ibu';
18 CREATE UNDO TABLESPACE undo_13 ADD DATAFILE 'undo_13.ibu';
19 CREATE UNDO TABLESPACE undo_14 ADD DATAFILE 'undo_14.ibu';
20 CREATE UNDO TABLESPACE undo_15 ADD DATAFILE 'undo_15.ibu';
21 CREATE UNDO TABLESPACE undo_16 ADD DATAFILE 'undo_16.ibu';
22 CREATE UNDO TABLESPACE undo_17 ADD DATAFILE 'undo_17.ibu';
23 CREATE UNDO TABLESPACE undo_18 ADD DATAFILE 'undo_18.ibu';
24 CREATE UNDO TABLESPACE undo_19 ADD DATAFILE 'undo_19.ibu';
25 CREATE UNDO TABLESPACE undo_20 ADD DATAFILE 'undo_20.ibu';
26 CREATE UNDO TABLESPACE undo_21 ADD DATAFILE 'undo_21.ibu';
27 CREATE UNDO TABLESPACE undo_22 ADD DATAFILE 'undo_22.ibu';
28 CREATE UNDO TABLESPACE undo_23 ADD DATAFILE 'undo_23.ibu';
29 CREATE UNDO TABLESPACE undo_24 ADD DATAFILE 'undo_24.ibu';
30 CREATE UNDO TABLESPACE undo_25 ADD DATAFILE 'undo_25.ibu';
31 CREATE UNDO TABLESPACE undo_26 ADD DATAFILE 'undo_26.ibu';
32 CREATE UNDO TABLESPACE undo_27 ADD DATAFILE 'undo_27.ibu';
33 CREATE UNDO TABLESPACE undo_28 ADD DATAFILE 'undo_28.ibu';
34 CREATE UNDO TABLESPACE undo_29 ADD DATAFILE 'undo_29.ibu';
35 CREATE UNDO TABLESPACE undo_30 ADD DATAFILE 'undo_30.ibu';
36 CREATE UNDO TABLESPACE undo_31 ADD DATAFILE 'undo_31.ibu';
37 CREATE UNDO TABLESPACE undo_32 ADD DATAFILE 'undo_32.ibu';
38 SET default_storage_engine=InnoDB;
39 CREATE TABLE t1 (a serial, b text, c text);
40 ==I_S.FILES== ==I_S.FILES==
41 FILE_ID 0
42 TABLESPACE_NAME innodb_system
43 FILE_NAME MYSQLD_DATADIR/ibdata1
44 FILE_TYPE TABLESPACE
45 STATUS NORMAL
46 ENGINE InnoDB
47 EXTENT_SIZE 1048576
48 MAXIMUM_SIZE NULL
49 AUTOEXTEND_SIZE 67108864
50 ==I_S.FILES== ==I_S.FILES==
51 FILE_ID 4294967278
52 TABLESPACE_NAME innodb_undo_002
53 FILE_NAME MYSQLD_DATADIR/undo_002
54 FILE_TYPE UNDO LOG
55 STATUS NORMAL
56 ENGINE InnoDB
57 EXTENT_SIZE 1048576
58 MAXIMUM_SIZE NULL
59 ==I_S.FILES== ==I_S.FILES==
60 FILE_ID 4294967279
61 TABLESPACE_NAME innodb_undo_001
62 FILE_NAME MYSQLD_DATADIR/undo_001
63 FILE_TYPE UNDO LOG
64 STATUS NORMAL
65 ENGINE InnoDB
66 EXTENT_SIZE 1048576
67 MAXIMUM_SIZE NULL
68 ==I_S.FILES== ==I_S.FILES==
69 TABLESPACE_NAME innodb_temporary
70 FILE_NAME MYSQLD_DATADIR/ibtmp1
71 FILE_TYPE TEMPORARY
72 STATUS NORMAL
73 ENGINE InnoDB
74 EXTENT_SIZE 1048576
75 INITIAL_SIZE 12582912
76 MAXIMUM_SIZE NULL
77 AUTOEXTEND_SIZE 67108864
78 ==I_S.FILES== ==I_S.FILES==
79 TABLESPACE_NAME test/t1
80 FILE_NAME MYSQLD_DATADIR/test/t1.ibd
81 FILE_TYPE TABLESPACE
82 STATUS NORMAL
83 ENGINE InnoDB
84 DATA_FREE 0
85 FREE_EXTENTS 0
86 TOTAL_EXTENTS 0
87 EXTENT_SIZE 1048576
88 INITIAL_SIZE 114688
89 MAXIMUM_SIZE NULL
90 AUTOEXTEND_SIZE 1048576
91 #
92 # Populate t1 with about 3MB of data
93 #
94 CREATE PROCEDURE populate_t1()
95 BEGIN
96 DECLARE i INT DEFAULT 1;
97 while (i <= 6000) DO
98 INSERT INTO t1 (b,c) VALUES (repeat('b', 250), repeat('c', 250));
99 SET i = i + 1;
100 END WHILE;
101 END |
102 BEGIN;
103 CALL populate_t1();
104 FLUSH TABLE t1;
105 ==I_S.FILES== ==I_S.FILES==
106 TABLESPACE_NAME test/t1
107 FILE_NAME MYSQLD_DATADIR/test/t1.ibd
108 FILE_TYPE TABLESPACE
109 STATUS NORMAL
110 ENGINE InnoDB
111 DATA_FREE 4194304
112 FREE_EXTENTS 2
113 TOTAL_EXTENTS 11
114 EXTENT_SIZE 1048576
115 INITIAL_SIZE 114688
116 MAXIMUM_SIZE NULL
117 AUTOEXTEND_SIZE 1048576
118 #
119 # Populate t1 with another 3MB of data
120 #
121 CALL populate_t1();
122 FLUSH TABLE t1;
123 ==I_S.FILES== ==I_S.FILES==
124 TABLESPACE_NAME test/t1
125 FILE_NAME MYSQLD_DATADIR/test/t1.ibd
126 FILE_TYPE TABLESPACE
127 STATUS NORMAL
128 ENGINE InnoDB
129 DATA_FREE 4194304
130 FREE_EXTENTS 2
131 TOTAL_EXTENTS 15
132 EXTENT_SIZE 1048576
133 INITIAL_SIZE 114688
134 MAXIMUM_SIZE NULL
135 AUTOEXTEND_SIZE 1048576
136 #
137 # Delete the half of the records.
138 #
139 DELETE FROM t1 WHERE a % 2 = 1;
140 FLUSH TABLE t1;
141 ==I_S.FILES== ==I_S.FILES==
142 TABLESPACE_NAME test/t1
143 FILE_NAME MYSQLD_DATADIR/test/t1.ibd
144 FILE_TYPE TABLESPACE
145 STATUS NORMAL
146 ENGINE InnoDB
147 DATA_FREE 4194304
148 FREE_EXTENTS 2
149 TOTAL_EXTENTS 15
150 EXTENT_SIZE 1048576
151 INITIAL_SIZE 114688
152 MAXIMUM_SIZE NULL
153 AUTOEXTEND_SIZE 1048576
154 #
155 # Cleanup
156 #
157 DROP TABLE t1;
158 DROP PROCEDURE populate_t1;
159 # Set all explicit undo tablespaces to inacitve.
160 ALTER UNDO TABLESPACE undo_3 SET INACTIVE;
161 ALTER UNDO TABLESPACE undo_4 SET INACTIVE;
162 ALTER UNDO TABLESPACE undo_5 SET INACTIVE;
163 ALTER UNDO TABLESPACE undo_6 SET INACTIVE;
164 ALTER UNDO TABLESPACE undo_7 SET INACTIVE;
165 ALTER UNDO TABLESPACE undo_8 SET INACTIVE;
166 ALTER UNDO TABLESPACE undo_9 SET INACTIVE;
167 ALTER UNDO TABLESPACE undo_10 SET INACTIVE;
168 ALTER UNDO TABLESPACE undo_11 SET INACTIVE;
169 ALTER UNDO TABLESPACE undo_12 SET INACTIVE;
170 ALTER UNDO TABLESPACE undo_13 SET INACTIVE;
171 ALTER UNDO TABLESPACE undo_14 SET INACTIVE;
172 ALTER UNDO TABLESPACE undo_15 SET INACTIVE;
173 ALTER UNDO TABLESPACE undo_16 SET INACTIVE;
174 ALTER UNDO TABLESPACE undo_17 SET INACTIVE;
175 ALTER UNDO TABLESPACE undo_18 SET INACTIVE;
176 ALTER UNDO TABLESPACE undo_19 SET INACTIVE;
177 ALTER UNDO TABLESPACE undo_20 SET INACTIVE;
178 ALTER UNDO TABLESPACE undo_21 SET INACTIVE;
179 ALTER UNDO TABLESPACE undo_22 SET INACTIVE;
180 ALTER UNDO TABLESPACE undo_23 SET INACTIVE;
181 ALTER UNDO TABLESPACE undo_24 SET INACTIVE;
182 ALTER UNDO TABLESPACE undo_25 SET INACTIVE;
183 ALTER UNDO TABLESPACE undo_26 SET INACTIVE;
184 ALTER UNDO TABLESPACE undo_27 SET INACTIVE;
185 ALTER UNDO TABLESPACE undo_28 SET INACTIVE;
186 ALTER UNDO TABLESPACE undo_29 SET INACTIVE;
187 ALTER UNDO TABLESPACE undo_30 SET INACTIVE;
188 ALTER UNDO TABLESPACE undo_31 SET INACTIVE;
189 ALTER UNDO TABLESPACE undo_32 SET INACTIVE;
190 # Wait for all explicit undo tablespaces to become empty.
191 # Drop all explicit undo tablespaces.
192 DROP UNDO TABLESPACE undo_3;
193 DROP UNDO TABLESPACE undo_4;
194 DROP UNDO TABLESPACE undo_5;
195 DROP UNDO TABLESPACE undo_6;
196 DROP UNDO TABLESPACE undo_7;
197 DROP UNDO TABLESPACE undo_8;
198 DROP UNDO TABLESPACE undo_9;
199 DROP UNDO TABLESPACE undo_10;
200 DROP UNDO TABLESPACE undo_11;
201 DROP UNDO TABLESPACE undo_12;
202 DROP UNDO TABLESPACE undo_13;
203 DROP UNDO TABLESPACE undo_14;
204 DROP UNDO TABLESPACE undo_15;
205 DROP UNDO TABLESPACE undo_16;
206 DROP UNDO TABLESPACE undo_17;
207 DROP UNDO TABLESPACE undo_18;
208 DROP UNDO TABLESPACE undo_19;
209 DROP UNDO TABLESPACE undo_20;
210 DROP UNDO TABLESPACE undo_21;
211 DROP UNDO TABLESPACE undo_22;
212 DROP UNDO TABLESPACE undo_23;
213 DROP UNDO TABLESPACE undo_24;
214 DROP UNDO TABLESPACE undo_25;
215 DROP UNDO TABLESPACE undo_26;
216 DROP UNDO TABLESPACE undo_27;
217 DROP UNDO TABLESPACE undo_28;
218 DROP UNDO TABLESPACE undo_29;
219 DROP UNDO TABLESPACE undo_30;
220 DROP UNDO TABLESPACE undo_31;
221 DROP UNDO TABLESPACE undo_32;