Debian Codegraph @

mysql-test/suite/innodb/r/check_ibd_filesize.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 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
6 # bytes: 65536
7 INSERT INTO t1 SELECT * FROM seq_1_to_25000;
8 # bytes: 9437184
9 DROP TABLE t1;
10 CREATE TABLE t1 (a INT PRIMARY KEY, b BLOB) ENGINE=InnoDB;
11 # bytes: 65536
12 INSERT INTO t1 SELECT seq,REPEAT('a',30000) FROM seq_1_to_20;
13 # bytes: 2097152
14 DROP TABLE t1;
15 CREATE TABLE t1 (a INT PRIMARY KEY, b BLOB)
16 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
17 # bytes: 65536
18 INSERT INTO t1 SELECT seq,REPEAT('a',30000) FROM seq_1_to_20;
19 # bytes: 65536
20 DROP TABLE t1;