Debian Codegraph @

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

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