1create table t1(a blob) engine=innodb key_block_size=8; 2create function generate_blob() 3returns varchar(20000) 4begin 5declare x varchar(20000) default ''; 6declare i int default 500; 7while i > 0 do 8set x = concat(sha1(i), x); 9set i = i - 1; 10end while; 11return x; 12end // 13insert into t1 select generate_blob(); 14truncate t1; 15insert into t1 select generate_blob(); 16drop table t1; 17drop function generate_blob; 18