Debian Codegraph @

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