Debian Codegraph @

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

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