Debian Codegraph @

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

raw
1 SET @global_start_value = @@global.innodb_thread_concurrency;
2 SELECT @global_start_value;
3 @global_start_value
4 0
5 SET @default_innodb_thread_sleep_delay = @@global.innodb_thread_sleep_delay;
6 '#--------------------FN_DYNVARS_046_01------------------------#'
7 SET @@global.innodb_thread_concurrency = 0;
8 SET @@global.innodb_thread_concurrency = DEFAULT;
9 SELECT @@global.innodb_thread_concurrency;
10 @@global.innodb_thread_concurrency
11 0
12 '#---------------------FN_DYNVARS_046_02-------------------------#'
13 SET innodb_thread_concurrency = 1;
14 ERROR HY000: Variable 'innodb_thread_concurrency' is a GLOBAL variable and should be set with SET GLOBAL
15 SELECT @@innodb_thread_concurrency;
16 @@innodb_thread_concurrency
17 0
18 SELECT local.innodb_thread_concurrency;
19 ERROR 42S02: Unknown table 'local' in field list
20 SET global innodb_thread_concurrency = 0;
21 SELECT @@global.innodb_thread_concurrency;
22 @@global.innodb_thread_concurrency
23 0
24 '#--------------------FN_DYNVARS_046_03------------------------#'
25 SET @@global.innodb_thread_concurrency = 0;
26 SELECT @@global.innodb_thread_concurrency;
27 @@global.innodb_thread_concurrency
28 0
29 SET @@global.innodb_thread_concurrency = 1;
30 SELECT @@global.innodb_thread_concurrency;
31 @@global.innodb_thread_concurrency
32 1
33 SET @@global.innodb_thread_concurrency = 1000;
34 Warnings:
35 Warning 1210 Current innodb_thread_concurrency is too big for safety of redo log files. Consider decreasing it or increasing innodb_redo_log_capacity.
36 SELECT @@global.innodb_thread_concurrency;
37 @@global.innodb_thread_concurrency
38 1000
39 '#--------------------FN_DYNVARS_046_04-------------------------#'
40 SET @@global.innodb_thread_concurrency = -1;
41 Warnings:
42 Warning 1292 Truncated incorrect innodb_thread_concurrency value: '-1'
43 SELECT @@global.innodb_thread_concurrency;
44 @@global.innodb_thread_concurrency
45 0
46 SET @@global.innodb_thread_concurrency = "T";
47 ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
48 SELECT @@global.innodb_thread_concurrency;
49 @@global.innodb_thread_concurrency
50 0
51 SET @@global.innodb_thread_concurrency = "Y";
52 ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
53 SELECT @@global.innodb_thread_concurrency;
54 @@global.innodb_thread_concurrency
55 0
56 SET @@global.innodb_thread_concurrency = ' ';
57 ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
58 SELECT @@global.innodb_thread_concurrency;
59 @@global.innodb_thread_concurrency
60 0
61 SET @@global.innodb_thread_concurrency = " ";
62 ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
63 SELECT @@global.innodb_thread_concurrency;
64 @@global.innodb_thread_concurrency
65 0
66 SET @@global.innodb_thread_concurrency = 1001;
67 Warnings:
68 Warning 1292 Truncated incorrect innodb_thread_concurrency value: '1001'
69 Warning 1210 Current innodb_thread_concurrency is too big for safety of redo log files. Consider decreasing it or increasing innodb_redo_log_capacity.
70 SELECT @@global.innodb_thread_concurrency;
71 @@global.innodb_thread_concurrency
72 1000
73 SET @@global.innodb_thread_concurrency = 255.01;
74 ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
75 SELECT @@global.innodb_thread_concurrency;
76 @@global.innodb_thread_concurrency
77 1000
78 '#----------------------FN_DYNVARS_046_05------------------------#'
79 SELECT @@global.innodb_thread_concurrency =
80 VARIABLE_VALUE FROM performance_schema.global_variables
81 WHERE VARIABLE_NAME='innodb_thread_concurrency';
82 @@global.innodb_thread_concurrency =
83 VARIABLE_VALUE
84 1
85 SELECT @@global.innodb_thread_concurrency;
86 @@global.innodb_thread_concurrency
87 1000
88 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
89 WHERE VARIABLE_NAME='innodb_thread_concurrency';
90 VARIABLE_VALUE
91 1000
92 '#---------------------FN_DYNVARS_046_06-------------------------#'
93 SET @@global.innodb_thread_concurrency = OFF;
94 ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
95 SELECT @@global.innodb_thread_concurrency;
96 @@global.innodb_thread_concurrency
97 1000
98 SET @@global.innodb_thread_concurrency = ON;
99 ERROR 42000: Incorrect argument type to variable 'innodb_thread_concurrency'
100 SELECT @@global.innodb_thread_concurrency;
101 @@global.innodb_thread_concurrency
102 1000
103 '#---------------------FN_DYNVARS_046_07----------------------#'
104 SET @@global.innodb_thread_concurrency = TRUE;
105 SELECT @@global.innodb_thread_concurrency;
106 @@global.innodb_thread_concurrency
107 1
108 SET @@global.innodb_thread_concurrency = FALSE;
109 SELECT @@global.innodb_thread_concurrency;
110 @@global.innodb_thread_concurrency
111 0
112 SET @@global.innodb_thread_concurrency = @global_start_value;
113 SELECT @@global.innodb_thread_concurrency;
114 @@global.innodb_thread_concurrency
115 0
116 SET @@global.innodb_thread_sleep_delay = @default_innodb_thread_sleep_delay;