Debian Codegraph @

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

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