Debian Codegraph @

mysql-test/suite/innodb/t/check_ibd_filesize_16k.test

raw
1 --echo #
2 --echo # Bug #21950389 SMALL TABLESPACES WITH BLOBS TAKE UP TO 80 TIMES MORE
3 --echo # SPACE IN 5.7 THAN IN 5.6
4 --echo #
5
6 let MYSQLD_DATADIR=`SELECT @@datadir`;
7
8 SET GLOBAL innodb_file_per_table=ON;
9
10 #
11 # Table 1: small rows
12 #
13 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
14
15 let FILE_TO_CHECK=test/t1.ibd;
16 echo Empty table:;
17 --source include/show_file_size.inc
18
19 let $i = 0;
20
21 --disable_query_log
22 BEGIN;
23 while ($i < 25000) {
24 eval INSERT INTO t1 VALUES($i);
25 inc $i;
26 let $print= `SELECT $i MOD 5000`;
27 if ($print == 0) {
28 COMMIT;
29 echo Rows inserted: $i;
30 source include/show_file_size.inc;
31 BEGIN;
32 }
33 }
34 COMMIT;
35 --enable_query_log
36
37 DROP TABLE t1;
38
39 #
40 # Table 2: BLOB
41 #
42 CREATE TABLE t2 (a INT PRIMARY KEY, b BLOB) ENGINE=InnoDB;
43
44 let FILE_TO_CHECK=test/t2.ibd;
45 echo Empty table:;
46 --source include/show_file_size.inc
47
48 let $i = 0;
49
50 --disable_query_log
51 BEGIN;
52 while ($i < 20) {
53 eval INSERT INTO t2 VALUES($i, REPEAT('a', 30000));
54 inc $i;
55 let $print= `SELECT $i MOD 4`;
56 if ($print == 0) {
57 COMMIT;
58 echo Rows inserted: $i;
59 source include/show_file_size.inc;
60 BEGIN;
61 }
62 }
63 COMMIT;
64 --enable_query_log
65
66 DROP TABLE t2;
67
68 #
69 # Table 3: compressed BLOB
70 #
71 CREATE TABLE t3 (a INT PRIMARY KEY, b BLOB)
72 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
73
74 let FILE_TO_CHECK=test/t3.ibd;
75 echo Empty table:;
76 --source include/show_file_size.inc
77
78 let $i = 0;
79
80 --disable_query_log
81 BEGIN;
82 while ($i < 40) {
83 eval INSERT INTO t3 VALUES($i, REPEAT('a', 30000));
84 inc $i;
85 let $print= `SELECT $i MOD 8`;
86 if ($print == 0) {
87 COMMIT;
88 echo Rows inserted: $i;
89 source include/show_file_size.inc;
90 BEGIN;
91 }
92 }
93 COMMIT;
94 --enable_query_log
95
96 DROP TABLE t3;
97
98 SET GLOBAL innodb_file_per_table=default;