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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
|
#
# Check the file open/close LRU code
#
--source include/have_debug.inc
--source include/big_test.inc
--source include/have_innodb_max_16k.inc
SET default_storage_engine=InnoDB;
--disable_query_log
SET @open_files = (select @@innodb_open_files);
SET @total_tables = @open_files + 250;
--enable_query_log
SELECT @total_tables;
CREATE DATABASE lru_test;
USE lru_test;
SET GLOBAL innodb_file_per_table = on;
DELIMITER |;
CREATE PROCEDURE create_tables(IN max_tables INT)
BEGIN
DECLARE i INT UNSIGNED DEFAULT 0;
WHILE i < max_tables DO
SET @name = CONCAT("t_", i);
SET @sql = CONCAT('CREATE TABLE ', @name, '(c INT) ENGINE=InnoDB');
PREPARE create_table FROM @sql;
EXECUTE create_table;
DEALLOCATE PREPARE create_table;
SET i = i + 1;
END WHILE;
END|
CREATE PROCEDURE ins(IN max_tables INT)
BEGIN
DECLARE i INT UNSIGNED DEFAULT 0;
WHILE i < max_tables DO
SET @name = CONCAT("t_", i);
SET @sql = CONCAT('INSERT INTO ', @name, ' VALUES(0)');
PREPARE insert_value FROM @sql;
EXECUTE insert_value;
DEALLOCATE PREPARE insert_value;
SET i = i + 1;
END WHILE;
END|
CREATE PROCEDURE sel(IN max_tables INT)
BEGIN
DECLARE i INT UNSIGNED DEFAULT 0;
WHILE i < max_tables DO
SET @name = CONCAT("t_", i);
SET @sql = CONCAT('SELECT * FROM ', @name);
PREPARE select_from FROM @sql;
EXECUTE select_from ;
DEALLOCATE PREPARE select_from;
SET i = i + 1;
END WHILE;
END|
DELIMITER ;|
CALL create_tables(@total_tables);
CALL ins(@total_tables);
CALL sel(@total_tables);
DROP PROCEDURE create_tables;
DROP PROCEDURE ins;
DROP PROCEDURE sel;
DROP DATABASE lru_test;
--disable_query_log
call mtr.add_suppression("Too many .* files are open the maximum allowed value is .*");
--enable_query_log
|
