1set global innodb_compression_algorithm = snappy; 2create table innodb_normal (c1 int not null auto_increment primary key, b char(200)) engine=innodb; 3create table innodb_page_compressed1 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=1; 4create table innodb_page_compressed2 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=2; 5create table innodb_page_compressed3 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=3; 6create table innodb_page_compressed4 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=4; 7create table innodb_page_compressed5 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=5; 8create table innodb_page_compressed6 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=6; 9create table innodb_page_compressed7 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=7; 10create table innodb_page_compressed8 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=8; 11create table innodb_page_compressed9 (c1 int not null auto_increment primary key, b char(200)) engine=innodb page_compressed=1 page_compression_level=9; 12select count(*) from innodb_page_compressed1; 13count(*) 1410000 15select count(*) from innodb_page_compressed3; 16count(*) 1710000 18select count(*) from innodb_page_compressed4; 19count(*) 2010000 21select count(*) from innodb_page_compressed5; 22count(*) 2310000 24select count(*) from innodb_page_compressed6; 25count(*) 2610000 27select count(*) from innodb_page_compressed6; 28count(*) 2910000 30select count(*) from innodb_page_compressed7; 31count(*) 3210000 33select count(*) from innodb_page_compressed8; 34count(*) 3510000 36select count(*) from innodb_page_compressed9; 37count(*) 3810000 39# innodb_normal expected FOUND 40FOUND 24084 /AaAaAaAa/ in innodb_normal.ibd 41# innodb_page_compressed1 page compressed expected NOT FOUND 42NOT FOUND /AaAaAaAa/ in innodb_page_compressed1.ibd 43# innodb_page_compressed2 page compressed expected NOT FOUND 44NOT FOUND /AaAaAaAa/ in innodb_page_compressed2.ibd 45# innodb_page_compressed3 page compressed expected NOT FOUND 46NOT FOUND /AaAaAaAa/ in innodb_page_compressed3.ibd 47# innodb_page_compressed4 page compressed expected NOT FOUND 48NOT FOUND /AaAaAaAa/ in innodb_page_compressed4.ibd 49# innodb_page_compressed5 page compressed expected NOT FOUND 50NOT FOUND /AaAaAaAa/ in innodb_page_compressed5.ibd 51# innodb_page_compressed6 page compressed expected NOT FOUND 52NOT FOUND /AaAaAaAa/ in innodb_page_compressed6.ibd 53# innodb_page_compressed7 page compressed expected NOT FOUND 54NOT FOUND /AaAaAaAa/ in innodb_page_compressed7.ibd 55# innodb_page_compressed8 page compressed expected NOT FOUND 56NOT FOUND /AaAaAaAa/ in innodb_page_compressed8.ibd 57# innodb_page_compressed9 page compressed expected NOT FOUND 58NOT FOUND /AaAaAaAa/ in innodb_page_compressed9.ibd 59# restart 60select count(*) from innodb_page_compressed1; 61count(*) 6210000 63select count(*) from innodb_page_compressed3; 64count(*) 6510000 66select count(*) from innodb_page_compressed4; 67count(*) 6810000 69select count(*) from innodb_page_compressed5; 70count(*) 7110000 72select count(*) from innodb_page_compressed6; 73count(*) 7410000 75select count(*) from innodb_page_compressed6; 76count(*) 7710000 78select count(*) from innodb_page_compressed7; 79count(*) 8010000 81select count(*) from innodb_page_compressed8; 82count(*) 8310000 84select count(*) from innodb_page_compressed9; 85count(*) 8610000 87drop table innodb_normal; 88drop table innodb_page_compressed1; 89drop table innodb_page_compressed2; 90drop table innodb_page_compressed3; 91drop table innodb_page_compressed4; 92drop table innodb_page_compressed5; 93drop table innodb_page_compressed6; 94drop table innodb_page_compressed7; 95drop table innodb_page_compressed8; 96drop table innodb_page_compressed9; 97#done 98