Edit File: host_cache_size_basic.test
--source include/not_embedded.inc # # Only global # select @@global.host_cache_size; --error ER_INCORRECT_GLOBAL_LOCAL_VAR select @@session.host_cache_size; show global variables like 'host_cache_size'; show session variables like 'host_cache_size'; select * from information_schema.global_variables where variable_name='host_cache_size'; select * from information_schema.session_variables where variable_name='host_cache_size'; # # Read-Write # set global host_cache_size=1; select @@global.host_cache_size; set global host_cache_size=12; select @@global.host_cache_size; set global host_cache_size=0; select @@global.host_cache_size; --error ER_GLOBAL_VARIABLE set session host_cache_size=1; # Restore default set global host_cache_size=123; select @@global.host_cache_size;