1SELECT @@GLOBAL.innodb_adaptive_max_sleep_delay;
2@@GLOBAL.innodb_adaptive_max_sleep_delay
3150000
4150000 Expected
5SET @@GLOBAL.innodb_adaptive_max_sleep_delay=100;
6SET @@GLOBAL.innodb_adaptive_max_sleep_delay=0;
7SELECT @@GLOBAL.innodb_adaptive_max_sleep_delay;
8@@GLOBAL.innodb_adaptive_max_sleep_delay
90
10SET @@GLOBAL.innodb_adaptive_max_sleep_delay=100000;
11SELECT @@GLOBAL.innodb_adaptive_max_sleep_delay;
12@@GLOBAL.innodb_adaptive_max_sleep_delay
13100000
14SET @@GLOBAL.innodb_adaptive_max_sleep_delay=1000000;
15SELECT @@GLOBAL.innodb_adaptive_max_sleep_delay;
16@@GLOBAL.innodb_adaptive_max_sleep_delay
171000000
18SET @@GLOBAL.innodb_adaptive_max_sleep_delay=1000001;
19Warnings:
20Warning	1292	Truncated incorrect innodb_adaptive_max_sleep_delay value: '1000001'
21SELECT @@GLOBAL.innodb_adaptive_max_sleep_delay;
22@@GLOBAL.innodb_adaptive_max_sleep_delay
231000000
241000000 Expected
25SET @@GLOBAL.innodb_adaptive_max_sleep_delay=4294967295;
26Warnings:
27Warning	1292	Truncated incorrect innodb_adaptive_max_sleep_delay value: '4294967295'
28SELECT @@GLOBAL.innodb_adaptive_max_sleep_delay;
29@@GLOBAL.innodb_adaptive_max_sleep_delay
301000000
311000000 Expected
32SET @@GLOBAL.innodb_adaptive_max_sleep_delay=-1;
33Warnings:
34Warning	1292	Truncated incorrect innodb_adaptive_max_sleep_delay value: '-1'
35SELECT @@GLOBAL.innodb_adaptive_max_sleep_delay;
36@@GLOBAL.innodb_adaptive_max_sleep_delay
370
380 Expected
39SET @@GLOBAL.innodb_adaptive_max_sleep_delay=-1024;
40Warnings:
41Warning	1292	Truncated incorrect innodb_adaptive_max_sleep_delay value: '-1024'
42SELECT @@GLOBAL.innodb_adaptive_max_sleep_delay;
43@@GLOBAL.innodb_adaptive_max_sleep_delay
440
450 Expected
46SELECT COUNT(@@GLOBAL.innodb_adaptive_max_sleep_delay);
47COUNT(@@GLOBAL.innodb_adaptive_max_sleep_delay)
481
491 Expected
50SELECT VARIABLE_VALUE
51FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
52WHERE VARIABLE_NAME='innodb_adaptive_max_sleep_delay';
53VARIABLE_VALUE
540
55100 Expected
56SELECT @@innodb_adaptive_max_sleep_delay = @@GLOBAL.innodb_adaptive_max_sleep_delay;
57@@innodb_adaptive_max_sleep_delay = @@GLOBAL.innodb_adaptive_max_sleep_delay
581
591000000 Expected
60SELECT COUNT(@@innodb_adaptive_max_sleep_delay);
61COUNT(@@innodb_adaptive_max_sleep_delay)
621
631 Expected
64SELECT COUNT(@@local.innodb_adaptive_max_sleep_delay);
65ERROR HY000: Variable 'innodb_adaptive_max_sleep_delay' is a GLOBAL variable
66Expected error 'Variable is a GLOBAL variable'
67SELECT COUNT(@@SESSION.innodb_adaptive_max_sleep_delay);
68ERROR HY000: Variable 'innodb_adaptive_max_sleep_delay' is a GLOBAL variable
69Expected error 'Variable is a GLOBAL variable'
70SELECT innodb_adaptive_max_sleep_delay = @@SESSION.innodb_adaptive_max_sleep_delay;
71ERROR 42S22: Unknown column 'innodb_adaptive_max_sleep_delay' in 'field list'
72SET @@GLOBAL.innodb_adaptive_max_sleep_delay=150000;
73