Debian Codegraph @

mysql-test/suite/perfschema/r/hostcache_peer_addr.result

raw
1 flush status;
2 TRUNCATE TABLE performance_schema.host_cache;
3 flush user_resources;
4 flush privileges;
5 select @@global.debug;
6 @@global.debug
7
8 select @@global.max_connect_errors;
9 @@global.max_connect_errors
10 100
11 select @@global.max_user_connections;
12 @@global.max_user_connections
13 0
14 select @@global.max_connections;
15 @@global.max_connections
16 151
17 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
18 User Host
19 select `User`, `Host` from mysql.`user` where `user` like '192.%';
20 User Host
21 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
22 User Host
23 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
24 User Host
25 show global status like "connection_errors_%";
26 Variable_name Value
27 Connection_errors_accept 0
28 Connection_errors_internal 0
29 Connection_errors_max_connections 0
30 Connection_errors_peer_address 0
31 Connection_errors_select 0
32 Connection_errors_tcpwrap 0
33 select "Con1 is alive";
34 Con1 is alive
35 Con1 is alive
36 select current_user();
37 current_user()
38 root@localhost
39 set global debug= "+d,vio_peer_addr_error";
40 ERROR HY000: Can't get hostname for your address
41 show global status like "connection_errors_%";
42 Variable_name Value
43 Connection_errors_accept 0
44 Connection_errors_internal 0
45 Connection_errors_max_connections 0
46 Connection_errors_peer_address 1
47 Connection_errors_select 0
48 Connection_errors_tcpwrap 0
49 "Dumping performance_schema.host_cache"
50 ERROR HY000: Can't get hostname for your address
51 show global status like "connection_errors_%";
52 Variable_name Value
53 Connection_errors_accept 0
54 Connection_errors_internal 0
55 Connection_errors_max_connections 0
56 Connection_errors_peer_address 2
57 Connection_errors_select 0
58 Connection_errors_tcpwrap 0
59 "Dumping performance_schema.host_cache"
60 set global debug= default;
61 flush status;
62 show global status like "connection_errors_%";
63 Variable_name Value
64 Connection_errors_accept 0
65 Connection_errors_internal 0
66 Connection_errors_max_connections 0
67 Connection_errors_peer_address 0
68 Connection_errors_select 0
69 Connection_errors_tcpwrap 0