Debian Codegraph @

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

raw
1 SET @orig = @@global.innodb_log_writer_threads;
2 SET GLOBAL innodb_log_writer_threads = OFF;
3 SELECT @@global.innodb_log_writer_threads;
4 @@global.innodb_log_writer_threads
5 0
6 SET GLOBAL innodb_log_writer_threads = default;
7 SELECT @@global.innodb_log_writer_threads;
8 @@global.innodb_log_writer_threads
9 1
10 SET GLOBAL innodb_log_writer_threads = ON;
11 SELECT @@global.innodb_log_writer_threads;
12 @@global.innodb_log_writer_threads
13 1
14 SET GLOBAL innodb_log_writer_threads = 2;
15 ERROR 42000: Variable 'innodb_log_writer_threads' can't be set to the value of '2'
16 SELECT @@global.innodb_log_writer_threads;
17 @@global.innodb_log_writer_threads
18 1
19 SET GLOBAL innodb_log_writer_threads = 1e2;
20 ERROR 42000: Incorrect argument type to variable 'innodb_log_writer_threads'
21 SELECT @@global.innodb_log_writer_threads;
22 @@global.innodb_log_writer_threads
23 1
24 SET GLOBAL innodb_log_writer_threads = 1.0;
25 ERROR 42000: Incorrect argument type to variable 'innodb_log_writer_threads'
26 SELECT @@global.innodb_log_writer_threads;
27 @@global.innodb_log_writer_threads
28 1
29 SET innodb_log_writer_threads = OFF;
30 ERROR HY000: Variable 'innodb_log_writer_threads' is a GLOBAL variable and should be set with SET GLOBAL
31 SELECT @@global.innodb_log_writer_threads;
32 @@global.innodb_log_writer_threads
33 1
34 SET GLOBAL innodb_log_writer_threads = @orig;