Debian Codegraph @

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

raw
1 # Take a snapshot of SOCKET_INSTANCES
2 CREATE TEMPORARY TABLE my_socket_instances AS
3 SELECT * FROM performance_schema.socket_instances;
4 # Get thread id of the default connection
5 SELECT THREAD_ID INTO @thread_id
6 FROM performance_schema.threads
7 WHERE PROCESSLIST_ID = CONNECTION_ID();
8 # Establish local TCP/IP connection (con1,localhost,root,,test,,)
9 # Store the thread id of connection 1 (tcp/ip)
10 SELECT THREAD_ID INTO @thread_id
11 FROM performance_schema.threads
12 WHERE PROCESSLIST_ID = CONNECTION_ID();
13 # Store the port of connection 1 (tcp/ip)
14 SELECT PORT INTO @port
15 FROM performance_schema.socket_instances
16 WHERE THREAD_ID = @thread_id;
17 # Switch to connection default
18 # Establish second local TCP/IP connection (con1,localhost,root,,test,,)
19 # Store the thread_id of connection 2 (tcp/ip)
20 SELECT THREAD_ID INTO @thread_id
21 FROM performance_schema.threads
22 WHERE PROCESSLIST_ID = CONNECTION_ID();
23 # Store the port of connection 2 (tcp/ip)
24 SELECT PORT INTO @port
25 FROM performance_schema.socket_instances
26 WHERE THREAD_ID = @thread_id;
27 # Switch to connection default
28 # Establish local unix domain connection (con3,localhost,root,,test,,)
29 # Store the thread id of connection 3 (unix domain)
30 SELECT THREAD_ID INTO @thread_id
31 FROM performance_schema.threads
32 WHERE PROCESSLIST_ID = CONNECTION_ID();
33 # Store the port of connection 3 (unix domain)
34 SELECT PORT INTO @port
35 FROM performance_schema.socket_instances
36 WHERE THREAD_ID = @thread_id;
37 # Switch to connection default
38 # EVENT_NAME is the "wait/io/socket/*" instrument identifier.
39 SELECT COUNT(*) = 0 AS "Expect 1"
40 FROM performance_schema.socket_instances
41 WHERE EVENT_NAME NOT LIKE 'wait/io/socket/%';
42 Expect 1
43 1
44 # OBJECT_INSTANCE_BEGIN is an arbitrary identifier, guaranteed to be unique.
45 SELECT COUNT(*) = COUNT(DISTINCT OBJECT_INSTANCE_BEGIN) AS "Expect 1"
46 FROM performance_schema.socket_instances;
47 Expect 1
48 1
49 # SOCKET_ID is the internal file handle assigned to the socket.
50 SELECT COUNT(*) = COUNT(DISTINCT SOCKET_ID) AS "Expect 1"
51 FROM performance_schema.socket_instances;
52 Expect 1
53 1
54 # Characteristics per our thread
55 # There must be only one entry with our thread_id
56 SELECT COUNT(*) = 1 AS 'Expect 1'
57 FROM performance_schema.socket_instances
58 WHERE THREAD_ID = @thread_id;
59 Expect 1
60 1
61 # TCP/IP connections should have a unique port number
62 # Connection 1 (tcp/ip)
63 SELECT COUNT(*) = 1 AS 'Expect 1'
64 FROM performance_schema.socket_instances
65 WHERE PORT = @port;
66 Expect 1
67 1
68 # Connection 2 (tcp/ip)
69 SELECT COUNT(*) = 1 AS 'Expect 1'
70 FROM performance_schema.socket_instances
71 WHERE PORT = @port;
72 Expect 1
73 1
74 # Check the content for the default connection (unix domain)
75 SELECT COUNT(*) = 1 as 'Expect 1'
76 FROM performance_schema.socket_instances
77 WHERE EVENT_NAME = 'wait/io/socket/sql/client_connection'
78 AND PORT = 0 AND THREAD_ID = @thread_id;
79 Expect 1
80 1
81 # Characteristics of 'server_tcpip_socket' entry
82 # Server listening socket, TCP/IP
83 # There is only one entry with 'wait/io/socket/sql/server_tcpip_socket'.
84 # It shares the same thread id as 'wait/io/socket/sql/server_unix_socket'.
85 SELECT COUNT(*) = 1 AS 'Expect 1'
86 FROM performance_schema.socket_instances
87 WHERE EVENT_NAME = 'wait/io/socket/sql/server_tcpip_socket';
88 Expect 1
89 1
90 # Get the 'server_tcpip_socket' thread id
91 SELECT THREAD_ID INTO @thread_id
92 FROM performance_schema.socket_instances
93 WHERE EVENT_NAME = 'wait/io/socket/sql/server_tcpip_socket';
94 # Check the content.
95 SELECT THREAD_ID = @thread_id
96 AND (IP = '0.0.0.0' OR IP = '::')
97 AND PORT = @port
98 AND STATE = 'ACTIVE' AS 'Expect 1'
99 FROM performance_schema.socket_instances
100 WHERE EVENT_NAME = 'wait/io/socket/sql/server_tcpip_socket';
101 Expect 1
102 1
103 # Characteristics of 'server_unix_socket' entry
104 # Server listening socket, unix domain (socket file)
105 # There is only one entry with 'wait/io/socket/sql/server_unix_socket'.
106 # It shares the same thread id as 'wait/io/socket/sql/server_tcpip_socket'.
107 SELECT COUNT(*) = 1 AS 'Expect 1'
108 FROM performance_schema.socket_instances
109 WHERE EVENT_NAME = 'wait/io/socket/sql/server_unix_socket';
110 Expect 1
111 1
112 # Get the 'server_unix_socket' thread id
113 SELECT THREAD_ID INTO @thread_id
114 FROM performance_schema.socket_instances
115 WHERE EVENT_NAME = 'wait/io/socket/sql/server_unix_socket';
116 # Check the content.
117 SELECT THREAD_ID = @thread_id
118 AND IP = ''
119 AND PORT = 0
120 AND STATE = 'ACTIVE' AS 'Expect 1'
121 FROM performance_schema.socket_instances
122 WHERE EVENT_NAME = 'wait/io/socket/sql/server_unix_socket';
123 Expect 1
124 1
125 # Server listening sockets (TCP and Unix) are handled on the same thread
126 SELECT COUNT(*) = 2 AS 'Expect 1'
127 FROM performance_schema.socket_instances
128 WHERE THREAD_ID = @thread_id;
129 Expect 1
130 1
131 SELECT COUNT(*) = 2 AS 'Expect 1'
132 FROM performance_schema.socket_instances
133 WHERE THREAD_ID = @thread_id;
134 Expect 1
135 1
136 #Compare server listener socket thread ids
137 select @match_thread_id;
138 @match_thread_id
139 1
140 # Check content for client connection 1 (tcpip)
141 SELECT EVENT_NAME = 'wait/io/socket/sql/client_connection'
142 AND (IP LIKE '%127.0.0.1' OR IP = '::1')
143 AND PORT = @port
144 AS 'Expect 1'
145 FROM performance_schema.socket_instances
146 WHERE THREAD_ID = @thread_id;
147 Expect 1
148 1
149 # Characteristics of entries with THREAD_ID of con1
150 # There is only one entry with this id.
151 SELECT COUNT(*) = 1 AS 'Expect 1'
152 FROM performance_schema.socket_instances
153 WHERE THREAD_ID = @thread_id;
154 Expect 1
155 1
156 # Check content for client connection 2 (tcpip)
157 SELECT EVENT_NAME = 'wait/io/socket/sql/client_connection'
158 AND (IP LIKE '%127.0.0.1' OR IP = '::1')
159 AND PORT = @port
160 AS 'Expect 1'
161 FROM performance_schema.socket_instances
162 WHERE THREAD_ID = @thread_id;
163 Expect 1
164 1
165 # Characteristics of entries with THREAD_ID of con2
166 # There is only one entry with this id.
167 SELECT COUNT(*) = 1 AS 'Expect 1'
168 FROM performance_schema.socket_instances
169 WHERE THREAD_ID = @thread_id;
170 Expect 1
171 1
172 # Check the content for client connection 3 (unix domain).
173 SELECT EVENT_NAME = 'wait/io/socket/sql/client_connection'
174 AND IP = ''
175 AND PORT = 0
176 AS 'Expect 1'
177 FROM performance_schema.socket_instances
178 WHERE THREAD_ID = @thread_id;
179 Expect 1
180 1
181 # Characteristics of entries with THREAD_ID of con3
182 # There is only one entry with this id.
183 SELECT COUNT(*) = 1 AS 'Expect 1'
184 FROM performance_schema.socket_instances
185 WHERE THREAD_ID = @thread_id;
186 Expect 1
187 1
188 # Show differences to socket_instances before con1, con2 and con3 connecting
189 SELECT EVENT_NAME, IP
190 FROM performance_schema.socket_instances
191 WHERE (EVENT_NAME,OBJECT_INSTANCE_BEGIN,THREAD_ID,SOCKET_ID,IP,PORT,STATE)
192 NOT IN (SELECT EVENT_NAME,OBJECT_INSTANCE_BEGIN,THREAD_ID,SOCKET_ID,IP,PORT,STATE
193 FROM my_socket_instances)
194 ORDER BY THREAD_ID;
195 EVENT_NAME IP
196 wait/io/socket/sql/client_connection <LOCALHOST>
197 wait/io/socket/sql/client_connection <LOCALHOST>
198 wait/io/socket/sql/client_connection
199 # Disconnect con1, con2 and con3
200 # After waiting a bit we should have no differences to socket_instances
201 # before con1, con2, con3 connecting.
202 SELECT *
203 FROM performance_schema.socket_instances
204 WHERE (EVENT_NAME,OBJECT_INSTANCE_BEGIN,THREAD_ID,SOCKET_ID,IP,PORT,STATE)
205 NOT IN (SELECT EVENT_NAME,OBJECT_INSTANCE_BEGIN,THREAD_ID,SOCKET_ID,IP,PORT,STATE
206 FROM my_socket_instances)
207 ORDER BY THREAD_ID;
208 EVENT_NAME OBJECT_INSTANCE_BEGIN THREAD_ID SOCKET_ID IP PORT STATE