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_nodebug.inc
6 --source include/big_test.inc
7
8 --disable_query_log
9 # These values can change during the test
10 let $innodb_file_per_table_orig = `SELECT @@innodb_file_per_table`;
11
12 # Create a 20MB blob that does not compress easily.
13 # 1000 Random characters is enough to keep compression low.
14 set @alphabet="abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ";
15 set @r=abs(rand()*52) + 1;
16 set @blob=substr(@alphabet,@r,1);
17 let $1=1000;
18 while ($1 > 1)
19 {
20 set @r=abs(rand()*52) + 1;
21 set @letter=substr(@alphabet,@r,1);
22 set @blob=concat(@blob,@letter);
23 dec $1;
24 }
25 # The loop above is extremely slow compared to repeat().
26 set @longblob=repeat(@blob,200000);
27 --enable_query_log
28
29 call mtr.add_suppression("Warning: a long semaphore wait");
30
31 SET GLOBAL innodb_file_per_table = OFF;
32
33 --echo #
34 --echo # System tablespace, Row Format = Redundant
35 --echo #
36 CREATE TABLE t1 (
37 c1 INT DEFAULT NULL,
38 c2 LONGBLOB NOT NULL,
39 KEY k2 (c2(250), c1)
40 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
41 INSERT INTO t1 VALUES (1, '');
42 UPDATE t1 SET c2=@longblob;
43 DROP TABLE t1;
44
45 --echo #
46 --echo # System tablespace, Row Format = Compact
47 --echo #
48 CREATE TABLE t1 (
49 c1 INT DEFAULT NULL,
50 c2 LONGBLOB NOT NULL,
51 KEY k2 (c2(250), c1)
52 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
53 INSERT INTO t1 VALUES (1, '');
54 UPDATE t1 SET c2=@longblob;
55 DROP TABLE t1;
56
57 SET GLOBAL innodb_file_per_table = ON;
58
59 --echo #
60 --echo # Separate tablespace, Row Format = Redundant
61 --echo #
62 CREATE TABLE t1 (
63 c1 INT DEFAULT NULL,
64 c2 LONGBLOB NOT NULL,
65 KEY k2 (c2(250), c1)
66 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
67 INSERT INTO t1 VALUES (1, '');
68 UPDATE t1 SET c2=@longblob;
69 DROP TABLE t1;
70
71 --echo #
72 --echo # Separate tablespace, Row Format = Compact
73 --echo #
74 CREATE TABLE t1 (
75 c1 INT DEFAULT NULL,
76 c2 LONGBLOB NOT NULL,
77 KEY k2 (c2(250), c1)
78 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
79 INSERT INTO t1 VALUES (1, '');
80 UPDATE t1 SET c2=@longblob;
81 DROP TABLE t1;
82
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 DROP TABLE t1;
106
107 --echo #
108 --echo # Separate tablespace, Row Format = Dynamic
109 --echo #
110 CREATE TABLE t1 (
111 c1 INT DEFAULT NULL,
112 c2 LONGBLOB NOT NULL,
113 KEY k2 (c2(250), c1)
114 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
115 INSERT INTO t1 VALUES (1, '');
116 UPDATE t1 SET c2=@longblob;
117 DROP TABLE t1;
118
119 --disable_query_log
120 EVAL SET GLOBAL innodb_file_per_table = $innodb_file_per_table_orig;
121 --enable_query_log