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