Debian Codegraph @

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

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