12 lines
402 B
Plaintext
12 lines
402 B
Plaintext
set global innodb_compression_level = 0;
|
|
create table t1 (f1 int primary key, f2 longblob)
|
|
row_format=compressed, engine=innodb;
|
|
set debug='+d,innodb_zlob_print';
|
|
insert into t1 values (1, repeat('+', 1048576));
|
|
set debug='-d,innodb_zlob_print';
|
|
select f1, right(f2, 40) from t1;
|
|
f1 right(f2, 40)
|
|
1 ++++++++++++++++++++++++++++++++++++++++
|
|
drop table t1;
|
|
set global innodb_compression_level = default;
|