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