Debian Codegraph @

mysql-test/suite/innodb_zip/t/large_blob.test

raw
1 --echo #
2 --echo # This tests the use of large blobs in InnoDB.
3 --echo #
4
5 --source include/have_innodb.inc
6 --source include/not_debug.inc
7 --source include/big_test.inc
8
9 --disable_query_log
10 # Create a 20MB blob that does not compress easily.
11 # 1000 Random characters is enough to keep compression low.
12 set @alphabet="abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
13 set @r=abs(rand()*52) + 1;
14 set @blob=substr(@alphabet,@r,1);
15 let $1=1000;
16 while ($1 > 1)
17 {
18 set @r=abs(rand()*52) + 1;
19 set @letter=substr(@alphabet,@r,1);
20 set @blob=concat(@blob,@letter);
21 dec $1;
22 }
23 # The loop above is extremely slow compared to repeat().
24 set @longblob=repeat(@blob,200000);
25 --enable_query_log
26
27 SET GLOBAL innodb_file_per_table = OFF;
28
29 --echo #
30 --echo # System tablespace, Row Format = Redundant
31 --echo #
32 CREATE TABLE t1 (
33 c1 INT DEFAULT NULL,
34 c2 LONGBLOB NOT NULL,
35 KEY k2 (c2(250), c1)
36 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
37 INSERT INTO t1 VALUES (1, '');
38 UPDATE t1 SET c2=@longblob;
39 DROP TABLE t1;
40
41 --echo #
42 --echo # System tablespace, Row Format = Compact
43 --echo #
44 CREATE TABLE t1 (
45 c1 INT DEFAULT NULL,
46 c2 LONGBLOB NOT NULL,
47 KEY k2 (c2(250), c1)
48 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
49 INSERT INTO t1 VALUES (1, '');
50 UPDATE t1 SET c2=@longblob;
51 DROP TABLE t1;
52
53 SET GLOBAL innodb_file_per_table = ON;
54
55 --echo #
56 --echo # Separate tablespace, Row Format = Redundant
57 --echo #
58 CREATE TABLE t1 (
59 c1 INT DEFAULT NULL,
60 c2 LONGBLOB NOT NULL,
61 KEY k2 (c2(250), c1)
62 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
63 INSERT INTO t1 VALUES (1, '');
64 UPDATE t1 SET c2=@longblob;
65 DROP TABLE t1;
66
67 --echo #
68 --echo # Separate tablespace, Row Format = Compact
69 --echo #
70 CREATE TABLE t1 (
71 c1 INT DEFAULT NULL,
72 c2 LONGBLOB NOT NULL,
73 KEY k2 (c2(250), c1)
74 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
75 INSERT INTO t1 VALUES (1, '');
76 UPDATE t1 SET c2=@longblob;
77 DROP TABLE t1;
78
79 --disable_query_log
80 SET @save_innodb_read_only_compressed=@@GLOBAL.innodb_read_only_compressed;
81 SET GLOBAL innodb_read_only_compressed=OFF;
82 --enable_query_log
83 --echo #
84 --echo # Separate tablespace, Row Format = Compressed, Key Block Size = 2k
85 --echo #
86 CREATE TABLE t1 (
87 c1 INT DEFAULT NULL,
88 c2 LONGBLOB NOT NULL,
89 KEY k2 (c2(250), c1)
90 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=2;
91 INSERT INTO t1 VALUES (1, '');
92 UPDATE t1 SET c2=@longblob;
93 DROP TABLE t1;
94
95 --echo #
96 --echo # Separate tablespace, Row Format = Compressed, Key Block Size = 1k
97 --echo #
98 CREATE TABLE t1 (
99 c1 INT DEFAULT NULL,
100 c2 LONGBLOB NOT NULL,
101 KEY k2 (c2(250), c1)
102 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=1;
103 INSERT INTO t1 VALUES (1, '');
104 UPDATE t1 SET c2=@longblob;
105 --disable_query_log
106 SET GLOBAL innodb_read_only_compressed=@save_innodb_read_only_compressed;
107 --enable_query_log
108 DROP TABLE t1;
109
110 --echo #
111 --echo # Separate tablespace, Row Format = Dynamic
112 --echo #
113 CREATE TABLE t1 (
114 c1 INT DEFAULT NULL,
115 c2 LONGBLOB NOT NULL,
116 KEY k2 (c2(250), c1)
117 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
118 INSERT INTO t1 VALUES (1, '');
119 UPDATE t1 SET c2=@longblob;
120 DROP TABLE t1;