Debian Codegraph @

mysql-test/suite/perfschema/t/socket_instances_func.test

raw
1 #
2 # Some functional checks for the content of performance_schema.socket_instances.
3 #
4
5 --source include/not_windows.inc
6
7 # Set this to enable debugging output
8 let $my_socket_debug= 0;
9
10 #
11 # Set IP address defaults with respect to IPV6 support
12 #
13
14 # Determine if IPV6 supported
15 let $check_ipv6_just_check= 1;
16 --source include/check_ipv6.inc
17
18 # Determine if IPV4 mapped to IPV6 supported
19 let $check_ipv4_mapped_just_check= 1;
20 --source include/check_ipv4_mapped.inc
21
22 --source include/add_extra_root_users.inc
23
24 let $my_localhost= 127.0.0.1;
25
26 if($check_ipv6_supported)
27 {
28 let $my_localhost= ::1;
29 }
30
31 if($check_ipv4_mapped_supported)
32 {
33 let $my_localhost= ::ffff:127.0.0.1;
34 }
35
36 if($my_socket_debug)
37 {
38 --echo IPV6=$check_ipv6_supported, IPV4_MAPPED=$check_ipv4_mapped_supported, LOCALHOST=$my_localhost
39 }
40
41 #
42 # Preserve the current state of SOCKET_INSTANCES
43 #
44
45 --echo # Take a snapshot of SOCKET_INSTANCES
46 CREATE TEMPORARY TABLE my_socket_instances AS
47 SELECT * FROM performance_schema.socket_instances;
48
49 --echo # Get thread id of the default connection
50 SELECT THREAD_ID INTO @thread_id
51 FROM performance_schema.threads
52 WHERE PROCESSLIST_ID = CONNECTION_ID();
53
54 let $con0_thread_id= `SELECT @thread_id`;
55
56 #
57 # ESTABLISH TCP/IP CONNECTION 1
58 #
59 # Start connection with IP = localhost (127.0.0.1 or ::1)
60
61 --echo # Establish local TCP/IP connection (con1,localhost,root,,test,,)
62 --disable_query_log ONCE
63 --connect (con1,$my_localhost,root,,test,,$MASTER_MYPORT)
64
65 if($my_socket_debug)
66 {
67 # --replace_result '::ffff:127.0.0.1' <LOCALHOST> '127.0.0.1' <LOCALHOST> '::1' <LOCALHOST> '::' <BINDADDR> '0.0.0.0' <BINDADDR>
68 SELECT * FROM performance_schema.socket_instances;
69 }
70
71 --echo # Store the thread id of connection 1 (tcp/ip)
72 SELECT THREAD_ID INTO @thread_id
73 FROM performance_schema.threads
74 WHERE PROCESSLIST_ID = CONNECTION_ID();
75
76 --echo # Store the port of connection 1 (tcp/ip)
77 eval SELECT PORT INTO @port
78 FROM performance_schema.socket_instances
79 WHERE THREAD_ID = @thread_id;
80
81 let $con1_thread_id= `SELECT @thread_id`;
82 let $con1_port= `SELECT @port`;
83
84 --echo # Switch to connection default
85 --connection default
86
87 #
88 # ESTABLISH TCP/IP CONNECTION 2
89 #
90 # Start a second connection with IP = localhost (127.0.0.1 or ::1)
91
92 --echo # Establish second local TCP/IP connection (con1,localhost,root,,test,,)
93 --disable_query_log ONCE
94 --connect (con2,$my_localhost,root,,test,,$MASTER_MYPORT)
95
96 if($my_socket_debug)
97 {
98 # --replace_result '::ffff:127.0.0.1' <LOCALHOST> '127.0.0.1' <LOCALHOST> '::1' <LOCALHOST> '::' <BINDADDR> '0.0.0.0' <BINDADDR>
99 SELECT * FROM performance_schema.socket_instances;
100 }
101
102 --echo # Store the thread_id of connection 2 (tcp/ip)
103 SELECT THREAD_ID INTO @thread_id
104 FROM performance_schema.threads
105 WHERE PROCESSLIST_ID = CONNECTION_ID();
106
107 --echo # Store the port of connection 2 (tcp/ip)
108 eval SELECT PORT INTO @port
109 FROM performance_schema.socket_instances
110 WHERE THREAD_ID = @thread_id;
111
112 let $con2_thread_id= `SELECT @thread_id`;
113 let $con2_port= `SELECT @port`;
114
115 --echo # Switch to connection default
116 --connection default
117
118 #
119 # ESTABLISH LOCAL UNIX DOMAIN CONNECTION
120 #
121 # Connect via mysql sock file
122
123 --echo # Establish local unix domain connection (con3,localhost,root,,test,,)
124 --connect(con3,localhost,root,,test,,)
125
126 if($my_socket_debug)
127 {
128 # --replace_result '::ffff:127.0.0.1' <LOCALHOST> '127.0.0.1' <LOCALHOST> '::1' <LOCALHOST> '::' <BINDADDR> '0.0.0.0' <BINDADDR>
129 SELECT * FROM performance_schema.socket_instances;
130 }
131
132 --echo # Store the thread id of connection 3 (unix domain)
133 SELECT THREAD_ID INTO @thread_id
134 FROM performance_schema.threads
135 WHERE PROCESSLIST_ID = CONNECTION_ID();
136
137 --echo # Store the port of connection 3 (unix domain)
138 eval SELECT PORT INTO @port
139 FROM performance_schema.socket_instances
140 WHERE THREAD_ID = @thread_id;
141
142 let $con3_port= `SELECT @port`;
143 let $con3_thread_id= `SELECT @thread_id`;
144
145 --echo # Switch to connection default
146 --connection default
147
148 #
149 # VERIFY EVENT NAMES
150 #
151
152 --echo # EVENT_NAME is the "wait/io/socket/*" instrument identifier.
153
154 SELECT COUNT(*) = 0 AS "Expect 1"
155 FROM performance_schema.socket_instances
156 WHERE EVENT_NAME NOT LIKE 'wait/io/socket/%';
157
158 #
159 # VERIFY UNIQUE EVENT IDs
160 #
161
162 --echo # OBJECT_INSTANCE_BEGIN is an arbitrary identifier, guaranteed to be unique.
163
164 SELECT COUNT(*) = COUNT(DISTINCT OBJECT_INSTANCE_BEGIN) AS "Expect 1"
165 FROM performance_schema.socket_instances;
166
167 #
168 # VERIFY UNIQUE SOCKET ID
169 #
170
171 --echo # SOCKET_ID is the internal file handle assigned to the socket.
172
173 SELECT COUNT(*) = COUNT(DISTINCT SOCKET_ID) AS "Expect 1"
174 FROM performance_schema.socket_instances;
175
176 #
177 # VERIFY UNIQUE THREAD IDs
178 #
179
180 --echo # Characteristics per our thread
181 --echo # There must be only one entry with our thread_id
182
183 --disable_query_log ONCE
184 eval SET @thread_id= $con0_thread_id;
185
186 eval SELECT COUNT(*) = 1 AS 'Expect 1'
187 FROM performance_schema.socket_instances
188 WHERE THREAD_ID = @thread_id;
189
190 #
191 # VERIFY UNIQUE PORT NUMBERS FOR TCP/IP CLIENTS
192 #
193
194 --echo # TCP/IP connections should have a unique port number
195 --disable_query_log ONCE
196 eval SET @port= $con1_port;
197
198 --echo # Connection 1 (tcp/ip)
199 eval SELECT COUNT(*) = 1 AS 'Expect 1'
200 FROM performance_schema.socket_instances
201 WHERE PORT = @port;
202
203 --disable_query_log ONCE
204 eval SET @port= $con2_port;
205
206 --echo # Connection 2 (tcp/ip)
207 eval SELECT COUNT(*) = 1 AS 'Expect 1'
208 FROM performance_schema.socket_instances
209 WHERE PORT = @port;
210
211 #
212 # VERIFY CONNECTION DETAILS FOR THE DEFAULT CONNECTION
213 #
214
215 --echo # Check the content for the default connection (unix domain)
216 # EVENT_NAME OBJECT_INSTANCE_BEGIN THREAD_ID SOCKET_ID IP PORT STATE
217 # wait/io/socket/sql/client_connection 139799531958280 16 37 0 ACTIVE
218
219 --disable_query_log ONCE
220 eval SET @thread_id = $con0_thread_id;
221
222 SELECT COUNT(*) = 1 as 'Expect 1'
223 FROM performance_schema.socket_instances
224 WHERE EVENT_NAME = 'wait/io/socket/sql/client_connection'
225 AND PORT = 0 AND THREAD_ID = @thread_id;
226
227 #
228 # VERIFY SERVER LISTENING SOCKET, TCP/IP
229 #
230
231 --echo # Characteristics of 'server_tcpip_socket' entry
232 --echo # Server listening socket, TCP/IP
233 --echo # There is only one entry with 'wait/io/socket/sql/server_tcpip_socket'.
234 --echo # It shares the same thread id as 'wait/io/socket/sql/server_unix_socket'.
235
236 SELECT COUNT(*) = 1 AS 'Expect 1'
237 FROM performance_schema.socket_instances
238 WHERE EVENT_NAME = 'wait/io/socket/sql/server_tcpip_socket';
239
240 # Store the thread id of server_tcpip_socket
241 --echo # Get the 'server_tcpip_socket' thread id
242
243 SELECT THREAD_ID INTO @thread_id
244 FROM performance_schema.socket_instances
245 WHERE EVENT_NAME = 'wait/io/socket/sql/server_tcpip_socket';
246
247 let $server_tcpip_thread_id= `SELECT @thread_id`;
248
249 --echo # Check the content.
250 --disable_query_log ONCE
251 eval SET @port = $MASTER_MYPORT;
252
253 eval SELECT THREAD_ID = @thread_id
254 AND (IP = '0.0.0.0' OR IP = '::')
255 AND PORT = @port
256 AND STATE = 'ACTIVE' AS 'Expect 1'
257 FROM performance_schema.socket_instances
258 WHERE EVENT_NAME = 'wait/io/socket/sql/server_tcpip_socket';
259
260 #
261 # VERIFY SERVER LISTENING SOCKET, UNIX DOMAIN
262 #
263
264 --echo # Characteristics of 'server_unix_socket' entry
265 --echo # Server listening socket, unix domain (socket file)
266 --echo # There is only one entry with 'wait/io/socket/sql/server_unix_socket'.
267 --echo # It shares the same thread id as 'wait/io/socket/sql/server_tcpip_socket'.
268
269 SELECT COUNT(*) = 1 AS 'Expect 1'
270 FROM performance_schema.socket_instances
271 WHERE EVENT_NAME = 'wait/io/socket/sql/server_unix_socket';
272
273 # Store the thread id of 'server_unix_socket'
274 --echo # Get the 'server_unix_socket' thread id
275
276 SELECT THREAD_ID INTO @thread_id
277 FROM performance_schema.socket_instances
278 WHERE EVENT_NAME = 'wait/io/socket/sql/server_unix_socket';
279
280 let $server_unix_thread_id= `SELECT @thread_id`;
281
282 --echo # Check the content.
283 eval SELECT THREAD_ID = @thread_id
284 AND IP = ''
285 AND PORT = 0
286 AND STATE = 'ACTIVE' AS 'Expect 1'
287 FROM performance_schema.socket_instances
288 WHERE EVENT_NAME = 'wait/io/socket/sql/server_unix_socket';
289
290 #
291 # VERIFY SERVER LISTENING SOCKET THREAD IDs
292 #
293
294 --echo # Server listening sockets (TCP and Unix) are handled on the same thread
295
296 --disable_query_log ONCE
297 eval SET @thread_id = $server_tcpip_thread_id;
298
299 eval SELECT COUNT(*) = 2 AS 'Expect 1'
300 FROM performance_schema.socket_instances
301 WHERE THREAD_ID = @thread_id;
302
303 --disable_query_log ONCE
304 eval SET @thread_id = $server_unix_thread_id;
305
306 eval SELECT COUNT(*) = 2 AS 'Expect 1'
307 FROM performance_schema.socket_instances
308 WHERE THREAD_ID = @thread_id;
309
310 --echo #Compare server listener socket thread ids
311 --disable_query_log ONCE
312 eval SELECT ($server_tcpip_thread_id = $server_unix_thread_id) into @match_thread_id;
313
314 select @match_thread_id;
315
316 #
317 # VERIFY TCP/IP CLIENT CONNECTION 1
318 #
319
320 # EVENT_NAME OBJECT_INSTANCE_BEGIN THREAD_ID SOCKET_ID IP PORT STATE
321 # wait/io/socket/sql/client_connection 140707865187120 18 59 127.0.0.1 59298 IDLE or ACTIVE
322
323 --echo # Check content for client connection 1 (tcpip)
324
325 --disable_query_log
326 eval SET @port = $con1_port;
327 eval SET @thread_id = $con1_thread_id;
328 eval SET @addr = '$my_localhost';
329 --enable_query_log
330
331 eval SELECT EVENT_NAME = 'wait/io/socket/sql/client_connection'
332 AND (IP LIKE '%127.0.0.1' OR IP = '::1')
333 AND PORT = @port
334 AS 'Expect 1'
335 FROM performance_schema.socket_instances
336 WHERE THREAD_ID = @thread_id;
337
338 --echo # Characteristics of entries with THREAD_ID of con1
339 --echo # There is only one entry with this id.
340
341 eval SELECT COUNT(*) = 1 AS 'Expect 1'
342 FROM performance_schema.socket_instances
343 WHERE THREAD_ID = @thread_id;
344
345 #
346 # VERIFY TCP/IP CLIENT CONNECTION 2
347 #
348
349 # EVENT_NAME OBJECT_INSTANCE_BEGIN THREAD_ID SOCKET_ID IP PORT STATE
350 # wait/io/socket/sql/client_connection 140707865187120 18 59 127.0.0.1 59298 IDLE or ACTIVE
351
352 --echo # Check content for client connection 2 (tcpip)
353
354 --disable_query_log
355 eval SET @port = $con2_port;
356 eval SET @thread_id = $con2_thread_id;
357 eval SET @addr = '$my_localhost';
358 --enable_query_log
359
360 eval SELECT EVENT_NAME = 'wait/io/socket/sql/client_connection'
361 AND (IP LIKE '%127.0.0.1' OR IP = '::1')
362 AND PORT = @port
363 AS 'Expect 1'
364 FROM performance_schema.socket_instances
365 WHERE THREAD_ID = @thread_id;
366
367 --echo # Characteristics of entries with THREAD_ID of con2
368 --echo # There is only one entry with this id.
369
370 eval SELECT COUNT(*) = 1 AS 'Expect 1'
371 FROM performance_schema.socket_instances
372 WHERE THREAD_ID = @thread_id;
373
374 #
375 # VERIFY LOCAL CONNECTION, UNIX DOMAIN
376 #
377
378 # EVENT_NAME OBJECT_INSTANCE_BEGIN THREAD_ID SOCKET_ID IP PORT STATE
379 # wait/io/socket/sql/client_connection 139799531958280 16 37 0 IDLE or ACTIVE
380
381 --echo # Check the content for client connection 3 (unix domain).
382
383 --disable_query_log ONCE
384 eval SET @thread_id = $con3_thread_id;
385
386 eval SELECT EVENT_NAME = 'wait/io/socket/sql/client_connection'
387 AND IP = ''
388 AND PORT = 0
389 AS 'Expect 1'
390 FROM performance_schema.socket_instances
391 WHERE THREAD_ID = @thread_id;
392
393 --echo # Characteristics of entries with THREAD_ID of con3
394 --echo # There is only one entry with this id.
395
396 eval SELECT COUNT(*) = 1 AS 'Expect 1'
397 FROM performance_schema.socket_instances
398 WHERE THREAD_ID = @thread_id;
399
400 #
401 # LIST CLIENT CONNECTIONS
402 #
403
404 --echo # Show differences to socket_instances before con1, con2 and con3 connecting
405 let $part=
406 FROM performance_schema.socket_instances
407 WHERE (EVENT_NAME,OBJECT_INSTANCE_BEGIN,THREAD_ID,SOCKET_ID,IP,PORT,STATE)
408 NOT IN (SELECT EVENT_NAME,OBJECT_INSTANCE_BEGIN,THREAD_ID,SOCKET_ID,IP,PORT,STATE
409 FROM my_socket_instances)
410 ORDER BY THREAD_ID;
411 --replace_result '::ffff:127.0.0.1' <LOCALHOST> '127.0.0.1' <LOCALHOST> '::1' <LOCALHOST> '::' <BINDADDR> '0.0.0.0' <BINDADDR>
412 eval
413 SELECT EVENT_NAME, IP
414 $part;
415
416 --connection default
417
418 #
419 # DROP CLIENT CONNECTIONS
420 #
421
422 --echo # Disconnect con1, con2 and con3
423 --connection con1
424 --disconnect con1
425 --source include/wait_until_disconnected.inc
426 --connection con2
427 --disconnect con2
428 --source include/wait_until_disconnected.inc
429 --connection con3
430 --disconnect con3
431 --source include/wait_until_disconnected.inc
432 --connection default
433
434 #
435 # VERIFY CONNECTIONS DROPPED
436 #
437
438 --echo # After waiting a bit we should have no differences to socket_instances
439 --echo # before con1, con2, con3 connecting.
440 let $wait_timeout= 10;
441 let $wait_condition= SELECT COUNT(*) = 0 $part;
442 --source include/wait_condition.inc
443 #
444 eval
445 SELECT *
446 $part;
447
448 --source include/remove_extra_root_users.inc