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