1--source include/not_embedded.inc 2--source include/have_perfschema.inc 3 4# 5# Only global 6# 7 8select @@global.performance_schema_max_rwlock_classes; 9 10--error ER_INCORRECT_GLOBAL_LOCAL_VAR 11select @@session.performance_schema_max_rwlock_classes; 12 13show global variables like 'performance_schema_max_rwlock_classes'; 14 15show session variables like 'performance_schema_max_rwlock_classes'; 16 17select * from information_schema.global_variables 18 where variable_name='performance_schema_max_rwlock_classes'; 19 20select * from information_schema.session_variables 21 where variable_name='performance_schema_max_rwlock_classes'; 22 23# 24# Read-only 25# 26 27--error ER_INCORRECT_GLOBAL_LOCAL_VAR 28set global performance_schema_max_rwlock_classes=1; 29 30--error ER_INCORRECT_GLOBAL_LOCAL_VAR 31set session performance_schema_max_rwlock_classes=1; 32 33