Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_lru_scan_depth_basic.result

raw
1 SET @start_global_value = @@global.innodb_lru_scan_depth;
2 SELECT @start_global_value;
3 @start_global_value
4 1024
5 Valid value 100 or more
6 select @@global.innodb_lru_scan_depth >= 100;
7 @@global.innodb_lru_scan_depth >= 100
8 1
9 select @@global.innodb_lru_scan_depth;
10 @@global.innodb_lru_scan_depth
11 1024
12 select @@session.innodb_lru_scan_depth;
13 ERROR HY000: Variable 'innodb_lru_scan_depth' is a GLOBAL variable
14 show global variables like 'innodb_lru_scan_depth';
15 Variable_name Value
16 innodb_lru_scan_depth 1024
17 show session variables like 'innodb_lru_scan_depth';
18 Variable_name Value
19 innodb_lru_scan_depth 1024
20 select * from performance_schema.global_variables where variable_name='innodb_lru_scan_depth';
21 VARIABLE_NAME VARIABLE_VALUE
22 innodb_lru_scan_depth 1024
23 select * from performance_schema.session_variables where variable_name='innodb_lru_scan_depth';
24 VARIABLE_NAME VARIABLE_VALUE
25 innodb_lru_scan_depth 1024
26 set global innodb_lru_scan_depth=325;
27 select @@global.innodb_lru_scan_depth;
28 @@global.innodb_lru_scan_depth
29 325
30 select * from performance_schema.global_variables where variable_name='innodb_lru_scan_depth';
31 VARIABLE_NAME VARIABLE_VALUE
32 innodb_lru_scan_depth 325
33 select * from performance_schema.session_variables where variable_name='innodb_lru_scan_depth';
34 VARIABLE_NAME VARIABLE_VALUE
35 innodb_lru_scan_depth 325
36 set session innodb_lru_scan_depth=444;
37 ERROR HY000: Variable 'innodb_lru_scan_depth' is a GLOBAL variable and should be set with SET GLOBAL
38 set global innodb_lru_scan_depth=1.1;
39 ERROR 42000: Incorrect argument type to variable 'innodb_lru_scan_depth'
40 set global innodb_lru_scan_depth=1e1;
41 ERROR 42000: Incorrect argument type to variable 'innodb_lru_scan_depth'
42 set global innodb_lru_scan_depth="foo";
43 ERROR 42000: Incorrect argument type to variable 'innodb_lru_scan_depth'
44 set global innodb_lru_scan_depth=7;
45 Warnings:
46 Warning 1292 Truncated incorrect innodb_lru_scan_depth value: '7'
47 select @@global.innodb_lru_scan_depth;
48 @@global.innodb_lru_scan_depth
49 100
50 select * from performance_schema.global_variables where variable_name='innodb_lru_scan_depth';
51 VARIABLE_NAME VARIABLE_VALUE
52 innodb_lru_scan_depth 100
53 set global innodb_lru_scan_depth=-7;
54 Warnings:
55 Warning 1292 Truncated incorrect innodb_lru_scan_depth value: '-7'
56 select @@global.innodb_lru_scan_depth;
57 @@global.innodb_lru_scan_depth
58 100
59 select * from performance_schema.global_variables where variable_name='innodb_lru_scan_depth';
60 VARIABLE_NAME VARIABLE_VALUE
61 innodb_lru_scan_depth 100
62 set global innodb_lru_scan_depth=100;
63 select @@global.innodb_lru_scan_depth;
64 @@global.innodb_lru_scan_depth
65 100
66 SET @@global.innodb_lru_scan_depth = @start_global_value;
67 SELECT @@global.innodb_lru_scan_depth;
68 @@global.innodb_lru_scan_depth
69 1024