1#
2# Bug#32831765 SERVER HITS OOM CONDITION WHEN LOADING TWO
3# INNODB TABLES WITH FTS INDEXES
4#
5create table t1 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
6`col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
7text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
8`col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
9text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
10`col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
11text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
12(`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
13(`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
14(`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
15(`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
16(`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
17(`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
18(`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
19(`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
20(`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
21(`col29`), FULLTEXT KEY (`col30`)) engine=innodb;
22create table t2 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
23`col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
24text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
25`col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
26text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
27`col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
28text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
29(`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
30(`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
31(`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
32(`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
33(`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
34(`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
35(`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
36(`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
37(`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
38(`col29`), FULLTEXT KEY (`col30`)) engine=innodb;
39create table t3 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
40`col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
41text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
42`col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
43text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
44`col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
45text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
46(`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
47(`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
48(`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
49(`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
50(`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
51(`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
52(`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
53(`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
54(`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
55(`col29`), FULLTEXT KEY (`col30`)) engine=innodb;
56create table t4 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
57`col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
58text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
59`col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
60text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
61`col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
62text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
63(`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
64(`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
65(`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
66(`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
67(`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
68(`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
69(`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
70(`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
71(`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
72(`col29`), FULLTEXT KEY (`col30`)) engine=innodb;
73#create procedure to inset into the table.
74CREATE  PROCEDURE `proc_insert`(IN tab_name VARCHAR(40))
75BEGIN
76DECLARE i INT DEFAULT 1;
77SET @insert_tbl =CONCAT('INSERT INTO ', tab_name, '( `col01`, `col02`,
78	`col03`, `col04`, `col05`, `col06`, `col07`, `col08`, `col09`, `col10`,
79	`col11`, `col12`, `col13`, `col14`, `col15`, `col16`, `col17`, `col18`,
80	`col19`, `col20`, `col21`, `col22`, `col23`, `col24`, `col25`, `col26`,
81	`col27`, `col28`, `col29`, `col30`)
82	VALUES ( MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
83	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
84	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
85	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
86	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
87	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
88	MD5(RAND()))');
89PREPARE ins_stmt FROM @insert_tbl;
90while (i <= 2000) DO
91EXECUTE ins_stmt;
92SET i = i + 1;
93END WHILE;
94DEALLOCATE PREPARE ins_stmt;
95END |
96SET @save_dbug= @@GLOBAL.debug_dbug;
97SET GLOBAL debug_dbug="+d,fts_optimize_wq_count_check";
98connect  con1,localhost,root,,;
99call proc_insert('t1');
100connect  con2,localhost,root,,;
101call proc_insert('t1');
102connect  con3,localhost,root,,;
103call proc_insert('t2');
104connect  con4,localhost,root,,;
105call proc_insert('t2');
106connect  con5,localhost,root,,;
107call proc_insert('t3');
108connect  con6,localhost,root,,;
109call proc_insert('t3');
110connect  con7,localhost,root,,;
111call proc_insert('t4');
112connection default;
113call proc_insert('t4');
114SET GLOBAL debug_dbug= @save_dbug;
115connection con1;
116disconnect con1;
117connection con2;
118disconnect con2;
119connection con3;
120disconnect con3;
121connection con4;
122disconnect con4;
123connection con5;
124disconnect con5;
125connection con6;
126disconnect con6;
127connection con7;
128disconnect con7;
129connection default;
130DROP TABLE t1,t2,t3,t4;
131DROP PROCEDURE proc_insert;
132