| 1 |
SET GLOBAL innodb_compression_level = 0; |
| 2 |
CREATE TABLE t1 (id INT PRIMARY KEY NOT NULL, val LONGTEXT) |
| 3 |
ENGINE=InnoDB ROW_FORMAT=compressed; |
| 4 |
BEGIN; |
| 5 |
INSERT INTO t1 VALUES (1, repeat('a',6000000)); |
| 6 |
ROLLBACK; |
| 7 |
DROP TABLE t1; |
| 8 |
SET GLOBAL innodb_compression_level = default; |