Debian Codegraph @

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

raw
1 SELECT COUNT(@@GLOBAL.innodb_log_spin_cpu_abs_lwm);
2 COUNT(@@GLOBAL.innodb_log_spin_cpu_abs_lwm)
3 1
4 1 Expected
5 SET @@GLOBAL.innodb_log_spin_cpu_abs_lwm=-1;
6 Warnings:
7 Warning 1292 Truncated incorrect innodb_log_spin_cpu_abs_lwm value: '-1'
8 SELECT @@innodb_log_spin_cpu_abs_lwm;
9 @@innodb_log_spin_cpu_abs_lwm
10 0
11 SET @@GLOBAL.innodb_log_spin_cpu_abs_lwm=1;
12 SELECT @@innodb_log_spin_cpu_abs_lwm;
13 @@innodb_log_spin_cpu_abs_lwm
14 1
15 SET @@GLOBAL.innodb_log_spin_cpu_abs_lwm=101;
16 SELECT @@innodb_log_spin_cpu_abs_lwm;
17 @@innodb_log_spin_cpu_abs_lwm
18 101
19 SELECT COUNT(@@GLOBAL.innodb_log_spin_cpu_abs_lwm);
20 COUNT(@@GLOBAL.innodb_log_spin_cpu_abs_lwm)
21 1
22 1 Expected
23 SELECT @@GLOBAL.innodb_log_spin_cpu_abs_lwm = VARIABLE_VALUE
24 FROM performance_schema.global_variables
25 WHERE VARIABLE_NAME='innodb_log_spin_cpu_abs_lwm';
26 @@GLOBAL.innodb_log_spin_cpu_abs_lwm = VARIABLE_VALUE
27 1
28 1 Expected
29 SELECT COUNT(@@GLOBAL.innodb_log_spin_cpu_abs_lwm);
30 COUNT(@@GLOBAL.innodb_log_spin_cpu_abs_lwm)
31 1
32 1 Expected
33 SELECT COUNT(VARIABLE_VALUE)
34 FROM performance_schema.global_variables
35 WHERE VARIABLE_NAME='innodb_log_spin_cpu_abs_lwm';
36 COUNT(VARIABLE_VALUE)
37 1
38 1 Expected
39 SELECT @@innodb_log_spin_cpu_abs_lwm = @@GLOBAL.innodb_log_spin_cpu_abs_lwm;
40 @@innodb_log_spin_cpu_abs_lwm = @@GLOBAL.innodb_log_spin_cpu_abs_lwm
41 1
42 1 Expected
43 SELECT COUNT(@@innodb_log_spin_cpu_abs_lwm);
44 COUNT(@@innodb_log_spin_cpu_abs_lwm)
45 1
46 1 Expected
47 SELECT COUNT(@@local.innodb_log_spin_cpu_abs_lwm);
48 ERROR HY000: Variable 'innodb_log_spin_cpu_abs_lwm' is a GLOBAL variable
49 Expected error 'Variable is a GLOBAL variable'
50 SELECT COUNT(@@SESSION.innodb_log_spin_cpu_abs_lwm);
51 ERROR HY000: Variable 'innodb_log_spin_cpu_abs_lwm' is a GLOBAL variable
52 Expected error 'Variable is a GLOBAL variable'
53 SELECT COUNT(@@GLOBAL.innodb_log_spin_cpu_abs_lwm);
54 COUNT(@@GLOBAL.innodb_log_spin_cpu_abs_lwm)
55 1
56 1 Expected
57 SELECT innodb_log_spin_cpu_abs_lwm;
58 ERROR 42S22: Unknown column 'innodb_log_spin_cpu_abs_lwm' in 'field list'
59 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 200;
60 SELECT @@innodb_log_spin_cpu_abs_lwm;
61 @@innodb_log_spin_cpu_abs_lwm
62 200
63 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 100;
64 SELECT @@innodb_log_spin_cpu_abs_lwm;
65 @@innodb_log_spin_cpu_abs_lwm
66 100
67 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 0;
68 SELECT @@innodb_log_spin_cpu_abs_lwm;
69 @@innodb_log_spin_cpu_abs_lwm
70 0
71 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 80;
72 SELECT @@innodb_log_spin_cpu_abs_lwm;
73 @@innodb_log_spin_cpu_abs_lwm
74 80
75 SET GLOBAL innodb_log_spin_cpu_abs_lwm = 70;
76 SELECT @@innodb_log_spin_cpu_abs_lwm;
77 @@innodb_log_spin_cpu_abs_lwm
78 70
79 SET @@GLOBAL.innodb_log_spin_cpu_abs_lwm=80;
80 SELECT @@innodb_log_spin_cpu_abs_lwm;
81 @@innodb_log_spin_cpu_abs_lwm
82 80