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