mirror of
https://github.com/MariaDB/server.git
synced 2025-08-08 11:22:35 +03:00
9b5d711ac3
- InnoDB reserves the free extents unnecessarily during blob page allocation even though btr_page_alloc() can handle reserving the extent when the existing ran out of pages to be used.
26 lines
762 B
Plaintext
26 lines
762 B
Plaintext
--- mysql-test/suite/innodb/r/check_ibd_filesize.result
|
|
+++ mysql-test/suite/innodb/r/check_ibd_filesize.reject
|
|
@@ -3,18 +3,12 @@
|
|
# SPACE IN 5.7 THAN IN 5.6
|
|
#
|
|
CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
|
|
-# bytes: 65536
|
|
+# bytes: 262144
|
|
INSERT INTO t1 SELECT * FROM seq_1_to_25000;
|
|
-# bytes: 9437184
|
|
+# bytes: 983040
|
|
DROP TABLE t1;
|
|
CREATE TABLE t1 (a INT PRIMARY KEY, b BLOB) ENGINE=InnoDB;
|
|
-# bytes: 65536
|
|
+# bytes: 262144
|
|
INSERT INTO t1 SELECT seq,REPEAT('a',30000) FROM seq_1_to_20;
|
|
-# bytes: 2097152
|
|
-DROP TABLE t1;
|
|
-CREATE TABLE t1 (a INT PRIMARY KEY, b BLOB)
|
|
-ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
|
|
-# bytes: 65536
|
|
-INSERT INTO t1 SELECT seq,REPEAT('a',30000) FROM seq_1_to_20;
|
|
-# bytes: 65536
|
|
+# bytes: 1572864
|
|
DROP TABLE t1;
|