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