Debian Codegraph @

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

raw
1 SELECT COUNT(@@GLOBAL.innodb_purge_threads);
2 COUNT(@@GLOBAL.innodb_purge_threads)
3 1
4 1 Expected
5 SELECT COUNT(@@innodb_purge_threads);
6 COUNT(@@innodb_purge_threads)
7 1
8 1 Expected
9 SET @@GLOBAL.innodb_purge_threads=1;
10 ERROR HY000: Variable 'innodb_purge_threads' is a read only variable
11 Expected error 'Read-only variable'
12 SELECT innodb_purge_threads;
13 ERROR 42S22: Unknown column 'innodb_purge_threads' in 'field list'
14 Expected error 'Unknown column'
15 SELECT @@SESSION.innodb_purge_threads;
16 ERROR HY000: Variable 'innodb_purge_threads' is a GLOBAL variable
17 SELECT @@GLOBAL.innodb_purge_threads = VARIABLE_VALUE
18 FROM performance_schema.global_variables
19 WHERE VARIABLE_NAME='innodb_purge_threads';
20 @@GLOBAL.innodb_purge_threads = VARIABLE_VALUE
21 1
22 1 Expected
23 SELECT COUNT(VARIABLE_VALUE)
24 FROM performance_schema.global_variables
25 WHERE VARIABLE_NAME='innodb_purge_threads';
26 COUNT(VARIABLE_VALUE)
27 1
28 1 Expected
29 SELECT @@innodb_purge_threads = @@GLOBAL.innodb_purge_threads;
30 @@innodb_purge_threads = @@GLOBAL.innodb_purge_threads
31 1
32 1 Expected
33 SELECT COUNT(@@local.innodb_purge_threads);
34 ERROR HY000: Variable 'innodb_purge_threads' is a GLOBAL variable
35 Expected error 'Variable is a GLOBAL variable'
36 SELECT COUNT(@@SESSION.innodb_purge_threads);
37 ERROR HY000: Variable 'innodb_purge_threads' is a GLOBAL variable
38 Expected error 'Variable is a GLOBAL variable'
39 SELECT VARIABLE_NAME, VARIABLE_VALUE
40 FROM performance_schema.global_variables
41 WHERE VARIABLE_NAME = 'innodb_purge_threads';
42 VARIABLE_NAME VARIABLE_VALUE
43 innodb_purge_threads 4