EiX3h3Cm

1use test;
2drop table if exists t1,t2;
3
4create table t1(a int not null primary key auto_increment, b char(200)) engine=innodb page_compressed=yes;
5create table t2(a int not null primary key auto_increment, b char(200)) engine=innodb;
6
7insert into t1(b) values ('testingcompressionaaaabbbbccccdddd');
8insert into t1(b) select b from t1;
9insert into t1(b) select b from t1;
10insert into t1(b) select b from t1;
11insert into t1(b) select b from t1;
12insert into t1(b) select b from t1;
13insert into t1(b) select b from t1;
14insert into t1(b) select b from t1;
15insert into t1(b) select b from t1;
16insert into t1(b) select b from t1;
17insert into t1(b) select b from t1;
18insert into t1(b) select b from t1;
19insert into t1(b) select b from t1;
20insert into t1(b) select b from t1;
21insert into t1(b) select b from t1;
22insert into t1(b) select b from t1;
23insert into t1(b) select b from t1;
24insert into t1(b) select b from t1;
25insert into t1(b) select b from t1;
26
27insert into t2 select * from t1;