Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_lru_scan_depth_basic.test

raw
1
2
3 # 2011-02-23 - Added
4 #
5
6
7 SET @start_global_value = @@global.innodb_lru_scan_depth;
8 SELECT @start_global_value;
9
10 #
11 # exists as global only
12 #
13 --echo Valid value 100 or more
14 select @@global.innodb_lru_scan_depth >= 100;
15 select @@global.innodb_lru_scan_depth;
16 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
17 select @@session.innodb_lru_scan_depth;
18 show global variables like 'innodb_lru_scan_depth';
19 show session variables like 'innodb_lru_scan_depth';
20 --disable_warnings
21 select * from performance_schema.global_variables where variable_name='innodb_lru_scan_depth';
22 select * from performance_schema.session_variables where variable_name='innodb_lru_scan_depth';
23 --enable_warnings
24
25 #
26 # show that it's writable
27 #
28 set global innodb_lru_scan_depth=325;
29 select @@global.innodb_lru_scan_depth;
30 --disable_warnings
31 select * from performance_schema.global_variables where variable_name='innodb_lru_scan_depth';
32 select * from performance_schema.session_variables where variable_name='innodb_lru_scan_depth';
33 --enable_warnings
34 --error ER_GLOBAL_VARIABLE
35 set session innodb_lru_scan_depth=444;
36
37 #
38 # incorrect types
39 #
40 --error ER_WRONG_TYPE_FOR_VAR
41 set global innodb_lru_scan_depth=1.1;
42 --error ER_WRONG_TYPE_FOR_VAR
43 set global innodb_lru_scan_depth=1e1;
44 --error ER_WRONG_TYPE_FOR_VAR
45 set global innodb_lru_scan_depth="foo";
46
47 set global innodb_lru_scan_depth=7;
48 select @@global.innodb_lru_scan_depth;
49 --disable_warnings
50 select * from performance_schema.global_variables where variable_name='innodb_lru_scan_depth';
51 --enable_warnings
52 set global innodb_lru_scan_depth=-7;
53 select @@global.innodb_lru_scan_depth;
54 --disable_warnings
55 select * from performance_schema.global_variables where variable_name='innodb_lru_scan_depth';
56 --enable_warnings
57
58 #
59 # min/max values
60 #
61 set global innodb_lru_scan_depth=100;
62 select @@global.innodb_lru_scan_depth;
63
64 SET @@global.innodb_lru_scan_depth = @start_global_value;
65 SELECT @@global.innodb_lru_scan_depth;