Debian Codegraph @

mysql-test/suite/innodb/t/open_file_lru.test

raw
1 #
2 # Check the file open/close LRU code
3 #
4
5 --source include/have_debug.inc
6 --source include/big_test.inc
7 --source include/have_innodb_max_16k.inc
8
9 SET default_storage_engine=InnoDB;
10
11 --disable_query_log
12
13 SET @open_files = (select @@innodb_open_files);
14
15 SET @total_tables = @open_files + 250;
16
17 --enable_query_log
18
19 SELECT @total_tables;
20
21 CREATE DATABASE lru_test;
22 USE lru_test;
23
24 SET GLOBAL innodb_file_per_table = on;
25
26 DELIMITER |;
27
28 CREATE PROCEDURE create_tables(IN max_tables INT)
29 BEGIN
30 DECLARE i INT UNSIGNED DEFAULT 0;
31
32 WHILE i < max_tables DO
33 SET @name = CONCAT("t_", i);
34 SET @sql = CONCAT('CREATE TABLE ', @name, '(c INT) ENGINE=InnoDB');
35 PREPARE create_table FROM @sql;
36 EXECUTE create_table;
37 DEALLOCATE PREPARE create_table;
38 SET i = i + 1;
39 END WHILE;
40 END|
41
42 CREATE PROCEDURE ins(IN max_tables INT)
43 BEGIN
44 DECLARE i INT UNSIGNED DEFAULT 0;
45
46 WHILE i < max_tables DO
47 SET @name = CONCAT("t_", i);
48 SET @sql = CONCAT('INSERT INTO ', @name, ' VALUES(0)');
49 PREPARE insert_value FROM @sql;
50 EXECUTE insert_value;
51 DEALLOCATE PREPARE insert_value;
52 SET i = i + 1;
53 END WHILE;
54 END|
55
56 CREATE PROCEDURE sel(IN max_tables INT)
57 BEGIN
58 DECLARE i INT UNSIGNED DEFAULT 0;
59
60 WHILE i < max_tables DO
61 SET @name = CONCAT("t_", i);
62 SET @sql = CONCAT('SELECT * FROM ', @name);
63 PREPARE select_from FROM @sql;
64 EXECUTE select_from ;
65 DEALLOCATE PREPARE select_from;
66 SET i = i + 1;
67 END WHILE;
68 END|
69
70 DELIMITER ;|
71
72 CALL create_tables(@total_tables);
73 CALL ins(@total_tables);
74 CALL sel(@total_tables);
75
76 DROP PROCEDURE create_tables;
77 DROP PROCEDURE ins;
78 DROP PROCEDURE sel;
79
80 DROP DATABASE lru_test;
81
82 --disable_query_log
83 call mtr.add_suppression("Too many .* files are open the maximum allowed value is .*");
84 --enable_query_log