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