Debian Codegraph @

mysql-test/suite/innodb/r/innodb-trim.result

raw
1 set global innodb_compression_algorithm = 1;
2 create table innodb_page_compressed (c1 int not null primary key auto_increment, b char(200), c char(200), d char(200)) engine=innodb page_compressed=1 page_compression_level=9;
3 show warnings;
4 Level Code Message
5 create procedure innodb_insert_proc (repeat_count int)
6 begin
7 declare current_num int;
8 set current_num = 0;
9 while current_num < repeat_count do
10 insert into innodb_page_compressed values (NULL,repeat('A',150),repeat('AB',75),repeat('B', 175));
11 set current_num = current_num + 1;
12 end while;
13 end//
14 commit;
15 set autocommit=0;
16 call innodb_insert_proc(16000);
17 commit;
18 set autocommit=1;
19 DROP PROCEDURE innodb_insert_proc;
20 DROP TABLE innodb_page_compressed;