1# 2# Check that the paremeter is correctly set by start-up 3# option (.opt file sets it to 256 while default is 1024). 4select @@global.metadata_locks_cache_size = 256; 5@@global.metadata_locks_cache_size = 256 61 7# 8# Check that variable is read only 9# 10set @@global.metadata_locks_cache_size= 1024; 11ERROR HY000: Variable 'metadata_locks_cache_size' is a read only variable 12select @@global.metadata_locks_cache_size = 256; 13@@global.metadata_locks_cache_size = 256 141 15# 16# And only GLOBAL 17# 18select @@session.metadata_locks_cache_size; 19ERROR HY000: Variable 'metadata_locks_cache_size' is a GLOBAL variable 20set @@session.metadata_locks_cache_size= 1024; 21ERROR HY000: Variable 'metadata_locks_cache_size' is a read only variable 22