Debian Codegraph @

mysql-test/suite/innodb/r/check_ibd_filesize_16k.result

raw
1 #
2 # Bug #21950389 SMALL TABLESPACES WITH BLOBS TAKE UP TO 80 TIMES MORE
3 # SPACE IN 5.7 THAN IN 5.6
4 #
5 SET GLOBAL innodb_file_per_table=ON;
6 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
7 Empty table:
8 The size of file 'test/t1.ibd' is 114688 bytes.
9 Rows inserted: 5000
10 The size of file 'test/t1.ibd' is 229376 bytes.
11 Rows inserted: 10000
12 The size of file 'test/t1.ibd' is 360448 bytes.
13 Rows inserted: 15000
14 The size of file 'test/t1.ibd' is 475136 bytes.
15 Rows inserted: 20000
16 The size of file 'test/t1.ibd' is 606208 bytes.
17 Rows inserted: 25000
18 The size of file 'test/t1.ibd' is 9437184 bytes.
19 DROP TABLE t1;
20 CREATE TABLE t2 (a INT PRIMARY KEY, b BLOB) ENGINE=InnoDB;
21 Empty table:
22 The size of file 'test/t2.ibd' is 114688 bytes.
23 Rows inserted: 4
24 The size of file 'test/t2.ibd' is 229376 bytes.
25 Rows inserted: 8
26 The size of file 'test/t2.ibd' is 360448 bytes.
27 Rows inserted: 12
28 The size of file 'test/t2.ibd' is 491520 bytes.
29 Rows inserted: 16
30 The size of file 'test/t2.ibd' is 622592 bytes.
31 Rows inserted: 20
32 The size of file 'test/t2.ibd' is 4194304 bytes.
33 DROP TABLE t2;
34 CREATE TABLE t3 (a INT PRIMARY KEY, b BLOB)
35 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
36 Empty table:
37 The size of file 'test/t3.ibd' is 7168 bytes.
38 Rows inserted: 8
39 The size of file 'test/t3.ibd' is 15360 bytes.
40 Rows inserted: 16
41 The size of file 'test/t3.ibd' is 23552 bytes.
42 Rows inserted: 24
43 The size of file 'test/t3.ibd' is 31744 bytes.
44 Rows inserted: 32
45 The size of file 'test/t3.ibd' is 5242880 bytes.
46 Rows inserted: 40
47 The size of file 'test/t3.ibd' is 5242880 bytes.
48 DROP TABLE t3;
49 SET GLOBAL innodb_file_per_table=default;