select @@global.performance_schema_max_program_instances; @@global.performance_schema_max_program_instances -1 select @@global.performance_schema_max_program_instances; @@global.performance_schema_max_program_instances -1 select @@session.performance_schema_max_program_instances; ERROR HY000: Variable 'performance_schema_max_program_instances' is a GLOBAL variable show global variables like 'performance_schema_max_program_instances'; Variable_name Value performance_schema_max_program_instances -1 show session variables like 'performance_schema_max_program_instances'; Variable_name Value performance_schema_max_program_instances -1 select * from performance_schema.global_variables where variable_name='performance_schema_max_program_instances'; VARIABLE_NAME VARIABLE_VALUE performance_schema_max_program_instances -1 select * from performance_schema.session_variables where variable_name='performance_schema_max_program_instances'; VARIABLE_NAME VARIABLE_VALUE performance_schema_max_program_instances -1 set global performance_schema_max_program_instances=1; ERROR HY000: Variable 'performance_schema_max_program_instances' is a read only variable set session performance_schema_max_program_instances=1; ERROR HY000: Variable 'performance_schema_max_program_instances' is a read only variable SELECT @@GLOBAL.performance_schema_max_program_instances = VARIABLE_VALUE FROM performance_schema.global_variables WHERE VARIABLE_NAME='performance_schema_max_program_instances'; @@GLOBAL.performance_schema_max_program_instances = VARIABLE_VALUE 1 select @@global.performance_schema_max_program_instances; @@global.performance_schema_max_program_instances -1 select * from performance_schema.global_variables where variable_name='performance_schema_max_program_instances'; VARIABLE_NAME VARIABLE_VALUE performance_schema_max_program_instances -1 SELECT @@performance_schema_max_program_instances = @@GLOBAL.performance_schema_max_program_instances; @@performance_schema_max_program_instances = @@GLOBAL.performance_schema_max_program_instances 1