Debian Codegraph @

mysql-test/suite/innodb_undo/r/i_s_files_32k.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=32k
7 # 2 implicit and 6 explicit undo tablespaces
8 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
9 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
10 CREATE UNDO TABLESPACE undo_005 ADD DATAFILE 'undo_005.ibu';
11 CREATE UNDO TABLESPACE undo_006 ADD DATAFILE 'undo_006.ibu';
12 CREATE UNDO TABLESPACE undo_007 ADD DATAFILE 'undo_007.ibu';
13 CREATE UNDO TABLESPACE undo_008 ADD DATAFILE 'undo_008.ibu';
14 SET default_storage_engine=InnoDB;
15 CREATE TABLE t1 (a serial, b text, c text);
16 ==I_S.FILES== ==I_S.FILES==
17 FILE_ID 0
18 TABLESPACE_NAME innodb_system
19 FILE_NAME MYSQLD_DATADIR/ibdata1
20 FILE_TYPE TABLESPACE
21 STATUS NORMAL
22 ENGINE InnoDB
23 EXTENT_SIZE 2097152
24 MAXIMUM_SIZE NULL
25 AUTOEXTEND_SIZE 67108864
26 ==I_S.FILES== ==I_S.FILES==
27 FILE_ID 4294967278
28 TABLESPACE_NAME innodb_undo_002
29 FILE_NAME MYSQLD_DATADIR/undo_002
30 FILE_TYPE UNDO LOG
31 STATUS NORMAL
32 ENGINE InnoDB
33 EXTENT_SIZE 2097152
34 MAXIMUM_SIZE NULL
35 ==I_S.FILES== ==I_S.FILES==
36 FILE_ID 4294967279
37 TABLESPACE_NAME innodb_undo_001
38 FILE_NAME MYSQLD_DATADIR/undo_001
39 FILE_TYPE UNDO LOG
40 STATUS NORMAL
41 ENGINE InnoDB
42 EXTENT_SIZE 2097152
43 MAXIMUM_SIZE NULL
44 ==I_S.FILES== ==I_S.FILES==
45 TABLESPACE_NAME innodb_temporary
46 FILE_NAME MYSQLD_DATADIR/ibtmp1
47 FILE_TYPE TEMPORARY
48 STATUS NORMAL
49 ENGINE InnoDB
50 EXTENT_SIZE 2097152
51 INITIAL_SIZE 12582912
52 MAXIMUM_SIZE NULL
53 AUTOEXTEND_SIZE 67108864
54 ==I_S.FILES== ==I_S.FILES==
55 TABLESPACE_NAME test/t1
56 FILE_NAME MYSQLD_DATADIR/test/t1.ibd
57 FILE_TYPE TABLESPACE
58 STATUS NORMAL
59 ENGINE InnoDB
60 DATA_FREE 0
61 FREE_EXTENTS 0
62 TOTAL_EXTENTS 0
63 EXTENT_SIZE 2097152
64 INITIAL_SIZE 229376
65 MAXIMUM_SIZE NULL
66 AUTOEXTEND_SIZE 2097152
67 #
68 # Populate t1 with about 3MB of data
69 #
70 CREATE PROCEDURE populate_t1()
71 BEGIN
72 DECLARE i INT DEFAULT 1;
73 while (i <= 6000) DO
74 INSERT INTO t1 (b,c) VALUES (repeat('b', 250), repeat('c', 250));
75 SET i = i + 1;
76 END WHILE;
77 END |
78 BEGIN;
79 CALL populate_t1();
80 FLUSH TABLE t1;
81 ==I_S.FILES== ==I_S.FILES==
82 TABLESPACE_NAME test/t1
83 FILE_NAME MYSQLD_DATADIR/test/t1.ibd
84 FILE_TYPE TABLESPACE
85 STATUS NORMAL
86 ENGINE InnoDB
87 DATA_FREE 8388608
88 FREE_EXTENTS 3
89 TOTAL_EXTENTS 10
90 EXTENT_SIZE 2097152
91 INITIAL_SIZE 229376
92 MAXIMUM_SIZE NULL
93 AUTOEXTEND_SIZE 2097152
94 #
95 # Populate t1 with another 3MB of data
96 #
97 CALL populate_t1();
98 FLUSH TABLE t1;
99 ==I_S.FILES== ==I_S.FILES==
100 TABLESPACE_NAME test/t1
101 FILE_NAME MYSQLD_DATADIR/test/t1.ibd
102 FILE_TYPE TABLESPACE
103 STATUS NORMAL
104 ENGINE InnoDB
105 DATA_FREE 8388608
106 FREE_EXTENTS 2
107 TOTAL_EXTENTS 11
108 EXTENT_SIZE 2097152
109 INITIAL_SIZE 229376
110 MAXIMUM_SIZE NULL
111 AUTOEXTEND_SIZE 2097152
112 #
113 # Delete the half of the records.
114 #
115 DELETE FROM t1 WHERE a % 2 = 1;
116 FLUSH TABLE t1;
117 ==I_S.FILES== ==I_S.FILES==
118 TABLESPACE_NAME test/t1
119 FILE_NAME MYSQLD_DATADIR/test/t1.ibd
120 FILE_TYPE TABLESPACE
121 STATUS NORMAL
122 ENGINE InnoDB
123 DATA_FREE 8388608
124 FREE_EXTENTS 2
125 TOTAL_EXTENTS 11
126 EXTENT_SIZE 2097152
127 INITIAL_SIZE 229376
128 MAXIMUM_SIZE NULL
129 AUTOEXTEND_SIZE 2097152
130 #
131 # Cleanup
132 #
133 DROP TABLE t1;
134 DROP PROCEDURE populate_t1;
135 # Set all explicit undo tablespaces to inacitve.
136 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
137 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
138 ALTER UNDO TABLESPACE undo_005 SET INACTIVE;
139 ALTER UNDO TABLESPACE undo_006 SET INACTIVE;
140 ALTER UNDO TABLESPACE undo_007 SET INACTIVE;
141 ALTER UNDO TABLESPACE undo_008 SET INACTIVE;
142 # Wait for all explicit undo tablespaces to become empty.
143 # Drop all explicit undo tablespaces.
144 DROP UNDO TABLESPACE undo_003;
145 DROP UNDO TABLESPACE undo_004;
146 DROP UNDO TABLESPACE undo_005;
147 DROP UNDO TABLESPACE undo_006;
148 DROP UNDO TABLESPACE undo_007;
149 DROP UNDO TABLESPACE undo_008;