Debian Codegraph @

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

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