Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.innodb_old_blocks_pct;
2 SELECT @start_global_value;
3 @start_global_value
4 37
5 Valid values are between 5 and 95
6 select @@global.innodb_old_blocks_pct between 5 and 95;
7 @@global.innodb_old_blocks_pct between 5 and 95
8 1
9 select @@global.innodb_old_blocks_pct;
10 @@global.innodb_old_blocks_pct
11 37
12 select @@session.innodb_old_blocks_pct;
13 ERROR HY000: Variable 'innodb_old_blocks_pct' is a GLOBAL variable
14 show global variables like 'innodb_old_blocks_pct';
15 Variable_name Value
16 innodb_old_blocks_pct 37
17 show session variables like 'innodb_old_blocks_pct';
18 Variable_name Value
19 innodb_old_blocks_pct 37
20 select * from performance_schema.global_variables where variable_name='innodb_old_blocks_pct';
21 VARIABLE_NAME VARIABLE_VALUE
22 innodb_old_blocks_pct 37
23 select * from performance_schema.session_variables where variable_name='innodb_old_blocks_pct';
24 VARIABLE_NAME VARIABLE_VALUE
25 innodb_old_blocks_pct 37
26 set global innodb_old_blocks_pct=10;
27 select @@global.innodb_old_blocks_pct;
28 @@global.innodb_old_blocks_pct
29 10
30 select * from performance_schema.global_variables where variable_name='innodb_old_blocks_pct';
31 VARIABLE_NAME VARIABLE_VALUE
32 innodb_old_blocks_pct 10
33 select * from performance_schema.session_variables where variable_name='innodb_old_blocks_pct';
34 VARIABLE_NAME VARIABLE_VALUE
35 innodb_old_blocks_pct 10
36 set session innodb_old_blocks_pct=1;
37 ERROR HY000: Variable 'innodb_old_blocks_pct' is a GLOBAL variable and should be set with SET GLOBAL
38 set @@global.innodb_old_blocks_pct=DEFAULT;
39 select @@global.innodb_old_blocks_pct;
40 @@global.innodb_old_blocks_pct
41 37
42 set global innodb_old_blocks_pct=1.1;
43 ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct'
44 set global innodb_old_blocks_pct=1e1;
45 ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct'
46 set global innodb_old_blocks_pct="foo";
47 ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct'
48 set global innodb_old_blocks_pct=" ";
49 ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct'
50 set global innodb_old_blocks_pct='';
51 ERROR 42000: Incorrect argument type to variable 'innodb_old_blocks_pct'
52 set global innodb_old_blocks_pct=4;
53 Warnings:
54 Warning 1292 Truncated incorrect innodb_old_blocks_pct value: '4'
55 select @@global.innodb_old_blocks_pct;
56 @@global.innodb_old_blocks_pct
57 5
58 select * from performance_schema.global_variables where variable_name='innodb_old_blocks_pct';
59 VARIABLE_NAME VARIABLE_VALUE
60 innodb_old_blocks_pct 5
61 set global innodb_old_blocks_pct=-7;
62 Warnings:
63 Warning 1292 Truncated incorrect innodb_old_blocks_pct value: '-7'
64 select @@global.innodb_old_blocks_pct;
65 @@global.innodb_old_blocks_pct
66 5
67 select * from performance_schema.global_variables where variable_name='innodb_old_blocks_pct';
68 VARIABLE_NAME VARIABLE_VALUE
69 innodb_old_blocks_pct 5
70 set global innodb_old_blocks_pct=96;
71 Warnings:
72 Warning 1292 Truncated incorrect innodb_old_blocks_pct value: '96'
73 select @@global.innodb_old_blocks_pct;
74 @@global.innodb_old_blocks_pct
75 95
76 select * from performance_schema.global_variables where variable_name='innodb_old_blocks_pct';
77 VARIABLE_NAME VARIABLE_VALUE
78 innodb_old_blocks_pct 95
79 set global innodb_old_blocks_pct=5;
80 select @@global.innodb_old_blocks_pct;
81 @@global.innodb_old_blocks_pct
82 5
83 set global innodb_old_blocks_pct=95;
84 select @@global.innodb_old_blocks_pct;
85 @@global.innodb_old_blocks_pct
86 95
87 SET @@global.innodb_old_blocks_pct = @start_global_value;
88 SELECT @@global.innodb_old_blocks_pct;
89 @@global.innodb_old_blocks_pct
90 37