blob: 2899ec2e749391e1a3af1dc1116d5ef9737fc219 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
# do a lot of longblob insertions up to 32MB-4 in size with a random key
--source include/big_test.inc
SET DEFAULT_STORAGE_ENGINE='tokudb';
--disable_warnings
drop table if exists t;
--enable_warnings
create table t (id int not null primary key, v longblob not null);
select @@max_allowed_packet into @my_max_allowed_packet;
--disable_warnings
set global max_allowed_packet=100000000;
--enable_warnings
connect(conn1,localhost,root,,);
let $nrows=1000;
let $maxid=$nrows;
let $maxblob=32*1024*1024;
while ($nrows) {
eval insert ignore into t (id,v) values (floor(rand()*$maxid),repeat('a',($maxblob-4)*rand()));
dec $nrows;
}
connection default;
disconnect conn1;
set global max_allowed_packet=@my_max_allowed_packet;
check table t;
optimize table t;
check table t;
drop table t;
|