Debian Codegraph @

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

raw
1 select @@global.performance_schema_show_processlist into @save;
2 select @@global.performance_schema_show_processlist;
3 @@global.performance_schema_show_processlist
4 0
5 select @@session.performance_schema_show_processlist;
6 ERROR HY000: Variable 'performance_schema_show_processlist' is a GLOBAL variable
7 show global variables like 'performance_schema_show_processlist';
8 Variable_name Value
9 performance_schema_show_processlist OFF
10 show session variables like 'performance_schema_show_processlist';
11 Variable_name Value
12 performance_schema_show_processlist OFF
13 select * from performance_schema.global_variables
14 where variable_name='performance_schema_show_processlist';
15 VARIABLE_NAME VARIABLE_VALUE
16 performance_schema_show_processlist OFF
17 select * from performance_schema.session_variables
18 where variable_name='performance_schema_show_processlist';
19 VARIABLE_NAME VARIABLE_VALUE
20 performance_schema_show_processlist OFF
21 set global performance_schema_show_processlist = 99;
22 ERROR 42000: Variable 'performance_schema_show_processlist' can't be set to the value of '99'
23 set global performance_schema_show_processlist = 'FOO';
24 ERROR 42000: Variable 'performance_schema_show_processlist' can't be set to the value of 'FOO'
25 set global performance_schema_show_processlist = 1;
26 Warnings:
27 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
28 select @@global.performance_schema_show_processlist;
29 @@global.performance_schema_show_processlist
30 1
31 set global performance_schema_show_processlist = 0;
32 Warnings:
33 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
34 select @@global.performance_schema_show_processlist;
35 @@global.performance_schema_show_processlist
36 0
37 set global performance_schema_show_processlist = ON;
38 Warnings:
39 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
40 select @@global.performance_schema_show_processlist;
41 @@global.performance_schema_show_processlist
42 1
43 set global performance_schema_show_processlist = OFF;
44 Warnings:
45 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
46 select @@global.performance_schema_show_processlist;
47 @@global.performance_schema_show_processlist
48 0
49 set global performance_schema_show_processlist = TRUE;
50 Warnings:
51 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
52 select @@global.performance_schema_show_processlist;
53 @@global.performance_schema_show_processlist
54 1
55 set global performance_schema_show_processlist = FALSE;
56 Warnings:
57 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.
58 select @@global.performance_schema_show_processlist;
59 @@global.performance_schema_show_processlist
60 0
61 set @@global.performance_schema_show_processlist = @save;
62 Warnings:
63 Warning 4166 '@@performance_schema_show_processlist' is deprecated and will be removed in a future release. When it is removed, SHOW PROCESSLIST will always use the performance schema implementation.