1
-- source include/have_innodb.inc
3
let $per_table=`select @@innodb_file_per_table`;
4
let $format=`select @@innodb_file_format`;
6
-- let $query_i_s = SELECT page_size FROM information_schema.innodb_cmpmem WHERE pages_used > 0
8
set global innodb_file_per_table=on;
9
set global innodb_file_format=`1`;
11
create table t1(a text) engine=innodb key_block_size=8;
15
# insert some rows so we are using compressed pages
19
insert into t1 values(repeat('abcdefghijklmnopqrstuvwxyz',100));
24
# we should be using some 8K pages
29
# because of lazy eviction at drop table in 5.5 there should be some
33
# create a non-compressed table and insert enough into it to evict
35
create table t2(a text) engine=innodb;
42
insert into t2 values(repeat('abcdefghijklmnopqrstuvwxyz',1000));
48
# now there should be no 8K pages in the buffer pool
54
# restore environment to the state it was before this test execution
58
eval set global innodb_file_format=$format;
59
eval set global innodb_file_per_table=$per_table;