Debian Codegraph @

mysql-test/suite/innodb/r/innodb_set_open_files_limit.result

raw
1 CREATE UNDO TABLESPACE undo_009 ADD DATAFILE 'undo_009.ibu';
2 CREATE UNDO TABLESPACE undo_008 ADD DATAFILE 'undo_008.ibu';
3 CREATE UNDO TABLESPACE undo_007 ADD DATAFILE 'undo_007.ibu';
4 CREATE UNDO TABLESPACE undo_006 ADD DATAFILE 'undo_006.ibu';
5 CREATE UNDO TABLESPACE undo_005 ADD DATAFILE 'undo_005.ibu';
6 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'undo_004.ibu';
7 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
8 CREATE UNDO TABLESPACE undo_002 ADD DATAFILE 'undo_002.ibu';
9 CREATE UNDO TABLESPACE undo_001 ADD DATAFILE 'undo_001.ibu';
10 CREATE UNDO TABLESPACE undo_000 ADD DATAFILE 'undo_000.ibu';
11 SET @start_global_value = @@GLOBAL.innodb_open_files;
12 SELECT @start_global_value;
13 @start_global_value
14 4000
15 SELECT innodb_set_open_files_limit(1.1);
16 ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid first argument type.
17 SELECT innodb_set_open_files_limit(1e1);
18 ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid first argument type.
19 SELECT innodb_set_open_files_limit('AUTO');
20 ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid first argument type.
21 SELECT innodb_set_open_files_limit();
22 ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid number of arguments.
23 SELECT innodb_set_open_files_limit(1, 2);
24 ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid number of arguments.
25 SELECT innodb_set_open_files_limit(1, 2, 3, 4);
26 ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; Invalid number of arguments.
27 SELECT innodb_set_open_files_limit(NULL);
28 ERROR HY000: Can't initialize function 'innodb_set_open_files_limit'; First argument must not be null.
29 select @@global.innodb_open_files;
30 @@global.innodb_open_files
31 4000
32 SELECT innodb_set_open_files_limit(-3);
33 ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be smaller than 10.
34 SELECT innodb_set_open_files_limit(1);
35 ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be smaller than 10.
36 SELECT innodb_set_open_files_limit(3);
37 ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be smaller than 10.
38 SELECT innodb_set_open_files_limit(9);
39 ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be smaller than 10.
40 SELECT innodb_set_open_files_limit(2147483648);
41 ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be larger than 2147483647.
42 SELECT innodb_set_open_files_limit(12342147483647);
43 ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. New limit value can't be larger than 2147483647.
44 SELECT innodb_set_open_files_limit(10);
45 ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. Cannot update innodb_open_files to this value. Not enough files could be closed in last 5 seconds or a number of files that cannot be closed would exceed 90% of the new limit. Consider setting it above 15.
46 SELECT innodb_set_open_files_limit(14);
47 ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. Cannot update innodb_open_files to this value. Not enough files could be closed in last 5 seconds or a number of files that cannot be closed would exceed 90% of the new limit. Consider setting it above 15.
48 SELECT innodb_set_open_files_limit(15);
49 innodb_set_open_files_limit(15)
50 15
51 SELECT innodb_set_open_files_limit(14);
52 ERROR HY000: Incorrect arguments to innodb_set_open_files_limit. Cannot update innodb_open_files to this value. Not enough files could be closed in last 5 seconds or a number of files that cannot be closed would exceed 90% of the new limit. Consider setting it above 15.
53 SELECT innodb_set_open_files_limit(2147483647);
54 innodb_set_open_files_limit(2147483647)
55 2147483647
56 SELECT innodb_set_open_files_limit(4000);
57 innodb_set_open_files_limit(4000)
58 4000
59 SELECT innodb_set_open_files_limit(150);
60 innodb_set_open_files_limit(150)
61 150
62 ALTER UNDO TABLESPACE undo_009 SET INACTIVE;
63 ALTER UNDO TABLESPACE undo_008 SET INACTIVE;
64 ALTER UNDO TABLESPACE undo_007 SET INACTIVE;
65 ALTER UNDO TABLESPACE undo_006 SET INACTIVE;
66 ALTER UNDO TABLESPACE undo_005 SET INACTIVE;
67 ALTER UNDO TABLESPACE undo_004 SET INACTIVE;
68 ALTER UNDO TABLESPACE undo_003 SET INACTIVE;
69 ALTER UNDO TABLESPACE undo_002 SET INACTIVE;
70 ALTER UNDO TABLESPACE undo_001 SET INACTIVE;
71 ALTER UNDO TABLESPACE undo_000 SET INACTIVE;
72 DROP UNDO TABLESPACE undo_009;
73 DROP UNDO TABLESPACE undo_008;
74 DROP UNDO TABLESPACE undo_007;
75 DROP UNDO TABLESPACE undo_006;
76 DROP UNDO TABLESPACE undo_005;
77 DROP UNDO TABLESPACE undo_004;
78 DROP UNDO TABLESPACE undo_003;
79 DROP UNDO TABLESPACE undo_002;
80 DROP UNDO TABLESPACE undo_001;
81 DROP UNDO TABLESPACE undo_000;
82 SELECT innodb_set_open_files_limit(@start_global_value);
83 innodb_set_open_files_limit(@start_global_value)
84 4000
85 SELECT @@GLOBAL.innodb_open_files;
86 @@GLOBAL.innodb_open_files
87 4000