Debian Codegraph @

mysql-test/suite/innodb_undo/include/i_s_files.inc

raw
1 SET default_storage_engine=InnoDB;
2 LET MYSQLD_DATADIR = `select @@datadir`;
3
4 CREATE TABLE t1 (a serial, b text, c text);
5
6 --disable_query_log
7 --vertical_results
8 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/
9 SELECT "==I_S.FILES==", FILE_ID, TABLESPACE_NAME, FILE_NAME, FILE_TYPE, STATUS,
10 ENGINE, EXTENT_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE
11 FROM information_schema.files WHERE file_id = 0
12 ORDER BY FILE_ID;
13
14 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/
15 SELECT "==I_S.FILES==", FILE_ID, TABLESPACE_NAME, FILE_NAME, FILE_TYPE, STATUS,
16 ENGINE, EXTENT_SIZE, MAXIMUM_SIZE
17 FROM information_schema.files WHERE tablespace_name RLIKE 'innodb_undo_00[1-2]'
18 ORDER BY FILE_ID;
19
20 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/
21 SELECT "==I_S.FILES==", TABLESPACE_NAME, FILE_NAME, FILE_TYPE, STATUS,
22 ENGINE, EXTENT_SIZE, INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE
23 FROM information_schema.files WHERE file_name LIKE '%ibtmp1%';
24
25 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/
26 SELECT "==I_S.FILES==", TABLESPACE_NAME, FILE_NAME, FILE_TYPE, STATUS, ENGINE,
27 DATA_FREE, FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE,
28 INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE
29 FROM information_schema.files WHERE file_name LIKE '%t1%';
30 --enable_query_log
31
32 --echo #
33 --echo # Populate t1 with about 3MB of data
34 --echo #
35 delimiter |;
36 CREATE PROCEDURE populate_t1()
37 BEGIN
38 DECLARE i INT DEFAULT 1;
39 while (i <= 6000) DO
40 INSERT INTO t1 (b,c) VALUES (repeat('b', 250), repeat('c', 250));
41 SET i = i + 1;
42 END WHILE;
43 END |
44 delimiter ;|
45
46 BEGIN;
47 CALL populate_t1();
48 FLUSH TABLE t1;
49
50 --disable_query_log
51 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/
52 SELECT "==I_S.FILES==", TABLESPACE_NAME, FILE_NAME, FILE_TYPE, STATUS, ENGINE, DATA_FREE,
53 FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE,
54 INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE
55 FROM information_schema.files WHERE file_name LIKE '%t1%';
56 --enable_query_log
57
58 --echo #
59 --echo # Populate t1 with another 3MB of data
60 --echo #
61 CALL populate_t1();
62 FLUSH TABLE t1;
63 --disable_query_log
64 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/
65 SELECT "==I_S.FILES==", TABLESPACE_NAME, FILE_NAME, FILE_TYPE, STATUS, ENGINE, DATA_FREE,
66 FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE,
67 INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE
68 FROM information_schema.files WHERE file_name LIKE '%t1%';
69 --enable_query_log
70
71 --echo #
72 --echo # Delete the half of the records.
73 --echo #
74 DELETE FROM t1 WHERE a % 2 = 1;
75 FLUSH TABLE t1;
76
77 --disable_query_log
78 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/
79 SELECT "==I_S.FILES==", TABLESPACE_NAME, FILE_NAME, FILE_TYPE, STATUS, ENGINE, DATA_FREE,
80 FREE_EXTENTS, TOTAL_EXTENTS, EXTENT_SIZE,
81 INITIAL_SIZE, MAXIMUM_SIZE, AUTOEXTEND_SIZE
82 FROM information_schema.files WHERE file_name LIKE '%t1%';
83 --enable_query_log
84
85 --echo #
86 --echo # Cleanup
87 --echo #
88 DROP TABLE t1;
89 DROP PROCEDURE populate_t1;