Debian Codegraph @

mysql-test/suite/sys_vars/t/host_cache_size_basic.test

raw
1
2 #
3 # Only global
4 #
5
6 select @@global.host_cache_size;
7
8 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
9 select @@session.host_cache_size;
10
11 show global variables like 'host_cache_size';
12
13 show session variables like 'host_cache_size';
14
15 --disable_warnings
16 select * from performance_schema.global_variables
17 where variable_name='host_cache_size';
18
19 select * from performance_schema.session_variables
20 where variable_name='host_cache_size';
21 --enable_warnings
22
23 #
24 # Read-Write
25 #
26
27 set global host_cache_size=1;
28 select @@global.host_cache_size;
29
30 set global host_cache_size=12;
31 select @@global.host_cache_size;
32
33 set global host_cache_size=0;
34 select @@global.host_cache_size;
35
36 set global host_cache_size=65536;
37 select @@global.host_cache_size;
38
39 --error ER_GLOBAL_VARIABLE
40 set session host_cache_size=1;
41
42 #Invalid values
43 set global host_cache_size=-1;
44 select @@global.host_cache_size;
45
46 set global host_cache_size=-1024;
47 select @@global.host_cache_size;
48
49 set global host_cache_size=65537;
50 select @@global.host_cache_size;
51
52 set global host_cache_size=100000;
53 select @@global.host_cache_size;
54
55 set global host_cache_size=4294967295;
56 select @@global.host_cache_size;
57
58 # Restore default
59 set global host_cache_size=123;
60 select @@global.host_cache_size;
61