Debian Codegraph @

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

raw
1 select @@global.performance_schema_max_program_instances;
2 @@global.performance_schema_max_program_instances
3 -1
4 select @@global.performance_schema_max_program_instances;
5 @@global.performance_schema_max_program_instances
6 -1
7 select @@session.performance_schema_max_program_instances;
8 ERROR HY000: Variable 'performance_schema_max_program_instances' is a GLOBAL variable
9 show global variables like 'performance_schema_max_program_instances';
10 Variable_name Value
11 performance_schema_max_program_instances -1
12 show session variables like 'performance_schema_max_program_instances';
13 Variable_name Value
14 performance_schema_max_program_instances -1
15 select * from performance_schema.global_variables
16 where variable_name='performance_schema_max_program_instances';
17 VARIABLE_NAME VARIABLE_VALUE
18 performance_schema_max_program_instances -1
19 select * from performance_schema.session_variables
20 where variable_name='performance_schema_max_program_instances';
21 VARIABLE_NAME VARIABLE_VALUE
22 performance_schema_max_program_instances -1
23 set global performance_schema_max_program_instances=1;
24 ERROR HY000: Variable 'performance_schema_max_program_instances' is a read only variable
25 set session performance_schema_max_program_instances=1;
26 ERROR HY000: Variable 'performance_schema_max_program_instances' is a read only variable
27 SELECT @@GLOBAL.performance_schema_max_program_instances = VARIABLE_VALUE
28 FROM performance_schema.global_variables
29 WHERE VARIABLE_NAME='performance_schema_max_program_instances';
30 @@GLOBAL.performance_schema_max_program_instances = VARIABLE_VALUE
31 1
32 select @@global.performance_schema_max_program_instances;
33 @@global.performance_schema_max_program_instances
34 -1
35 select * from performance_schema.global_variables
36 where variable_name='performance_schema_max_program_instances';
37 VARIABLE_NAME VARIABLE_VALUE
38 performance_schema_max_program_instances -1
39 SELECT @@performance_schema_max_program_instances = @@GLOBAL.performance_schema_max_program_instances;
40 @@performance_schema_max_program_instances = @@GLOBAL.performance_schema_max_program_instances
41 1