Debian Codegraph @

mysql-test/suite/sys_vars/r/host_cache_size_basic.result

raw
1 select @@global.host_cache_size;
2 @@global.host_cache_size
3 123
4 select @@session.host_cache_size;
5 ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable
6 show global variables like 'host_cache_size';
7 Variable_name Value
8 host_cache_size 123
9 show session variables like 'host_cache_size';
10 Variable_name Value
11 host_cache_size 123
12 select * from performance_schema.global_variables
13 where variable_name='host_cache_size';
14 VARIABLE_NAME VARIABLE_VALUE
15 host_cache_size 123
16 select * from performance_schema.session_variables
17 where variable_name='host_cache_size';
18 VARIABLE_NAME VARIABLE_VALUE
19 host_cache_size 123
20 set global host_cache_size=1;
21 select @@global.host_cache_size;
22 @@global.host_cache_size
23 1
24 set global host_cache_size=12;
25 select @@global.host_cache_size;
26 @@global.host_cache_size
27 12
28 set global host_cache_size=0;
29 select @@global.host_cache_size;
30 @@global.host_cache_size
31 0
32 set global host_cache_size=65536;
33 select @@global.host_cache_size;
34 @@global.host_cache_size
35 65536
36 set session host_cache_size=1;
37 ERROR HY000: Variable 'host_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
38 set global host_cache_size=-1;
39 Warnings:
40 Warning 1292 Truncated incorrect host_cache_size value: '-1'
41 select @@global.host_cache_size;
42 @@global.host_cache_size
43 0
44 set global host_cache_size=-1024;
45 Warnings:
46 Warning 1292 Truncated incorrect host_cache_size value: '-1024'
47 select @@global.host_cache_size;
48 @@global.host_cache_size
49 0
50 set global host_cache_size=65537;
51 Warnings:
52 Warning 1292 Truncated incorrect host_cache_size value: '65537'
53 select @@global.host_cache_size;
54 @@global.host_cache_size
55 65536
56 set global host_cache_size=100000;
57 Warnings:
58 Warning 1292 Truncated incorrect host_cache_size value: '100000'
59 select @@global.host_cache_size;
60 @@global.host_cache_size
61 65536
62 set global host_cache_size=4294967295;
63 Warnings:
64 Warning 1292 Truncated incorrect host_cache_size value: '4294967295'
65 select @@global.host_cache_size;
66 @@global.host_cache_size
67 65536
68 set global host_cache_size=123;
69 select @@global.host_cache_size;
70 @@global.host_cache_size
71 123